- Posted by
- It seems I need to run the macro more than once to get the file sorted. I created an excel spreadsheet to generate a list of random ip's A1 =INT(RAND()*(255-1)+1) B1 =INT(RAND()*(255-0)+0) C1 =INT(RAND()*(255-0)+0) D1 =INT(RAND()*(255-0)+0) E1 =A1&"."&B1&"."&C1&"."&D1 I take the E column and dump it...Posted in Find/Replace/Regular Expressions
-   Topics
-   Views
- IccMyself
Jun 25, 2005
- Quick and dirty macro, surely not the best solution. The macro expands all values to 3 numbers by adding the missing leading zeros, sort it and removes the leadings zeros. Remove the red lines at the end of the macro, if you don't want to remove the added zeros. The file should contain only the IP ...Posted in Find/Replace/Regular Expressions
-   Topics
-   Views
- IccMyself
Jun 21, 2005
- How can I sort a list of IP's with UltraEdit ? I can sort a list of IP's in Unix by sort -n -t . +0 -1 +1 -2 +2 -3 +3 -4 <file> UE can sort the list but it puts them in nuermical order.. such as... 191.116.33.195 191.17.3.241 191.17.71.242 191.222.0.106 which should be.. 191.17.3.241 191.17.71.242 1...Posted in Find/Replace/Regular Expressions
-   Topics
-   Views
- IccMyself
Jun 17, 2005