CELL SPLITER

[Brain]

Hello,

I use cell splitter to split a date ; example :
18 mai 1898 = 18 / mai/ 1898
But the result for the year is 1,898. I dont want a comma in the year

Thanks for your help

[sforesti]

Hi Brian,

I assume the new year column is a string/text column. If so, you can remove the comma from the year column using a String Manipulation node with a formula like: replace($Year$,“,”,“”). If you want to remove the comma and convert the year column from a string/text to a number, you can use a String to Number node and specify a comma as the thousands separator.