I have a TXT file that I am trying to convert to xlsx that is delimited by both tab and tilde. I have done this one with delimiter but not with two. I’ve used the ‘Read CSV’ activity in the past with a simple delimiter but in this case tilde is not an option, neither is multiple delimiters. Looking for suggestions on how to do this. Thank you!
give a try on split/replace tab and tilde to a common delimeter with the help of regex
then pass it to generate datatable activity
do you have some sample lines for reference?
Hope the following sample helps you.
Sample20211216-1.zip (2.4 KB)
This worked perfectly! Thank you so much, I appreciate your help!
The example below worked for me. Thank you for your response!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.