Solved! Custom Sort in a Table

May 1, 2018
3
0
10
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.
 
Solution


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:
rw9LGrM.png


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

USAFRet

Illustrious
Moderator


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

 
May 1, 2018
3
0
10
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.
 

USAFRet

Illustrious
Moderator


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:
rw9LGrM.png


Col 1 is the Prefix
Col 2 is the Name
Col 4 is concatenation of the prefix and name
 
Solution
May 1, 2018
3
0
10
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)