CSV Upload Data Parsing Wrong due to Double Spaces

[Lili1]

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! 

[AGilbert · Accepted solution]

I think this should help!

[Lili1]

This did solve it, thank you so much for your help!