How do i solve this Misalignment in a datatable

[David_Oku (Master Of Logic)]

Hello guys this data table was generated from a text file which used (^) as its separator or delimiter . The datable generated happened to be misaligned because the delimiter was contained in some columns as parts of the column contents. please how do i solve this … any ideas i am stuck

[Nithinkrishna]

Hey @David_Oku,

Could you please post the original source data

Awaiting your response, Thanks

[David_Oku (Master Of Logic)]

@Nithinkrishna Hello thank you so much … please find attached SampleFile.txt (81.7 KB)

[Nithinkrishna]

What is your actual separator in this please ?

I can see (^) at some place and (^^), (^^^^^) at few places

[David_Oku (Master Of Logic)]

@Nithinkrishna the actual separator is ^ , ^^ means the column is empty. now the problem is that this lines with the word “LAGOS”. i.e LAGOS^TRU1||TAJUDYYN OWOLABI OLAYINKA|TR the (^) just after the ‘LAGOS’ is not supposed to be separator. it supposed to be LAGOS TRU1||TAJUDYYN OWOLABI OLAYINKA^ instead. so the table doesn’t become misaligned.
The separator of the text file is ^ . but this character has been used in between text in one of the columns . hence the generate table activity sees it at that position as a separator

[Nithinkrishna]

Okay, Could you please give me entire symbol explanations please, Like which represents what

So that it will easy to provide a solution

Awaiting your response, Thanks

[Nithinkrishna]

Hey @David_Oku,

Please find the workaround and hope this helps you.

DTGenerator.zip (55.8 KB)

Thanks