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
BedrockMission!

Learn More

View all

Sign in to view all badges

How to split columns of the following data using SAINT Classification

Avatar

Avatar
Level 1
kaushikhaldar1978
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
kaushikhaldar1978
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
kaushikhaldar1978
Level 1

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar
Boost 3
Level 2
Uditgupta1
Level 2

Likes

3 likes

Total Posts

13 posts

Correct Reply

3 solutions
Top badges earned
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Boost 3
Level 2
Uditgupta1
Level 2

Likes

3 likes

Total Posts

13 posts

Correct Reply

3 solutions
Top badges earned
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
Uditgupta1
Level 2

10-03-2021

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

Avatar

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

151 likes

Total Posts

308 posts

Correct Reply

101 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Affirm 100
Employee
ishans52004352
Employee

Likes

151 likes

Total Posts

308 posts

Correct Reply

101 solutions
Top badges earned
Affirm 100
Give Back 10
Give Back 5
Give Back 3
Give Back
View profile
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...