How to switch US dates to Euro dates in Word
Thread poster: Doron Greenspan MITI

Doron Greenspan MITI  Identity Verified
Israel
Local time: 06:30
Member (2005)
English to Hebrew
+ ...
Oct 25, 2010

An interesting one, this:

I have about 30 Word docs where there are plenty of dates in US style (Month/Day/Year), and i'd like to change them in each doc into Euro style dates (Day/Month/Year).

Is there any smart way to do it using global Find & Replace?

Thanks, Doron


Direct link Reply with quote
 

István Hirsch  Identity Verified
Local time: 05:30
English to Hungarian
With a regular expression Oct 25, 2010

http://word.mvps.org/FAQs/General/UsingWildcards.htm
(Example 2: Transposing dates)

[Módosítva: 2010-10-25 15:08 GMT]


Direct link Reply with quote
 

Doron Greenspan MITI  Identity Verified
Israel
Local time: 06:30
Member (2005)
English to Hebrew
+ ...
TOPIC STARTER
Thanks, that seems just that - BUT one question... Oct 25, 2010

From your great reference, I was led to an even nearer one:

http://word.mvps.org/FAQs/General/TransposeDates.htm

But let me ask you this:

In that example, they show how to change 12/17/85 to 85/12/17
but I need to change 12/17/85 to 17/12/85 - how would I do that?

I tried moving the 'Replace With' placeholders around a bit, but it still doesn't get me where i want...

Thanks again, Doron


Direct link Reply with quote
 

Gerard de Noord  Identity Verified
France
Local time: 05:30
Member (2003)
German to Dutch
+ ...
Should work Oct 25, 2010

Replace With:

\2/\1/\3

or

\2-\1-\3

Cheers,
Gerard


Direct link Reply with quote
 

István Hirsch  Identity Verified
Local time: 05:30
English to Hungarian
An idea Oct 25, 2010

The replacement that Gerard suggested should work. Haven't you forgotten to check the "Use Wildcard" checkbox in Find and Replace window?

As for global replacement, if you mean you wish to transform the dates in all the 30 Word files in a single step, I think it is only possible with a macro.

István


[Módosítva: 2010-10-25 19:40 GMT]


Direct link Reply with quote
 

Doron Greenspan MITI  Identity Verified
Israel
Local time: 06:30
Member (2005)
English to Hebrew
+ ...
TOPIC STARTER
Sorted - it was a Heb-specific issue Oct 26, 2010

Thanks Istvan and Gerard, apparently, after much experimenting, it appeared a Hebrew-specific (or BiDi-specific) issue.

The\2/\1/\3 did work, but was dislaying the date the other way round (2005/6/25).
So I added "English (US)" as another filter to both fields (Find ; Replace with) and now it's perfect.

Many thanks, I'm going to use that Word reference a lot!

Doron


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How to switch US dates to Euro dates in Word

Advanced search






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search