The following workflow illustrates a parsing error I'm seeing when reading in CSV files I'm working with. I think the issue is caused by the last column in my data containing our delimiter (the character "|") within the data in that column. In the text input row 6 is the way data should be read in, but above there are circumstances where there is a hard break partitioning data in the last column. I've used the Multi-row formulas to identify which rows in the data set are causing this issue, but I don't know how to append the data in the next row (or subsequent rows lines 4-5) to mimic the row in line 6. I've tried reading in the cvs with no delimiter and have gotten to what I have below, but now need help appending it. I appreciate any suggestions!
Solved! Go to Solution.
This did solve it, thank you so much for your help!