I have a sample data where I want to put the city on a different column. Cities can be defined after commas, I can do it with talent, which component should I use?
Here the sample data is my input on the left and should be the correct right output.
< Div class = "post-text" itemprop = "text">
You can use the split function in TMP. Use the code below in the city column, just replace the dwetl address field with your actual column name.
! Relational. ISNUL (row7.dwetl_Address)? Row7.dwetl_Address.split (",") [1]: "Default City"
No comments:
Post a Comment