Default format is ignored
Posted: Thu Aug 26, 2010 2:24 am
Hi,
I am trying to convert a decimal to string using the "string_from_decimal" modify function and write that to a file. The only trick is that the separator needs to be a comma (",") and has to be without leading/ trailing zeros.
I see three choices. The last one works but is least desirable by the client.
- use the sequential file "decimal separator" option but I cannot suppress zeroes.
- use a modify, but that ignores the "Format" tab properties and uses a (.) for decimal separator.
- use a transformer.
Any help with the first two? Am I omitting something?
I am trying to convert a decimal to string using the "string_from_decimal" modify function and write that to a file. The only trick is that the separator needs to be a comma (",") and has to be without leading/ trailing zeros.
I see three choices. The last one works but is least desirable by the client.
- use the sequential file "decimal separator" option but I cannot suppress zeroes.
- use a modify, but that ignores the "Format" tab properties and uses a (.) for decimal separator.
- use a transformer.
Any help with the first two? Am I omitting something?