+23I’m trying to create a new value based on the first letter of each word in a string. I tested the regex ‘\b(\w)’ and the returned value is correct, but when I used that regex in the @SubstringRegularExpression(), it only returned the first letter of the first word.
@SubstringRegularExpression(@Value(ID),\b(\w)) where ID is “MARKHAM RD/ORANGE BLVD, SANDFORD”. You can see in the regex editor, it is correct.
This is the result of the substring
+60SubstringRegularExpression doesn't work with capture groups, which your regular expression does.
Use a StringSearcher, enter the name of a new list under Advanced, after All Matches List Name.
This will create a list of all values that meet your regular expression.
Next use a ListConcatenator to join all values of the list in a single variable.
+52SubstringRegularExpression doesn't work with capture groups, which your regular expression does.
Use a StringSearcher, enter the name of a new list under Advanced, after All Matches List Name.
This will create a list of all values that meet your regular expression.
Next use a ListConcatenator to join all values of the list in a single variable.
great solution!
