Cut String where the first delimiter is either . or :

[whereismytowel]

Hi,

i have a bunch of Strings stored in a Field which i need to cut with the textbetween function.

So the strings could be something like:

123.ABC

or 123:ABC

The Strings have different lengths so i cant use the left or right function.

So i just need to cut the String after the first occurence of either . or :

Unfortunately something like this doesn't work
TextBetween('InputText, '.' or ':', '', 1)

Does anybody have an idea how to cut the string after the first occurence of either . or : ?

I need a pretty performant solution since i handle an extremely huge data set

[vinieme12]

use Subfield() as below

Subfield(Subfield(FieldName,'.',1),':',1)  as newField

[marcus_sommer · Accepted solution]

I would try to unify the different delimiters and then applying the cutting-logic, maybe like:

subfield(replace(Field, '.', ':'), ':', 1)