Have a look at the Split function or the String.Split (2019R2). Since there are multiple lines in one Excel row you might have to split first by an end of line delimiter. Then, you can iterate through the array and use split again with the column delimiter, the | in your example.
what format is the data in ?
in a spreadsheet ? text file ? or what ?
if youre on windows you can open and read the spreadsheet using the built in excel classes for windows
Eugene has written a book on how to use them which you can get on Xdev’s site
On Mac I use copy/paste, Xojo Clipboard and split EOL for rows and tabs for columns.
Pass the info to a listbox for visualization and if all is ok, then parse the listbox into the db.
I don’t need more because I do this once in a while.
If you constantly need to do this, follow other comments.
Yes, it works fine. I’m using it for several of my personal applications. Even apps ported from API1 to API2 worked (in this regard) without needing modification.