Hi


I have a string like -211,12 i want to convert this to -211.12 (convert comma to decimalpoint).
I have used the following command but get a error.

-SET &NUMBER = STRREP(07,'-211,12',1,',',1,'.',07,'A07');

(FOC36355) INVALID TYPE OF ARGUMENT #6 FOR USER FUNCTION STRREP

How can i convert this?

This message has been edited. Last edited by: Kerry,

Hi,

You can try this document.

http://techsupport.information...om/sps/60112505.html

It mentions about function not liking the period.

Hope this helps.

Best Regards,

Jimmy Pang

Here's the CTRAN function:

-SET &T1_STR = '-211,12';
-SET &NUMBER = CTRAN(07, &T1_STR, 44, 46, 'A07');
-*
-TYPE T1_STR ------- &T1_STR
-TYPE NUMBER ------- &NUMBER

So the string is really a nunmber that you want to evaluate, you're not really wanting a string. JFR99's code should get you what you need, but you might try doing a search on CDN (continental decimal notation) and see if that might help resolve your situation.

Tanks all for your help

I got another solution that seems to work:

-SET &NUMBER = STRREP(07,'-211,12',1,',',1,HEXBYT(46, 'A1'),07,'A07');

replace '.' by HEXBYT(46, 'A1')