AnsweredAssumed Answered

Mixing Text and numbers

Question asked by tedmather on Jan 28, 2012
Latest reply on Jan 29, 2012 by Sorbsbuster

Title

Mixing Text and numbers

Post

How do you mix numbers and text and sort properly? We designate lighting fixtures with codes that might be any of the following: 1, 2, 2A, 2A-1, TA, TA-19, TA-26, BG, BG1, BG2, etc. 

I cannot figure out a way to sort them the way we want, since a field can only be either a number or text. Is there a way to convert text to a number (ie conver A to 1, B to 2, etc). If so, I could possibly split each code into several fields, and convert each letter to a number "behind the scenes", but I can't find any method of converting text to a number. 

I would think this is a common requirement with serial numbers that mix text and numbers.

Help!

Ted

Outcomes