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.

Hi,

(a bit late but) here is an example of a flow i use for CSV values:
https://novacura-my.sharepoint.com/:u:/p/ivan_stojiljkovic/ESCZjU6EHbhMumvAkAkGF0cBcMrkR5yvv-8V1y0ZzSAk5w?e=Mt4uXe
(Although not the most elegant solution… it had worked in many projects i copy pasted it to :))

So with a small change i made to input ~ as delimiter it turns this:
grafik
Into this:

Hope this helps

B R
Ivan

1 Like

Hi,

I was going through this topic but some step details are not to detailed inside.
starting from CSVFILLDETAIL element in teh workflow.

Request you to please provide some details how they are created so that as a newbie I can redo.

Thnaks in advance !!!
Paul

Hi, not sure I understand your question. But if you download Ivan’s example above it might perhaps give some hints. Or we can talk about it next week.