M momoko Registered User. Local time Today, 23:08 Joined Oct 7, 2001 Messages 41 Jan 23, 2003 #1 Hi, I have some data , for example ABCD EFG &OR SDDFAADD &OR AADDD BBBBBB &OR How can I remove the last 3 character. I cannot use Left or Mid as I cannot determine the number of character. Please help.
Hi, I have some data , for example ABCD EFG &OR SDDFAADD &OR AADDD BBBBBB &OR How can I remove the last 3 character. I cannot use Left or Mid as I cannot determine the number of character. Please help.
B bjackson Registered User. Local time Tomorrow, 10:08 Joined Jan 3, 2003 Messages 404 Jan 23, 2003 #2 Dim StrMystring as string dim StrMyLength as long StrMyString= your string abcdefg etc StrMyLength=len(StrMyString) StrMyString=left(StrMyLength,(len(StrMyString)-3)
Dim StrMystring as string dim StrMyLength as long StrMyString= your string abcdefg etc StrMyLength=len(StrMyString) StrMyString=left(StrMyLength,(len(StrMyString)-3)
B bjackson Registered User. Local time Tomorrow, 10:08 Joined Jan 3, 2003 Messages 404 Jan 23, 2003 #3 Sorry I got that wrong It Should beDim StrMystring as string dim StrMyLength as long StrMyString= your string abcdefg etc StrMyLength=len(StrMyString) StrMyString=left(StrMyString,(len(StrMyString)-3)
Sorry I got that wrong It Should beDim StrMystring as string dim StrMyLength as long StrMyString= your string abcdefg etc StrMyLength=len(StrMyString) StrMyString=left(StrMyString,(len(StrMyString)-3)
