I need to open a text file in Excel and using the Text Import Wizard, I need to double click to remove each break line. Is there an activity to do this in Studio in the backend? I have tried reading the text file and saving the output to a string variable then using “Generate Data Table From Text” activity but it does not have the option to remove break lines.
Hi,
Can you share input and expected output as file? It’s no problem if dummy data.
Regards,