AnsweredAssumed Answered

Parsing a file

Question asked by vijay.bontapalli137242 on Mar 28, 2016
Latest reply on Mar 28, 2016 by Lee Sobotkin

I have a file that looks like below....

Line 1: Filename

Line 2: Empty

Line 3: File header with 10 columns delimited by "|"

Line 4 to N: Values for each column

 

I am trying to create a Flat File Profile in Boomi AtomSphere by importing the file. Import process is throwing error as first line has only 1 column and 3rd line onwards has 10 columns.

Is there a possibility to skip first 2 lines, created profile for lines 3 to N, with line 3 as header.

 

Thanks in advance.

Outcomes