Forum Discussion

philliperamos's avatar
philliperamos
Contributor
6 years ago
Solved

Read a CSV file from the Right to Left

Good day community.
I have a CSV file, see attached, which I would like to pick up the last three fields from the right as their own fields, and the rest of the record/line as a “value” field.
sampleData.txt (80 Bytes)

So basically, the output should be
[value] [row] [pipeID] [date]
where is the remainder of the data in the row.

Is this possible?
Thanks