Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
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