Split cell at first delimiter

Hi …

Is there a way to split a cell only on the first delimiter?

I have a row in a table with titles (Mr, Mrs, Judge, Prof, etc.) followed by a surame. I could use the space as a delimiter but some of the surnames contain spaces.

Thanks

tC/.

You can use String Manipulation node.
Find first space using indexOf() function and use result as parameter of substr() function.

4 Likes

Hi,

I will use “Regeex Split” node with this patern: ^([^\s]+)(.*)

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.