Forum Discussion
How to format string text by delimiter
Hi All, I have the XML string column in my table and I want to structure it to look better, i.e. want to move text to a new row after this character '>' To give you more context, below is wha...
Hi Anonymous , try this:
1.- Split column by delimiter ">":
2.- Tranpose the table:
I hope it works for you, best regards
Thanks, but unfortunately this doesn't work for me as I need to keep the string in one column as shown in my first screenshot. I was hoping that there is a regular expression maybe that could help me.