Case 929 How to remove comma from number ?

[paulyeo11]

Hi All

I have below load script :-

Directory;
LOAD
Autonumber(DocNum) as NewDocNum,
DocNum
FROM
QUOT_SD_.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

The Raw data :-

DocNum

1,971,000,182

1,971,000,238

May i know how to make it become :-

DocNum

1971000182

1971000238

Paul Yeo

[tresesco · Accepted solution]

Purgechar(DocNum, ',')