Extract a string

[rittermd]

I have a field in an excel file that contains something like this:

{{Locus OPS,KChaney,};{LOIS OPS,KChaney,};{Smart Border,KChaney,};{Smart Border OPS,KChaney,};{Evolve,KCHANEY,};{Evolve OPS,KChaney,};{Cisco_Phone,45103,};{USB - Email,Chaney Kevin,};{Evolve WIT,KChaney,};{iPro,KChaney,};{iPro OPS,KChaney,};{Locus,KChaney,};{LOCUSPS,KChaney,};{ClientServices_Salesforce,KChaney,};{EvolvePS,KCHANEY,};{SmartBorderPS,KChaney,}}

I need to locate the value of EvolvePS in the above data and then save the user name KCHANEY into a new field.

Not sure what the best approach is to accomplish this?

[Nicole-Smith · Accepted solution]

This should work:

SubField(SubField([FieldName], 'EvolvePS,', 2), ',', 1)

[Frank_Hartmann]

Maybe like this:

TextBetween(YourExcelField,'EvolvePS,',',};') as newField

[rittermd · Accepted solution]

I had figured out a solution but I did it in like 3 steps.  Your solution is perfect and efficient.  Thank you