Expand my Community achievements bar.

Adobe Analytics Champions applications are now OPEN! Applications are open through June 2nd. Click the link to learn more and apply.
SOLVED

How to split columns of the following data using SAINT Classification

Avatar

Level 1

The Issue

How can I classify all the different strings using SAINT Classification

1403:1280:110:26:150

1782:1780:101:26:50

188:1780:11:11

266:1780:15:12:

1758:1280:138:22:500

 

 

Expected output

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

1 Accepted Solution

Avatar

Correct answer by
Level 2

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-rulebui...

 

Thanks

2 Replies

Avatar

Employee Advisor

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-rulebui...

Avatar

Correct answer by
Level 2

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-rulebui...

 

Thanks

page footer