Subject Re: String question From Charlie <tm@tc.com> Date Mon, 13 Nov 2023 15:52:01 -0500 Newsgroups dbase.getting-started Hi Ken...  Thanks so much.  Something else was going on and this helped me find it. Ken Mayer Wrote: > On 11/13/2023 9:57 AM, charlie wrote: > > Hi Heinz.. > > > > I can't figure this one either. > > > > I want the result to be in character string but the val puts it in numeric. > > Read the description in help for the definition of the function. Val() > converts the numeric value in a string to a number. Val() is short for > "value". > > > > > Example > > c = "10000" > > ? transform(val(c), "@R 999,999") > > This does come up with 10,000 but in numeric. > > I tried this str(c) afterward but that doesn't work. > > > > Unless I am missing something. > > The code above is not converting the value back to a string. It's just > outputting it. > > c2 = transform(val(c), "@R 999,999") > > Assigns the value to a new variable (so you aren't overwriting 'c'). If > you do this: > > ? c2 > > You should see that there is only a single leading space, if this were a > numeric value there would be more: > > ? 10000 > > This is a numeric value, you can tell among other things because of the > leading spaces in the output pane. > > Hope that helps a bit. > > Ken > > -- > *Ken Mayer* > Ken's dBASE Page: http://www.goldenstag.net/dbase > The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp > dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm > dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm > dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm > dBASE DOS to Windows Tutorial: > http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm >