How to split columns of the following data using SAIN...

[#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]

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