how to sort a string it contains numeric and characters?

Question

0.00/5 (No votes)

See more:

hi experts...

my database column is combination of alphabets and numbers. how can i sort numbers,after ending last alphabet. i using ms access2007 as db.

thanks in advance

Posted 18-Jun-12 19:56pm

sandeep nagabhairava

Add a Solution

Comments

Sunny_Kumar_ 19-Jun-12 2:03am

share the data sample.

Sunny_Kumar_ 19-Jun-12 2:18am

I mean to ask you for the data sample and what way you want it sorted. is it like:
ap16as4779
ka07dh8342
ta5hk1234
ap16as4778
ta5hk1233

and you want this to be sorted as:
ap16as4778
ap16as4779
ka07dh8342
ta5hk1233
ta5hk1234

please elaborate, so that I can get a better picture to make you understand.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-06-18T20:18:00

Solution 1

Doing that in Access or SQL is pretty much impossible - it doesn't have a custom sort, just ascending or descending by character, according to the collation setting.

To do it in C# is pretty simple, but the exact mechanism is up to you as I don't know exactly how you are storing the data.

Personanally, I would implement a new IndianVehicleNumber class which implements IComparable, and do my own comparer.

Posted 18-Jun-12 20:18pm

OriginalGriff

Comments

OriginalGriff 19-Jun-12 3:02am

That is so easy! :laugh:
No, seriously, it is...
All you have to do is handle the DataGridView SortCompare event, and set the e.SortResult

Assuming the VN is in column 0:
private Regex lastnumbers = new Regex(@"\d+\b", RegexOptions.Multiline | RegexOptions.CultureInvariant | RegexOptions.Compiled);
private void myDataGridView_SortCompare(object sender, DataGridViewSortCompareEventArgs e)
{
string sThis = myDataGridView.Rows[e.RowIndex1].Cells[0].Value as string;
string sThat = myDataGridView.Rows[e.RowIndex2].Cells[0].Value as string;
if (sThis != null && sThat != null)
{
Match mThis = lastnumbers.Match(sThis);
Match mThat = lastnumbers.Match(sthat);
e.SortResult = mThis.Value.CompareTo(mThat.Value);
return;
}
throw new NotImplementedException();
}

exposed12 · Answer 2 · 2012-06-18T20:34:00

Solution 2

Even in Access you can, instead of using the drag and drop, input your own SQL Query.

The right query for this should already be posted in Code Project, pls refer to:

How to Sort Alphanumeric Data in SQL[^]

Posted 18-Jun-12 20:34pm

exposed12