Custom Sort in a Table

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

Splendid
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
0
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

Splendid
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:


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
0
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)
 
Thread starter Similar threads Forum Replies Date
The_tom_cat Apps General Discussion 3
B Apps General Discussion 1
iPen Apps General Discussion 2
C Apps General Discussion 1
T Apps General Discussion 3
R Apps General Discussion 3
F Apps General Discussion 1
M Apps General Discussion 1
S Apps General Discussion 8
K Apps General Discussion 1
P Apps General Discussion 15
R Apps General Discussion 3
J Apps General Discussion 1
wanamingo Apps General Discussion 3
liberty610 Apps General Discussion 4
BlueFireZ Apps General Discussion 0
D Apps General Discussion 2
S Apps General Discussion 3
B Apps General Discussion 1
johnpaul1415 Apps General Discussion 2

ASK THE COMMUNITY

TRENDING THREADS