+2Hi
I am trying to use a regular expression to delete the characters between to two items in a collection variable. In this case - and ;.
For example,
Smith, John - OrgName-SubOrg, St. Louis, MO; Cook, David - OrgName-SubOrg, Washington, DC; to be
Smith, John; Cook, David
I used (?<=-).+(?= ; )
got this:
Smith, John - ;
Any help would be appreciated.
+12@mrdavidcook .....what's the source of your collection value? I mean how you're getting the values in your collection?
+12@mrdavidcook .....If you just need the name then you can use Name, FirstName, LastName attribute. Which attribute you're pulling here?
+2+12@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 ";".
+2@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.
+23+12@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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
