Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can I transform the number 1100000 to 1 100,000 ?
left(Field,len(Field)-3)&','&right(Field,3))) give me 1100,000
Thank for your help.
Thank you Anand.
just one more:
LOAD NumIn, Replace(Left(NumTemp, PosLastSep-1), ',', ' ')&Right(NumTemp, Len(NumTemp)-PosLastSep+1) as NumOut;
LOAD *, Index(NumTemp, ',', -1) as PosLastSep;
LOAD *, Num(NumIn, '#,##0', '.', ',') as NumTemp
Inline [
NumIn
1
2
10
20
100
200
1000
2000
10000
20000
100000
200000
1100000
2000000
10000000
20000000
100000000
200000000
1000000000
2000000000
10000000000
20000000000
100000000000
200000000000
1000000000000
2000000000000
];
regards
Marco