Splitting a column on separator, while keeping separator character.

[Neil Hawkins]

Hello,

Does anybody know whether when splitting a column into several columns based a character, is it possible to keep the character when the split is carried out?

Thanks.

[Tom Morris]

I think you should be able to do this by splitting using a RegEx but I'd have to play with it and I'm on the road right  now.

Tom

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Thad Guidry]

Look at partition() GREL command, it allows you to optionally specify (true|false) if you want to keep the separator char.

https://github.com/OpenRefine/OpenRefine/wiki/GREL-String-Functions#partitionstring-s-string-or-regex-frag-optional-boolean-omitfragment

--

-Thad

+ThadGuidry
Thad on LinkedIn

[Neil Hawkins]

Thad, belated thank you for pointing me to partition.

Best,

Neil