Text Split

Help Activities
, ,
1

France·Champagne Premier Cru·Pierre Gimonnet & Fils·Sparkling wine·Chardonnay
how can i split text data with . as delimiter
as 1.France, 2.Champagne Premier Cru, 3.Pierre Gimonnet & Fils, 4.Sparkling Wine, 5.Chardonnay

2

Hi @Guduru_Ruteesh_Raju

Please try,

Yourvariablename.split("."c)

Thanks

3

Hi,

Do you want to split by middle dot(“·”) or period(“.”)?
Anyway, the following will work for both.

arrStr = yourString.Split({"."c,"·"c})

Regards,