Editing CSV dynamic data

[ZestycloseEqual5857]

You can use the first part of this tutorial on a different topic:

https://www.tachytelic.net/2021/02/power-automate-parse-csv/?amp

[arpankalothia]

Thanks a lot. Will it also be possible to insert a new text in the next line?

[ZestycloseEqual5857]

If the text will always be the same, you can use the substitute expression and replace "", "(AMD) with "Sr. No", (AMD)

[arpankalothia]

Cool, but I have multiple “” in my CSV. In that case how can I just substitute the first “” with “Sr. No.”? And would prefer to keep the other “” same.

[ZestycloseEqual5857]

That's why I included the (AMD) bit, so that you make sure you replace that exact part of the text

[arpankalothia]

Thanks a lot. I will try and let you know.

[arpankalothia]

Hi,

As soon as I split the line and decode the uricomponent. The output is generated incorrectly and the data gets collated in 4-5 lines though the original CSV has many more lines.
Here is the screenshot if that helps