Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a file delimited by pipe where the structure is the following:
-The first line has the ID number 1 in the first column and also has 5 more fields (only the first line of the file can contain the number 1).
-Multiple lines with the number 2 in the first column and also has 18 more fields.
-Multiple lines with the number 3 in the first column and also has 13 more fields.
What should I do to ensure that the file structure is valid and does not go to tMAp or the database until this is guaranteed and each line has the number of fields it needs?
Thanks!
Hello,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina