Originally posted by: Santanu

Hi,

I have below input file

Header|04222019|abcd||101

5th field (101) has new line character at the end.

Identifier "Header" may or may not come in the input data.

so It can come as below 

04222019|abcd||101

We need to make a generic type tree to read both the above data with identifier and without identifier.

I have made 1st field as identifier "Header" (component rule) with range as 0:1.

Group properties as implict delimited with "|" location as postfix but its giving error at last field.

I have tried with location as infix and prefix as well but its giving error.

Looking forward for any suggestion

Thanks

Santanu

Originally posted by: PaulBrett

You'll need a component rule to ensure that the Header is recognised.  Perhaps you need a simple choice group, that will check for the 4 field style first, then default to 5 field style if 4 is a bust).

If field 1 ('04222019' in the row type that will have 4 fields) is always going to be a number, then perhaps this would do:

TONUMBER($)>0

...then have a second row type, which would then have 5 fields.

Thank you.

Paul

Follow me on Twitter

Originally posted by: Santanu

Thanks Paul for your time and help.

Thanks

Santanu