My data is delimited by say Pipe (|), and some fields of the data end in a backslash, and the delimiter seems to be escaped. I have control on what delimits the data, but not how the data ends in. Is there a work around for this?
Take a look at the split command,
Then you would have to use mvindex
Think I might have misinterpreted the question, if the above is what you're looking for, great.
If not, I'd suggest you use a regex to split the fields, I can provide more help if you confirm which is the answer you're looking for