Split string only at first delimiter

[SandraSoniec]

Hi community,

Have a string that contains 2x space. Would like to split the string using ONLY the first space as delimiter. Is this possible or do I have to replace the second space before using the split function?

Thxs in advance.

[ChristianAbata]

hi @SandraSoniec  friend please could you share what you need to split? the original string? 

What I could imagine is something link this :  This is my  string

and what I'll do to split the double space is something like this replace('MYSTRING','  ', ' ') then use split('RESULT BEFORE', ' ')

[SandraSoniec · Accepted solution]

hi @ChristianAbata 

example string "ISO 11137:1995/Amd 1:2001", would like to keep "11137:1995/Amd 1:2001".

experimented with other string expressions and one solution that works is

• calculate indexOf (first space)
• calculate length(ISO 11137:1995/Amd 1:2001)
• substring(ISO 11137:1995/Amd 1:2001, indexOf(first space), sub(length, indexof)) 

Have a nice weekend