Removing last character in a character field

[drpep]

I imported character data into a character field and received an unfamiliar character at the beginning and end of the data. The data is variable in length. I was able to remove the unfamiliar character at the beginning with SUBSTR. Any method to remove the ending character. Thanks in advance

 

[DSummZZZ]

Try using:
LEFT(cSomething, LEN(ALLTRIM(cSomething)) -1)


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[JimWWinter]

One way:
cData = LEFT(cData,LEN(TRIM(cData))-1)

Or, if its the same character at both ends:
cChr = LEFT(cData,1)
cData = STRTRAN(cData,cChr,'',1,OCCURS(cChr,cData))

Regards,
Jim

 

[Mike Lewis]

Yet another way (this is going to run and run):

If you happen to know what the spurious character is (I'll assume it's a binary zero, which is likely to be the case):

cData = ALLTRIM(cData, 1, CHR(0))

(But only works in 9.0)

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[drpep]

Thank you for your quick responses. All the solutions worked perfectly. I deeply appreciate your assistance.