Number conversion, decimal comma to decimal point

[MetDick]

Hello everybody

I need some help with a calculation field.

I have a currency field that holds a calculated value.

The decimal separator is European: a comma.

Because it is a calculated value the number of decimals are not always 2:

It could be 1000,5 or 1000,52 or even 1000,5232198

My problem:

i need to export the field to a MySQL table

the format should then be: 1,000.00 (US currency, with two decimals)

Can anyone help me with a calculation that:

- sets the number of decimals to 2

- converts the comma to a point

Great!

Dick

[Vaughan]

There is an option in the export dialog to use the formatting on the layout. Format the field on the layout to display 2 decimals.

[MetDick]

@Vaughan

This is not really what I need Vaughan. I am aware of this option

I am using ODBC to get the field to MySQL

What I need is: a text field that holds the number... but with a "point" as a decimal separator

[Aussie John]

use the substitute function

[Vaughan]

My problem:

i need to export the field to a MySQL table

the format should then be: 1,000.00 (US currency, with two decimals)

Can anyone help me with a calculation that:

- sets the number of decimals to 2

- converts the comma to a point

There is an option in the export dialog to use the formatting on the layout. Format the field on the layout to display 2 decimals.

@Vaughan

This is not really what I need Vaughan. I am aware of this option

I am using ODBC to get the field to MySQL

What I need is: a text field that holds the number... but with a "point" as a decimal separator

So where in your original post did you mention ODBC?