M
Hi,
does anybody know, how I use the command 'NUMERIC' in order
to convert a text column to an numeric column? The Problem is, that my decimal seperator is ",".
When I type 'NUMERIC C1 C2' in my session window the output is as I want it but when I use it in a macro the output is as below:
C1-T ---> C2 (after Macro) ---> C2 (session window)
17,81 _________*______________________17,81
18____________18_____________________ 18
So how can I adjust the NUMERIC-Command, that the "," will be taken as the decimal seperator in the macro?
NOTE: It's not possible just to change the regional settings, because other programms can not handle it.
Hope you can help me.
Thanx
does anybody know, how I use the command 'NUMERIC' in order
to convert a text column to an numeric column? The Problem is, that my decimal seperator is ",".
When I type 'NUMERIC C1 C2' in my session window the output is as I want it but when I use it in a macro the output is as below:
C1-T ---> C2 (after Macro) ---> C2 (session window)
17,81 _________*______________________17,81
18____________18_____________________ 18
So how can I adjust the NUMERIC-Command, that the "," will be taken as the decimal seperator in the macro?
NOTE: It's not possible just to change the regional settings, because other programms can not handle it.
Hope you can help me.
Thanx