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/.
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.
Hi,
I will use “Regeex Split” node with this patern: ^([^\s]+)(.*)
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.