Convert text file to excel file

[RichardAlt]

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.

[grazitti_sapna · Accepted 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.

[RichardAlt]

OMG! Thank you so much! It's working thank you thank you!

[grazitti_sapna]

@RichardAlt  You're most welcome. 🙂

[RichardAlt]

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

[grazitti_sapna]

@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.

[RichardAlt]

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.

[grazitti_sapna · Accepted solution]

@RichardAlt I have prepared a workflow required some alteration. Please find the  attached workflow.