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.

Find 24h Time Format, replace with 12h AM/PM time format

Help with writing and playing macros
Post a reply

Find 24h Time Format, replace with 12h AM/PM time format

Postby Beaver » Tue Dec 14, 2004 10:29 am

Hi,
probably easy, but I just can't find the solution right now:

I would like to replace all time occurrences in 24h format by 12h AM/PM format, i. e. ($ is used for <Space>-Character, # is used for Tab-Character):

17:21:20#Hello#17:21:28
18:25:20#Tree#18:25:29

should convert to:

$5:21:20$PM#Hello#$5:21:28$PM
$6:25:20$PM#Tree#$6:25:29$PM

Thanks for your help!
User avatar
Beaver
Newbie
 
Posts: 1
Joined: Tue Dec 14, 2004 12:00 am
Top

Re: Find 24h Time Format, replace with 12h AM/PM time format

Postby Mofi » Wed Dec 22, 2004 3:39 am

This macro should do the job. If your 24h time strings are not with leading 0 for hours 0-9 define the find regular expression for these hours without the first 0 or use [0]++ instead of the first 0.

InsertMode
ColumnModeOff
HexOff
UnixReOff
Find RegExp "11:^([0-5][0-9]:[0-5][0-9]^)"
Replace All "11:^1 AM"
Find RegExp "10:^([0-5][0-9]:[0-5][0-9]^)"
Replace All "10:^1 AM"
Find RegExp "09:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 9:^1 AM"
Find RegExp "08:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 8:^1 AM"
Find RegExp "07:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 7:^1 AM"
Find RegExp "06:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 6:^1 AM"
Find RegExp "05:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 5:^1 AM"
Find RegExp "04:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 4:^1 AM"
Find RegExp "03:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 3:^1 AM"
Find RegExp "02:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 2:^1 AM"
Find RegExp "01:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 1:^1 AM"
Find RegExp "00:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 0:^1 AM"
Find RegExp "12:^([0-5][0-9]:[0-5][0-9]^)"
Replace All "12:^1 PM"
Find RegExp "13:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 1:^1 PM"
Find RegExp "14:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 2:^1 PM"
Find RegExp "15:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 3:^1 PM"
Find RegExp "16:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 4:^1 PM"
Find RegExp "17:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 5:^1 PM"
Find RegExp "18:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 6:^1 PM"
Find RegExp "19:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 7:^1 PM"
Find RegExp "20:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 8:^1 PM"
Find RegExp "21:^([0-5][0-9]:[0-5][0-9]^)"
Replace All " 9:^1 PM"
Find RegExp "22:^([0-5][0-9]:[0-5][0-9]^)"
Replace All "10:^1 PM"
Find RegExp "23:^([0-5][0-9]:[0-5][0-9]^)"
Replace All "11:^1 PM"
User avatar
Mofi
Grand Master
Grand Master
 
Posts: 4066
Joined: Thu Jul 29, 2004 11:00 pm
Location: Vienna
Top
Post a reply

Return to Macros

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group