Forum Discussion
Split string with delimiters in two columns and align them based on their sequence
Thank you.. Will test this out but what is the long text string in that code (binary.fromtext ?)
Appreciate help!
- gmsamborn
Super User
Hi Anonymous
That long string is how data from "Enter Data" is kept. Just ignore it.
I couldn't figure out what that long test was and not sure what to replace it with or what a clean code would look like. I have not used "let" logic before. amitchandak if you could attach the workbook, that would be awesome.
Just as an intermin solution, here's what I did.
First split the concatenated strings using comma as the delimited and used substitute to remove [ and quotes. Used Pathitem(Substitute function and had 8 distinct columns for names and emails each. Concatenated them again to have 1:1 match with name and email. Hence, got 8 distinct columns for Name-Email1, Name-Email2 etc.
Then created a new table and used UNION(SUMMARIZE to have ID in the first column and Name-Email in the second column. Then split the Name and Email into 2 distinct columns. I tested with changing values in the underlying CSV file and it works well. The problem is that it creates blank rows in between.. maybe I can setup a filter to remove the blanks.
However, I would still prefer to use amitchandak 's method since it will get rid of multiple steps. Thanks!
