Mask a field in a file based on it's length.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

A field in file contains ssn's of a certain length and other values of a different length. How to target just the rows with ssn's that have a specific length. Is there a length function.

Environment

FDM 4.10, 4.11

Resolution

In the FDM WHERE function it is possible to use the following syntax: length( <field name> ) = <length value>
So for example to only mask rows that have a field by the name of "code" and with 2 characters this would be: length(code)=2
See: