Data Format Number - replace withespace

Hello

I have a Number from a Total Count in a Form. The count is doing jautocalc.
Unfortunately the Script separates the tousends with a whitespace for ex. 6 700.

I tryed the Data Formater on server-side within the insert step.
{{$_POST.Total.replace("’ ‘", "’’")}} i tryed also {{$_POST.Total.replace(’ ', ‘’)}}
But no success.

In the DB it shows only the 6 instead of 6700.
The DB table row is set to INT.
If i set it to varchar, then ist shows in the DB 6 700 but i need it as 6700 (without whitespace)

Is there a wappler way to replace or delete all whitespaces in a Number?

Thank you very much for your help
John

Community Page
Last updated: