Extract substring from pos1 up to first occurence of a certain character

[shalmaxb]

Hello,
is it possible to use the function string\substring to extract charaters from a start point up to the frst occurrence of a certain character (an underscore in my case)? I have this situation:

I have a field old containing strings like this: aaaa_bbbbbbb...._ccc_ddd. I would like to extract the part bbbbb, which has varying length. My formula would look like this:

new = string\substring(old, 6, <and here the first underscore as stop point>);

In PHP there is explode to realize something like that. Is there a formula, which could achieve this?

[yuri]

Hi. The string\split function can be used https://docs.espocrm.com/administrat...g/#stringsplit.

Or string\pos https://docs.espocrm.com/administrat...ing/#stringpos in combination with string\substring.