replace

fmartinsferreira · Post by **fmartinsferreira** » Wed Jul 26, 2006 10:05 am

Hi everybody!

My input is "0.678" and I need the following output "0,678".

Does anybody know how can I do this in the transformer?

Regards,

Fernando

chulett · Post by **chulett** » Wed Jul 26, 2006 10:11 am

Check the EReplace or Convert functions in your 'online' help.

fmartinsferreira · Post by **fmartinsferreira** » Wed Jul 26, 2006 10:16 am

I solved using change function

Thanks

chulett · Post by **chulett** » Wed Jul 26, 2006 10:25 am

Or 'change'... more than one way to skin the cat.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 26, 2006 4:55 pm

Convert() is more efficient than either Ereplace() or Change().

If you had NLS enabled, then the regional settings (locale) would have automatically managed the decimal place character.

You could also have used Fmt() with a literal replacement for the decimal place character.

Do you also need a non-US thousands delimiter character?