Hi all,
I need help to convert the text file to excel.
I've already made a workflow to convert the text file but my output seems trim or cut the sentences.
This is my output,
This is my desired output,
Although the columns are correct but it cut the sentences or word.
Please help. I've attached the workflow and the sample source.
@DavidP Thanks for the previous help.
Solved! Go to Solution.
Hi @RichardAlt , I have made some changes to your workflow. Here is the attached screenshot along with the workflow.
Try this I hope this works out for you.
OMG! Thank you so much! It's working thank you thank you!
@RichardAlt You're most welcome. 🙂
Hi @grazitti_sapna ,
I have a new question what about I use this source file.
How can I adjust the workflow that you've modified.
Sorry I'm quite new using alteryx.
This is my desire output using the attached source file. Disregard the strike.
NONPAR FOREIGN(OFFSHORE) | ||||
NONPAR FOREIGN(OFFSHORE) | 1,123.00 | 12,123.12 | 1,123.12 | 12,123.12 |
NONPAR LOCAL(ONSHORE) | ||||
NONPAR LOCAL(ONSHORE) | 123,123.12 | 123,123.12 | 123,123.12 | 1,123,123.12 |
PAR 5 | ||||
PAR 5 | 1,123,123.12 | 12,123,123.12 | 12,123,123.12 | 12,123,123.12 |
PAR AFTER 2005 | ||||
PAR AFTER 2005 | 0 | 0 | 0 | 1,123,123.12 |
PAR BEFORE 2005 | ||||
PAR BEFORE 2005 | 0 | 0 | 0 | 1,123,123.12 |
PAR JH | ||||
PAR JH | 0 | 0 | 0 | 123,123.12 |
TotalOutstanding: | 1,123,123.12 | 12,123,123.12 | 12,123,123.12 | 12,123,123.12 |
@RichardAlt , the regex created earlier will work on the files having similar template to the file shared earlier, for this one you need to create another regex to make it work.
Hi @grazitti_sapna,
I've tried to follow this link
But I don't know what combination of regex should I use.
Do you have any samples?
Thank you.
@RichardAlt I have prepared a workflow required some alteration. Please find the attached workflow.