Replace value in a set of data.

(0) Share

Report

Posted on by Emejcz

Hello.

Once I decode base64 which is csv file I get below sample data as Output from Compose:

52233;P00047832-LW01;20
58443;P00047832-LW01;13
53044;P00047832-LW01;14
56127;P00047832-LW01;8
52142;P00047832-LW01;2
509510;P00047832-LW01;19

What I try to achieve is removing 'LW01' and convert it back to base64 and save as .csv file.

Any idea how to loop through each line of that data set to use replace and remove LW01?

I am trying to manipulate with strings/JSON but I am getting more and more steps... maybe there is some easy way to achieve it?
Getting it to collection doesn't seem like a solution since I am not able to loop row by row there.

Categories:

Building flows

I have the same question (0)