+ Reply to Thread
Results 1 to 2 of 2

Find replace to fix mixed Greek and Latin characters

  1. #1
    Forum Contributor
    Join Date
    06-09-2009
    Location
    Greece
    MS-Off Ver
    Office 365
    Posts
    133

    Find replace to fix mixed Greek and Latin characters

    The idea is to fix words like these where the first character appears to be Latin, but in fact it is Greek (one can tell that when changing it to lowercase):

    Αstart
    Τgjk
    Μdlkj
    Νsdjfskl
    Εsdjfskl
    Ζdjfskl
    Ηjfskl
    Ιjfskl
    Κjfskl
    Οjfskl
    Υjfskl
    Χjfskl
    Ρagioi

    So my idea was to find any of those Greek characters when followed by an English one and then replace the Greek character with correct English character (i.e. the Greek "Τ" with the Latin "T"). Is this possible with a single replacement operation?

    So far the find is the one below but I am not sure about the replace:
    ([ΑΒΕΖΗΙΚΜΝΟΡΤΥΧ])([A-z])

    The English characters would be:
    [ABEZHIKMNOPTYX]

    The Greek as Hexadecimal code points

    Please Login or Register  to view this content.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Find replace to fix mixed Greek and Latin characters

    That would be feasible to do with a macro, but the code to do so would run much slower than simply iterating through all the upper-case Greek characters. The former would require a loop to be built into the replace process to analyse each upper-case Greek character as it's found, then overtype it with the corresponding Latin character. By the time you've processed a few dozen such strings, replacing characters one at a time and with perhaps with thousands more to go, a looping process iterating through the same 22 characters but using ReplaceAll would have finished.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Determine latin characters in cells
    By akotronis in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-17-2013, 01:50 PM
  2. Import data containing foreign, non-latin, language characters using VBA
    By drieger22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2012, 05:30 PM
  3. Replace Latin Acute Char from Excel data
    By lordofthering in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2011, 03:03 PM
  4. Find and Replace (mixed formats)
    By pnmaggs2001 in forum Excel General
    Replies: 3
    Last Post: 10-13-2005, 06:12 AM
  5. Replies: 0
    Last Post: 01-28-2005, 09:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1