How to split String with Classification Rules (Regex)

Question

Hello guys,Anyone can help to split 1 string as b1cdc3168772ce4a79ba2db0cfeba174#recdc3168772ce4a79ba2db0cfeba123#.... into a multiple sub customerId? Thanks

jgrubbs · Accepted Answer

Assuming the "#" character is your delimiter, an example regex for THREE id values would be

([^#]+)#?([^#]+)?#?([^#]+)?

And if you have 3 classifications, called something like "FirstID", "SecondID", and "ThirdID", you'd set the values for them in the rule builder as $1, $2, and $3 respectively

jeff_bloomer · Answer

@luca_lattarini Classification Rules using Regex typically work by identifying certain patterns. What specific pattern(s) are you wanting to recognize in order to then "normalize" split things out and/or return different data in your Report Suite?
For instance, you can actually have your Regex split on the hashtags or a specific sets of numbers. It all depends on your criteria.

Sign up

Login with SSO

Login to the community

Login with SSO