Hi Team I have a text column in the dataset like this:
users are asking if we can modify this text column to make sure ‘Each item (currently separated with ‘;’) in the recommendation insights should be its own line but in the same cell’ .
Would you please help if we can achieve that?
Thanks, Cindy
@Cindy ,
Maybe you can try using a combination of split and concat functions.
concat("Level A: ", split(arn,":",1) , " ", "Level B: ", split(arn,":",2)," ", "Level C: ", split(arn,":",3)," ", "Level D: ", split(arn,":",4)," ", "Level E: ", split(arn,":",5))
Kind regards, Koushik