Need help with extraction of a alphabet from an alphanumeric value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a column which has values like 00-H15-81366, 03-A02-81570 etc. I need
to make another column which will show the aphabet only e.g. H, A etc. I
would like to know if there is any function that would allow me to do so.
Thanks in advance.
 
If it is always in the fourth position just use...


AlphaField: Mid([SomeFieldName],4,1)
 
Thanks for the help Rick. Regards.

Rick B said:
If it is always in the fourth position just use...


AlphaField: Mid([SomeFieldName],4,1)



Jack said:
Hi,
I have a column which has values like 00-H15-81366, 03-A02-81570 etc. I need
to make another column which will show the aphabet only e.g. H, A etc. I
would like to know if there is any function that would allow me to do so.
Thanks in advance.
Click to expand...
Click to expand...
 
Back
Top