I am trying to use a regular expression to delete the characters between to two items in a collection variable. In this case - and ;.
Smith, John - OrgName-SubOrg, St. Louis, MO; Cook, David - OrgName-SubOrg, Washington, DC; to be
Smith, John; Cook, David
I used (?<=-).+(?= ; )
Smith, John - ;
Any help would be appreciated.
@mrdavidcook ....can you please share how you're storing the values in the collection? If it's collection then your value should be separated by ";".
@kunalpatel , I got ( - )(.+)(\;) as a regular expression and this deleted everything so we have Smith, Tom. The problem is that we don't get Smith, Tom, Bryson, Bill.
@mrdavidcook ....I'm still trying to figure out how you're getting the values in collection variable !!!
I mean which attribute of the Query user profile you're pulling and I usually get a single value and not the collection if I'm using a Query user profile.