Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to split columns of the following data using SAINT Classification

kaushikhaldar1978
Level 1
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

2 Replies
ishans52004352
Employee
Employee

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

Uditgupta1
Level 2
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