I am trying to sort a list of FQDN [ Wikipedia FQDN ]
Example:
www.ultraedit.com.
idm.com.
www.idm.ultraedit.com.
www.idm.com.
would be sorted to
idm.com.
www.idm.com.
www.ultraedit.com.
www.idm.ultraedit.com.
IDM Computer Solutions, Inc. Forums
UltraEdit, UEStudio, UltraCompare, and UltraSentry
Welcome to the IDM Forum. This forum is meant as a user-to-user support mechanism where users can share knowledge and tips for all IDM software.
Since these forums are user-to-user based, IDM does not regularly read or reply to the posts in this forum. For problem reports, suggestions, or feature requests, you must email us directly. Our trained technical support staff answers most inquiries within 30 minutes.
Sorting FQDN.
2 posts
• Page 1 of 1
Sorting FQDN.
by gjandrews42 » Wed Sep 20, 2006 8:29 pm
-
gjandrews42 - Newbie
- Posts: 1
- Joined: Tue Sep 19, 2006 11:00 pm
Re: Sorting FQDN.
by Mofi » Thu Sep 21, 2006 10:53 am
The following macro sorts your example (copied into an ASCII file) as you want it. Hopefully it works for your whole list. The macro property Continue if a Find with Replace not found must be checked for this macro.
InsertMode
ColumnModeOff
HexOff
UnixReOff
Bottom
IfColNum 1
Else
"
"
EndIf
Top
Find RegExp "%^([~.^r^n]+.[~.^r^n]+.^)^([~.^r^n]+.^)^(?*^)$"
Replace All "^2^3»^1"
Find RegExp "%^([~.^r^n]+.^)^([~.^r^n]+.^)^([~»^r^n]+^)$"
Replace All "^2^3»^1"
SortAsc IgnoreCase 1 -1 0 0 0 0 0 0
Find RegExp "%^([~»^r^n]+^)»^(*^)$"
Replace All "^2^1"
Add UnixReOn or PerlReOn (v12+ of UE) at the end of the macro if you do not use UltraEdit style regular expressions by default - see search configuration. Macro command UnixReOff sets the regular expression option to UltraEdit style.
InsertMode
ColumnModeOff
HexOff
UnixReOff
Bottom
IfColNum 1
Else
"
"
EndIf
Top
Find RegExp "%^([~.^r^n]+.[~.^r^n]+.^)^([~.^r^n]+.^)^(?*^)$"
Replace All "^2^3»^1"
Find RegExp "%^([~.^r^n]+.^)^([~.^r^n]+.^)^([~»^r^n]+^)$"
Replace All "^2^3»^1"
SortAsc IgnoreCase 1 -1 0 0 0 0 0 0
Find RegExp "%^([~»^r^n]+^)»^(*^)$"
Replace All "^2^1"
Add UnixReOn or PerlReOn (v12+ of UE) at the end of the macro if you do not use UltraEdit style regular expressions by default - see search configuration. Macro command UnixReOff sets the regular expression option to UltraEdit style.
-
Mofi - Grand Master
- Posts: 4055
- Joined: Thu Jul 29, 2004 11:00 pm
- Location: Vienna
2 posts
• Page 1 of 1