Split column tool : optionnaly specify the number of output, split to row, ignore delimiter in quote/bracket/parenthesis...

[simonaubertbd]

Hello,

I like the idea of having a split column dedicated tool. As of today, you're allowed to choose the delimiter. I would like a few more options :
-optionnaly specify the number of output (because sometimes you only need the first 2)
-split to row (one of my favorite, very powerful)
-ignore delimiter in quote/bracket/parenthesis... because half the time, when you're in this situation, it's because the field comes from a technical field.

For information, on Alteryx again ;)

Best regards,

Simon

[tgourdel]

Thanks Simon, all good points.
Didn't know "split to row" was a thing, what would be an example of this being useful (for my curiosity)?

[simonaubertbd]

@tgourdel for the split to row, let's say you have this data as input with a concatenation of tags in one field

You can obtain a row by tag as output :

So that it allows you to do actions according to tag value (such as filtering)

Best regards,

Simon

[tgourdel]

Wow interesting :) thanks for the example!!

[amoradell]

Don't know if it's the right place, but could it be possible to add regex option ?
https://pandas.pydata.org/docs/reference/api/pandas.Series.str.split.html

[tgourdel]

@amoradell, sure, thanks for the suggestion!

[simonaubertbd]

@tgourdel I see you started to work on this issue. :) There is an error with the split to row option

Best regards,

Simon