Txt file to table

Flow Product
1

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:

image
image1232×144 2.76 KB

image
image1165×443 7.96 KB

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.

2

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.