foxpro_ spaces in the begining of the chars

[gdefne]

hello,
I am trying to delete the spaces that are in the begining of the field value. I tried command like LTRIM but no luck. Can anybody explain to me what I might be doing wrong?
The data value in the field looks like " def ".
thx
def

 

[jimstarr]

LTRIM() should work:

REPLACE myfield WITH LTRIM(myfield)


Jim

 

[TamarGranor]

If LTRIM() isn't doing it, then whatever's at the front of the string isn't spaces, but some other character. To find out what, try:

?ASC(Left(MyField,1))

Tamar

 

[EzLogic]

strtran(field,'_',"")

Ali Koumaiha
Wireless Toyz
Farmington Hills, Michigan

 

[skoko]

try:

?ALLTRIM("    def ")

 

[mspratt]

Hi Def,

You could cut and paste the actual string into a post so we can look at it.

Regards,

Mike