why this is happenning ?

like this im using the below statement.

Text1 = Trim(Mid(STRDATA, 1, 1))
Text2 = Trim(Mid(STRDATA, 2, 5))
Text3 = Trim(Mid(STRDATA, 8, 8))

the problem is on the third line, the data that should be shown on text  box is only 1 digit but why it show ten digits even i ask it to appear 1 digits only
ie 8 to 8 leght, even if i put  Text3 = Trim(Mid(STRDATA, 8 , 20)) it  
will show the same thing which is not correct data. how to ask it to appear the space or data that as our request.

pls help me.


thanks.
JOHNHOAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mcriderConnect With a Mentor Commented:
Let's assume that STRDATA looks like this:

   STRDATA = "1234567890abcdefghij"

Then:

   Text1 = Trim(Mid(STRDATA, 1, 1)) 'WILL RETURN "1"
   Text2 = Trim(Mid(STRDATA, 2, 5)) 'WILL RETURN "23456"
   Text3 = Trim(Mid(STRDATA, 8, 8)) 'WILL RETURN "890abcde"

If you want Text3 to contain 1 character starting at position 8, you need to do this instead:

   Text3 = Trim(Mid(STRDATA, 8, 1)) 'WILL RETURN "8"


Hope this helps!


Cheers!

0
 
caraf_gCommented:
Yes, mcrider is right:

The first numeric parameter of the Mid command is the starting position. Your mistake is that you thought the second numeric parameter is the ending position. It's not - it's the number of characters you wish to return starting from the position specified in parameter 2.
0
 
JOHNHOAuthor Commented:
Thanks a lot .

0
 
mcriderCommented:
Thanks for the points! Glad I could help!


Cheers!®©
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.