Subfield Question ?

[suzel404]

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.

[suzel404]

Thank you Anand.

[MarcoWedel]

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