A
ANStech
I have a string of data. I need to "read" certain characters, for instance
the fifth,six, and seventh character. How can I do this?
the fifth,six, and seventh character. How can I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Use the MID function.
=Mid([SomeFieldName],5,3)
=Mid([SomeFieldName],5,3)
R
Rick Brandt
ANStech said:I have a string of data. I need to "read" certain characters, for
instance the fifth,six, and seventh character. How can I do this?
Check Help file fo rthe Mid() function.
Mid(3, 1, "Test") will return "s"
D
Douglas J Steele
Rick Brandt said:Check Help file fo rthe Mid() function.
Mid(3, 1, "Test") will return "s"
Um, no it won't, Rick.
Mid("Test", 3, 1) will, though...
R
Rick Brandt
Douglas said:Um, no it won't, Rick.
Mid("Test", 3, 1) will, though...
DOH!
I think I was still in InStr() mode where the start position comes first
when I wrote that.