Split multi-valued cells

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

1 Like

Thanks for the quick response. Unfortunately it works but not for special characters such emoji that is transformed in �.

Any idea? Thanks a lot.

immagine

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.

1 Like

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)

2 Likes

It works! Thank you! You made my day!

Same here with split(//). Thanks for the tip!

1 Like