Case 929 How to remove comma from number ?

paulyeo11 — Wed, 16 Sep 2020 05:35:46 GMT

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

Re: Case 929 How to remove comma from number ?

tresB — Wed, 16 Sep 2020 05:49:13 GMT

Purgechar(DocNum, ',')