Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
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 3

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

View solution in original post

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 3

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