Strip off decimal point and comma in text export 1

[kpeak]

I am using the following formula to strip the decimal point out of a 7 position numeric field when I export to a text file. Is there an easy way to use this formula to also remove the comma thousands separator?

replicatestring(" ", 7 - len(replace(totext({@gross_adj}),".",""))) + replace(totext({@gross_adj}),".","")

(example: @gross_adj = 1,320.79
want to export as 132079)

 

[lbass]

Try:

replicatestring(" ", 7 - len(replace(totext({@gross_adj},2,""),".",""))) +
replace(totext({@gross_adj},2,""),".","")

-LB

 

[kpeak]

Thanks...worked like a charm!