Hello,
I am new to the forum and had posted this query today morning but due to some glitch it has not appeared in the forum.
My problem is simple. I have files with data in 3 formats:
ALL UPPER CASE
Only Initial Letter in Upper case
all lower case.
Example:
AAA
Abc
aaa
BBB
Def
bbb
Using Ultraedit sort routine I get:
AAA
Abc
BBB
Def
aaa
bbb
Whereas what I want is
ALL UPPER CASE FIRST
First letter in Upper case next and
all lowercase at the end
Example
AAA
BBB
Abc
Def
aaa
bbb
Is there a macro to do this job? I work with huge files and cleaning them manually is getting painful. A macro would really help.
Many thanks in advance
Best rgrds,
Boromir
I am new to the forum and had posted this query today morning but due to some glitch it has not appeared in the forum.
My problem is simple. I have files with data in 3 formats:
ALL UPPER CASE
Only Initial Letter in Upper case
all lower case.
Example:
AAA
Abc
aaa
BBB
Def
bbb
Using Ultraedit sort routine I get:
AAA
Abc
BBB
Def
aaa
bbb
Whereas what I want is
ALL UPPER CASE FIRST
First letter in Upper case next and
all lowercase at the end
Example
AAA
BBB
Abc
Def
aaa
bbb
Is there a macro to do this job? I work with huge files and cleaning them manually is getting painful. A macro would really help.
Many thanks in advance
Best rgrds,
Boromir