Page 1 of 1
replace
Posted: Wed Jul 26, 2006 10:05 am
by fmartinsferreira
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
Posted: Wed Jul 26, 2006 10:11 am
by chulett
Check the EReplace or Convert functions in your 'online' help.
Posted: Wed Jul 26, 2006 10:16 am
by fmartinsferreira
I solved using change function
Thanks
Posted: Wed Jul 26, 2006 10:25 am
by chulett
Or 'change'... more than one way to skin the cat.
Posted: Wed Jul 26, 2006 4:55 pm
by ray.wurlod
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?