flatfile escape character problem

Good Morning Anonymous,

You can't do this nicely.

What you will need is two records

– one having structure WITH last field and delimiter

– the other having structure WITHOUT last field and delimiter

Make each optional. This way if it is not one, it is the other and the definition will have necessary structure to allow parse.

This would allow parse of the file, but problem is this would be a nightmare to map from. You could add another map to consolidate the forked record back to one single record.

Another solution is to preprocess and modify the file and add the missing delimiter when appropriate.

– weak architect