• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

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.
0
JOHNHO
Asked:
JOHNHO
  • 2
1 Solution
 
mcriderCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now