Normal Topic Selecting a letter within a sequence (Read 672 times)
Don Haley
Member
*
Offline


No personal text

Posts: 38
Location: Plymouth, Devon, UK
Joined: Jan 23rd, 2004
Selecting a letter within a sequence
Jul 22nd, 2010 at 5:02pm
Print Post Print Post  
If I have an element named "Sequence" which contains a series of letters i.e. AABAAC and an element "Next_Service" which will contain a number i.e. 3, is it possible to program a third element to show the third letter in the first element i.e. "B" ?

Thanks for any ideas Smiley

Don
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Selecting a letter within a sequence
Reply #1 - Jul 22nd, 2010 at 5:53pm
Print Post Print Post  
ThirdElement = @Mid(Sequence, Next_Service, 1)

  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Don Haley
Member
*
Offline


No personal text

Posts: 38
Location: Plymouth, Devon, UK
Joined: Jan 23rd, 2004
Re: Selecting a letter within a sequence
Reply #2 - Jul 22nd, 2010 at 6:06pm
Print Post Print Post  
Many thanks, works like a dream Smiley  The @Mid is new to me, I missed it when I read through the programming guide.

Don
  
Back to top
 
IP Logged