Sorting alpha numeric data

T

teetee209

I have a very large data base (9,000 +) with a column of numbers such as:
K-8345-08; B-8346-08; O-8347-08. Is it possible to sort this data by number
only and ignore the letter and hyphen? Can this be done with out adding a
secondary column?
 
D

Dave Peterson

I think you'll need the helper column.
I have a very large data base (9,000 +) with a column of numbers such as:
K-8345-08; B-8346-08; O-8347-08. Is it possible to sort this data by number
only and ignore the letter and hyphen? Can this be done with out adding a
secondary column?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alphanumeric Sorting - numeric alpha numeric 2
Need Help with Alpha into Numeric expressions (not ASCII/ANSI/Etc. 9
Sorting rows of data of varying lengths 12
Sorting Alphanumeric data 6
Sorting Alpha numeric data and keeping the number sequence 5
how to extract a specific alpha numeric pattern from a string 4
Sorting data using roman numerals.... 7
Sorting blank and non blank column of data 1

Top