.txt File Data Issue

[KUSHBHATT]

Hi guys,

I have this below-given data in Notepad .txt file and I want to parse this data by using "|" as a delimiter

But the main issue is because of whitespace the Full mail column gets divided into 2 or more columns rather than 1 column.

Name|Bank ID|Bank Name|Full Mail
Raj|65424|ghjgjbv|Hi This is Dany I need your help

Could you help in getting Bank ID for ABC Bank?|
Alex|841238|bkgvjg|Hi Team,
I would like ID info before we process that!

Can we get any updates on that?|
Brian|24882|ghjgjmb|

Hi Greg should we connect over a call?

I have some issues in solving reporting|
Dany|6784548|hfgjgv| Hi Joe,

Lets take a small break

see ya later|

so the requirement is to get all headers and their details in relevant rows & columns but Full Mail column data split into many rows & columns

I am very new to Altery designer so can anyone help me with this?

[IraWatt]

Hey @KUSHBHATT,

If you just put a | in the text as the text to column tools delimiter it should only split on | and not white space:

Any questions or issues please ask.

Ira Watt
Technical Consultant
Watt@Bulien.com 

[OllieClarke]

@KUSHBHATT to use @IraWatt's solution, read in the .txt file as an un-delimited text file. You'll want to untick 'First Row Contains Field Names' and also increase the Field Length

Hope that helps,

Ollie

[KUSHBHATT]

So I tried that way but seems the Full Mail column is not taking data in just that single row

Any suggestion @OllieClarke  @irawatt?

[Kinga]

hi @KUSHBHATT 

I also received similar out put as you from Input Tool. Not sure how to change settings in Input Tool, but prepare a workflow to get rid of it:

Quite long, maybe someone has better suggestion.

[OllieClarke · Accepted solution]

@KUSHBHATT ah, sorry, missed that bit. Try this:

[KUSHBHATT]

Hi @OllieClarke & @kinga thank you very much for your solutions

really appreciate your help this community is amazing indeed 😃