parse string using other strings

Mikis

Hello,

I have a list of strings with an underscore seperator like the following:

ftThreefinalgrps_brd4_co10
ftif5_co10
ftqn5_bra1

I also have a list of "identifiers", that tell me what each part of the string means.

please note that the number of identifiers and their name is variable

br

ft

co

The goal is to parse the string using the identifiers.

Using my first variable, I want to find everything after "br" and before the underscore (if there is any), in this case "d4".

Then I want everything after "ft" and before the underscore, being "Threefinalgrps"

Finally, I want everything after co and before the underscore, so "10"

My ideal final result would be:

variable	ft	br	co
ftThreefinalgrps_brd4_co10	Threefinalgrps	d4	10
ftif5_co10	if5		10
ftqn5_bra1	qn5	a1

Does anyone have a suggestion on how to start?

Thanks!

Mikis

strings to split.yxmd

jdunkerley79

I would jump to Regex:

REGEX_Replace(
   [variables],
   ".*?(" + [Field1] + "([^_]+))?.*?",
   "$2")

But it is pretty hard so an alternative is:

IIF(Contains([variables], [Field1]),
    Substring([variables], FindString([variables], [Field1])+length([Field1]),1000), 
    NULL())

This will trim the string down and then

IIF(Contains([Match], "_"), Left([Match], findstring([Match],"_")-1), [Match])

To chop off at the first _

Sample of both attached.

strings to split.yxmd