Hi there. I am trying to split multi-valued cells and generate a new row for each character in a specific cell. Is there a way to do this? Any help would be appreciated. Thank you!
Alessandro
Hi there. I am trying to split multi-valued cells and generate a new row for each character in a specific cell. Is there a way to do this? Any help would be appreciated. Thank you!
Alessandro
Hi,
you can split your strings between each character using an empty regex and then join it to a new string using a separator like |
value.split(//).join("|")
Then you can “Split multi-valued cells…” with “|” as the separator.
Best
Michael
Thanks for the quick response. Unfortunately it works but not for special characters such emoji that is transformed in ďż˝.
Any idea? Thanks a lot.
I have no clue. I would transform the emojis to their Unicode counterpart before the import to OR so that I get something generic I can match against with a regex expression.
I’ve never been 100% sure why value.split(//)
works as it does, but it definitely breaks in this case!
I think you can use the following instead:
value.find(/./).join("|")
This should deal with the emojis OK (at least in my testing)
It works! Thank you! You made my day!
Same here with split(//). Thanks for the tip!