Sorry! Works in v8 not in 7.5.
Thanks again! -Bob ----- Original Message ----- From: "ttc inc" <[email protected]> To: [email protected] Sent: Thursday, April 14, 2011 12:55:42 PM Subject: Re: [RBASE-L] - Re: VarChar conversion ----- Original Message ----- From: "ttc inc" <[email protected]> To: [email protected] Sent: Thursday, April 14, 2011 12:55:42 PM Subject: Re: [RBASE-L] - Re: VarChar conversion Thanks Mike, However I get : -ERROR- SLEN does not allow VARCHAR arguments. (2156) -ERROR- Expression cannot be evaluated. (2179) -Bob ----- Original Message ----- From: "Mike Byerley" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, April 14, 2011 12:18:19 PM Subject: [RBASE-L] - Re: VarChar conversion Here's how. set var x varchar = ['Test.dat'] set var vtext text = (sget(.x(Slen(.x)),1)) set var vFloat = (float(.vtext)) sho var vFloat ----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, April 14, 2011 9:44 AM Subject: [RBASE-L] - VarChar conversion I load a value into a variable from a text file set var x varchar = null set var x = ['Test.dat'] sho var x 17.62 I now need to work with this value. However, I cannot find any conversion functions that seem to work with varchar datatype. FLOAT states that it does not work with varchar CTXT gives the following set var Y text = null set var Y = (CTXT(.x)) sho var Y * How can I convert the varchar variable type to something I can work with? Thanks, -Bob ----- Original Message ----- From: "Mike Byerley" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, April 14, 2011 12:18:19 PM Subject: [RBASE-L] - Re: VarChar conversion Here's how. set var x varchar = ['Test.dat'] set var vtext text = (sget(.x(Slen(.x)),1)) set var vFloat = (float(.vtext)) sho var vFloat ----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, April 14, 2011 9:44 AM Subject: [RBASE-L] - VarChar conversion I load a value into a variable from a text file set var x varchar = null set var x = ['Test.dat'] sho var x 17.62 I now need to work with this value. However, I cannot find any conversion functions that seem to work with varchar datatype. FLOAT states that it does not work with varchar CTXT gives the following set var Y text = null set var Y = (CTXT(.x)) sho var Y * How can I convert the varchar variable type to something I can work with? Thanks, -Bob
