Txt file to table

I have data in a text file with the following delimeter ‘~’
I split it with ‘\n’ and I have rows that look like this
“x~x~x~x…”
So I want to split those rows with ‘~’

I tried doing it in a flowscript step but I’m getting some errors:


And if I try doing it in an assignment step with {Split(row, “~”)} I get another error “The given parameter is of the wrong type”.

I’m not sure how to get this done.

Hi,
see if perhaps this article can help you:

it’s using csvfill rather than split, but I think it acheives what you are after.