I have a flat file that i need to parse. The flat file is a pipe i.e. “|” delimited file.
So i have set up the flat file schema accordingly to parse the file.
The problem is when the character that is used as the delimiter appears as part of the data , how to handle this.
The following is 2 records in a flat file
The above file is parsed correctly.
But what happens if the name in the above file had a pipe(which is the delimiter) i.e. had “tom|” instead of tom1 in which case the file would look as
So how to handle the above file?