Support Topics Documentation Slack YouTube Blog

CSV file dealing with \n

I’m working with an API who return a CSV format and I need to exchange the “new line” \n invisible character to a simple " " space. It’s possible to use the TEXT occurrence ?

This must be the correct format after the “magic”.
Thanks, Mario

Screen Shot 2021-05-28 at 20.30.01

Hello @Mario_Ghersi

You can use the following component in the Codeless logic for UI-builder to change the value

Regards,
Inna

Dear @Inna_Shkolnaya

Thanks first time I used RegExp no idea what was that and now I learned and was a perfect solution.

I need to clear the new line and also clear the spaces I found at start and at end.
Thanks, again and happy coding this community is the BEST!
Mario

1 Like