Title

Message

Confirm

<< DiscussionsReply

wanted: macro to change date slashes to hyphens

DyNama
3 discussion posts
Hi, gang,
Clipboard Fusion is really cool!
i need a macro to change date slashes to hyphens, eg 01/01/2013 to 01-01-2013. i can't program in C# or VB but i can edit when it looks evident, so i edited Replace Spaces with Hyphens to do the trick. the problem is that my sources also contain paths with forward slashes which also get replaced. could a macro be written that only replaces slashes that have 2- or 4-digit numbers on both sides? that could cause trouble with a path like D:/roses/12/01.jpg or http://roses.com/12/01.jpg so maybe a solution would be to only replace in a line before a ":/" if that's even possible.
01/01/2013, 13:01, http://roses.com/12/01.jpg - Mozilla Firefox -> 01-01-2013, 13:01, http://roses.com/12/01.jpg - Mozilla Firefox
Jan 26, 2013  • #1
Keith Lammers (BFS)'s profile on WallpaperFusion.com
This should be possible. I'll look into it some more and I'll post the macro when it's ready

Thanks!
Jan 30, 2013  • #2
Keith Lammers (BFS)'s profile on WallpaperFusion.com
Quick question: Is the date always at the start of each line? If so, we should be able to just do a replace on the first 10 characters of each line, or even just replace the first two forward slashes on each line.
Jan 30, 2013  • #3
DyNama
3 discussion posts
oops, sorry for the delay getting you an answer. yes, in fact it is always at the start of the line. i think either of those solutions would be fine.
Feb 4, 2013 (modified Feb 4, 2013)  • #4
Keith Lammers (BFS)'s profile on WallpaperFusion.com
No worries! I'll look into this as soon as I get a chance.

Thanks!
Feb 5, 2013  • #5
Keith Lammers (BFS)'s profile on WallpaperFusion.com
Ok, here you go! Please let me know if you run into any issues with this macro.

Note that it will replace the 3rd and 6th characters in the line with a hyphen, regardless of what the original character was. So, this macro is only useful on lines that are formatted exactly the way you mentioned in your original post.

Thanks!
• Attachment: Change Date Slashes to Hyphens.jpg [105,344 bytes]
Change Date Slashes to Hyphens.jpg
Change Date Slashes to Hyphens.jpg
• Attachment: Change Date Slashes to Hyphens.txt [276 bytes]
Feb 8, 2013  • #6
DyNama
3 discussion posts
That will work! Thanx, Keith!
Feb 8, 2013  • #7
Keith Lammers (BFS)'s profile on WallpaperFusion.com
Excellent, glad to hear it!
Feb 8, 2013  • #8
Was this helpful?    
<< DiscussionsReply