Create a Resource of LinesFromFile. In the recording studio, use Resource Location to get the file path (keep reuse checked on the resource).
Next, use File System's 'Read File' using the Path from Resource Location.
Load it where ever you need.
How to load CSV file MultiLine
-
@Diya.3rif BAS has internal function csv_parse, but it doesn't handle rows without commas.
So this won't work"AA 11111 11111" "BBB 2222 2222"while this
"AA 11111 11111", "BBB 2222 2222"will work.
Anyway there is regexp support, so you can process text very easy.
This regexp should work for you\"([^\"]+)\"And here is project which solves your problem.
0_1504114213349_MultilineCsvProcess.xml
