How to split columns of the following data using SAINT Classification

Avatar

Avatar

kaushikhaldar1978

Avatar

kaushikhaldar1978

kaushikhaldar1978

10-03-2021

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

View Entire Topic

Avatar

Avatar

ishans52004352

Employee

Avatar

ishans52004352

Employee

ishans52004352
Employee

10-03-2021

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