Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

Extract a string

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?

 

 

2 Solutions

Accepted Solutions
Nicole-Smith

This should work:

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

View solution in original post

rittermd
Master
Master
Author

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

View solution in original post

3 Replies
Nicole-Smith

This should work:

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

Frank_Hartmann
Master II
Master II

Maybe like this:

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

rittermd
Master
Master
Author

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