Extract every other character from a string

=========
QUESTION
———
I have a long number that I need to collect the 2nd, 4th, 6th, and 8th characters from.

 

=========
ANSWER
———
see EXAMPLES

 

=========
EXAMPLES
———
Store: Mid([SurvNum_Span],2,1) & Mid([SurvNum_Span],4,1) & Mid([SurvNum_Span],6,1) & Mid([SurvNum_Span],8,1)

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access
VBA
String Manipulation

 

=========
REF
———
http://ycmi.med.yale.edu/nadkarni/access_course/String_Frame.htm

 


http://www.anysitesupport.com/extract-every-other-character-from-a-string/
http://anySiteHosting.com

By | 2012-02-12T15:08:57+00:00 February 12th, 2012|Access, Computers, Documentation, Microsoft, VBA|0 Comments