How to split columns of the following data using SAINT Classification

Question

The IssueHow can I classify all the different strings using SAINT Classification1403:1280:110:26:1501782:1780:101:26:50188:1780:11:11266:1780:15:12:1758:1280:138:22:500  Expected outputStringVar1Var2Var3Var4Var51403:1280:110:26:15014031280110261501782:1780:101:26:50178217801012650188:1780:11:1118817801111 266:1780:15:12:26617801512 1758:1280:138:22:5001758128013822500

Uditgupta1 · Accepted Answer

Hi @kaushikhaldar1978 ,

You can use below Regular Expression for your classification.

^(.+)\:(.+)\:(.+)$

Attaching a document for your reference where you can find other type of regular expression for future need.

https://experienceleague.adobe.com/docs/analytics/components/classifications/classifications-rulebuilder/classification-quickstart-rules.html?lang=en#section_5D300C03FA484BADACBFCA983E738ACF

Thanks

isinha · Answer

You can use Regular Expressions in the Classification Rule Builder and classify your strings as per your requirement.

https://experienceleague.adobe.com/docs/analytics/components/classifications/classifications-rulebuilder/classification-quickstart-rules.html?lang=en#classifications

String	Var1	Var2	Var3	Var4	Var5
1403:1280:110:26:150	1403	1280	110	26	150
1782:1780:101:26:50	1782	1780	101	26	50
188:1780:11:11	188	1780	11	11
266:1780:15:12:	266	1780	15	12
1758:1280:138:22:500	1758	1280	138	22	500

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded