Text Split

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

Hi @Guduru_Ruteesh_Raju

Please try,

Yourvariablename.split("."c)

Thanks

Hi,

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

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

Regards,