Skip to Content
0
Former Member
Sep 19, 2014 at 07:40 AM

File Content Conversion ignore fields

42 Views

HI ,

I need to ignore some rows in the middle of the data in File content conversion for exaple

H1,Field1,Field2,Field3

A,GB07,MICHEL,1000

H2,Field3,Field4,Field5

B,GB08,andrew,2000

The above is the sample text file from the source , I need to parse in the below

RECORDset1

<Field1>A</Field1>

<Field2>MICHEL</Field2>

<Field3>100</Field4>

RecrodSet2

<Field4>A</Field4>

<Field5>andrew</Field5>

<Field6>200</Field6>

I need to omit or ignore the H1 and H2 rows from the File Content conversion.,

Please guide me how to achive this using File Content conversion