Custom Sort in a Table

Status
Not open for further replies.
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.
 

USAFRet

Titan
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

Titan
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
 
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)
 
Status
Not open for further replies.