Parser for Binary: Source Filter Extraction issue in Run Export Map

Posted June 15th, 2009 by psravi

Hi,

I am trying to parse one big input file and here I wanted to use one of Source field to filter out the extract output into delimited CSV file.

The Source field that i am planning to use as filter is of 8 char field ( here it is COBOL field of X(8) )

Whenever I set the Source field value equal to 8 character value(no spaces in 8 char value), the filter is working fine and getting expected result, but when there is space in value, the filter is not working.

Ex : Source Field = TDACOMMN ---> filter working fine.

Source Fiedl = 'BRTSEG ' ---> here source field has 8 char only, but it has 2 spaces in the value.. How to achieve this filter???

any help is appreciated..

Thanks,
James

‹ Microfocus COBOL Data Files Any Tool to parse my COBOL data file contain multiple record types with different schemas or variable-length records. ›

RE: Source Filter Extraction

On June 15th, 2009 jterrell said:

Hi Ravi,

When you reference the source field name in the RIFL filtering expression, use the Trim Function around the source field name...something like this:

Trim(Fields("SourceFieldName")) Like "BRTSEG"

You can read additional details in the online help on this web site for the Extractors and Loaders. Here is a link to the help topic that addresses record filtering:

Transformation Filters

You can also read about the Trim Function in the documentation inside the Data Parser. Simply click on the Help button on the button bar, and when Help opens, enter "trim function" in the Search tab, and double click to open that help topic.

- Jo