Matthew:
At the R> prompt, type SHOW and see what your "currency" settings are (4
lines). Assuming you're using US currency, you would this by:
SET CURRENCY '$' PREF 2 B
So to drop the $ symbols temporarily, do the following before you create your
file:
SET CURRENCY ' ' PREF 2 B
Then you can set it back.
Karen
> So I recently discovered the FLOAT function trying to figure out how to get
> rid of dollar symbols and commas in my CSV exports. I’m curious if there’s
> a simpler, more efficient way of doing this. Presently I have to create a
> view, and then use the expression (FLOAT(table.column)) for every single
> field
> that is a CURRENCY data type. Without doing that, the exported CSV text file
> displays the dollar symbols in addition to placing the value within quotes…
> as though it were a string. If there were some way I could just say… export
> this and convert all currency data types into real or double data types…
> that
> would be pretty sweet.
>
>
>
