My emailer converted the quotes wrong Here are the commands corrected in plain text:
set var v2 TEXT =(Trim(FORMAT(.v1,'999,999,990'))) this will give you a text value of 2,137,903 to change the commas to periods: set var v2 = (SRPL(.v2,',','.',0)) now v2 contains 2.137.903 Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Monday, June 24, 2013 12:51 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: AW: [RBASE-L] - AW: [RBASE-L] - Re: FORMAT Also you must use the right quote character. RBase uses the single quote, unless you have changed your system to use the double quote. I am assuming a single quote character is correct. try this set var v2 TEXT =(Trim(FORMAT(.v1,'999,999,990'))) this will give you a text value of 2,137,903 to change the commas to periods: set var v2 = (SRPL(.v2,’,’,’.’,0)) now v2 contains 2.137.903 Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Dr. Fritz Luettgens Sent: Monday, June 24, 2013 12:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - AW: [RBASE-L] - AW: [RBASE-L] - Re: FORMAT Result should be: r> v2 = 2.137.903 INTEGER Von: [email protected] [mailto:[email protected]] Im Auftrag von Dr. Fritz Luettgens Gesendet: Montag, 24. Juni 2013 19:35 An: RBASE-L Mailing List Betreff: [RBASE-L] - AW: [RBASE-L] - Re: FORMAT results: v1 = 2137903 INTEGER v2 = 0 INTEGER Von: [email protected] [mailto:[email protected]] Im Auftrag von Karen Tellef Gesendet: Montag, 24. Juni 2013 19:31 An: RBASE-L Mailing List Betreff: [RBASE-L] - Re: FORMAT I think you have to convert the format to an integer specifically. Try: set var v2 INTEGER = (INT(FORMAT(.v1,"#0.0;_#0.0"))) -----Original Message----- From: Dr. Fritz Luettgens <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, Jun 24, 2013 12:24 pm Subject: [RBASE-L] - FORMAT R:BASE eXtreme 9.5 (64), Build: 9.5.3.20611, Win7 Ultimate R> SET VAR v1 INTEGER = 2137903 R> set var v2 INTEGER = (FORMAT(.v1,"#0.0;_#0.0")) -ERROR- Your value does not have the same type or scale as your variable v2 (2178) Can´t find my mistake anymore, serious beginner blues, thank´s Fritz Conf Settings: Quotes “ Delimit , Tolerance 0, (Europe)
