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?
Solved! Go to Solution.
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
@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
So I tried that way but seems the Full Mail column is not taking data in just that single row
Any suggestion @OllieClarke @irawatt?
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.
Hi @OllieClarke & @kinga thank you very much for your solutions
really appreciate your help this community is amazing indeed 😃