Solved! Custom Sort in a Table

[gksharmaajmer]

I have to arrange / sort the table on Name Column, but some names have prefix Dr. Prof. Er. etc. When I sorts the table, it sorts all Dr. Prof. and Er. without ignoring the Name i.e. if Name is Dr. Jacob, so it should be in J alpha order, not in D. I am using MS Word 2007 please.

 

[USAFRet]

I have to arrange / sort the table on Name Column, but some names have prefix Dr. Prof. Er. etc. When I sorts the table, it sorts all Dr. Prof. and Er. without ignoring the Name i.e. if Name is Dr. Jacob, so it should be in J alpha order, not in D. I am using MS Word 2007 please.

That needs to be 2 columns.
Dr., Prof., etc in one col, the name in a second col.

 

[gksharmaajmer]

Thanks for your reply, but I have to keep in one column because my need is something like to have them in a column. Is it possible by macro using regular expression, but I am not able to write macro. Kindly help me.

 

[gdmaclew]

What you could do is what is done in the following Excel tip...

https/www.youtube.com/watch?v=CQNi0MDLz0I

Then you could either delete the two columns you built the new column from or keep them.

 

[USAFRet]

Thanks for your reply, but I have to keep in one column because my need is something like to have them in a column. Is it possible by macro using regular expression, but I am not able to write macro. Kindly help me.

Well, yes...you could do it the hard way with some regex.
Or, you can restructure your data, and do it the easy way.

In Excel:

Col 1 is the Prefix
Col 2 is the Name
Col 4 is concatenation of the prefix and name

 

[gksharmaajmer]

Thanks for your answers. Since, I can't have separate column, so I ported data in Foxpro and then I said :

INDEX ON ALLTRIM(SUBSTR(NAME,AT(".",NAME)+1,30)) TO XX
(Here Name is the name of column in table) and XX is the name of index file which foxpro creates.(XX.IDX)