Help with a multiple text replacement script

Even though this forum so far has been for sharing scripts and not for writing them, I was wondering if I could pick the brains of AHK experts ( and  come to mind right now), to figure something out.

I'm trying to put together a script to do multiple text replacements at a segment level, i.e., for the active segment only, so I can easily see what has been changed, without calling up the Find & Replace window.

I've managed to put together this script (silly examples included):

#r::
ClipSaved := ClipboardAll
Clipboard =
SendInput, ^a^c
ClipWait, 30
FixString := Clipboard
vList := " ;continuation section
(
dog perro

house casa
¿ ¿
/ /
, ,
? ?
. .
pie 2 pie2
m 2 m2
)"
Loop, Parse, vList, `n
{
oTemp := StrSplit(A_LoopField, "`t")
FixString := StrReplace(FixString, oTemp.1, oTemp.2)
}
oTemp := ""
Clipboard := FixString ; load the new string to clipboard
Sleep 200
Send ^v
Return

This works fine in segments with no tags, but when there are tags, they get stripped at some point during the replacement operation and the text that is pasted back into the segment has all the necessary replacements but no tags. Is there any way of preserving the tags in the clipboard?

I came up with a very clumsy workaround for this, which involves using Studio's Delete to Next Tag shortcut, so instead of Select All-Copy, the script would do Delete to Next Tag-Undo-Copy:

#r::
ClipSaved := ClipboardAll
Clipboard =
;SendInput, ^a^c
;ClipWait, 30
Send ^+D ;delete to next tag
Sleep 100
Send ^z ;undo
Sleep 50
Send ^c
ClipWait, 30
FixString := Clipboard
vList := " ;continuation section
(
organisation organization
¿ ¿
/ /
, ,
? ?
. .
pie 2 pie2
m 2 m2
)"
Loop, Parse, vList, `n
{
oTemp := StrSplit(A_LoopField, "`t")
FixString := StrReplace(FixString, oTemp.1, oTemp.2)
}
oTemp := ""
Clipboard := FixString ; load the new string to clipboard
Sleep 200
Send ^v
Return

While this also works in segments with no tags, I would like to optimize it.

My second question is: how would I go about creating a list of all these replacements (CSV? Excel?) and getting the script to take them from there instead of having to add them manually to the script? I've been reading up on arrays but I'm still far away from being able to implement what I need.

I have another simpler script attempt with just multiple StringReplace lines (see below), but again, that would require creating possibly hundreds of replacement lines and I imagine it's not the best solution.

#p:: 
Send, ^a
Send, ^c
StringReplace, clipboard, clipboard, dog, perro, All
StringReplace, clipboard, clipboard, cat, gato, All
StringReplace, clipboard, clipboard, raining, lloviendo, All
Send ^v
Return

So, any help with this would be greatly appreciated.

Thank you!

  • Hi Nora,

    About the special characters ñ and á, I had a similar problem when I processed strings in a Dragon command.

    The problem occurred because the string was being converted from Unicode to ASCII.

    I was using the Windows registry to pass strings between Dragon commands. Unfortunately strings in the Windows registry are ASCII only, so when another command retrieved the string the special characters had been converted to regular characters without the accents.

    I had to write a more complicated interface that converted each Unicode character in the string into three permissible "ASCII characters" (excluding ASCII zero, which is used as the terminating byte for the registry string) and then reversed the conversion when the string was retrieved.

    Maybe a similar Unicode to ASCII conversion is happening somewhere in your situation.

    Best regards,
    Bruce Campbell
    ASAP Language Services

  • I guess that's possible. I also had something similar in KnowBrainer, but my workaround was to write all my commands involving accented and special characters directly in Dragon (no string manipulation, though, just simple commands like copy-paste).
  • Hi Nora,

    I just noticed that you are using a text file. (Sorry, I am not following all the details of what you are doing...)

    Are you saving strings to a text file and then retrieving them?

    If so, maybe check the encoding of the text file.

    Check by opening the file, and then opening the "Save As" dialog (File->Save As).

    At the bottom of the dialog box you will see a drop-down list for "Encoding:"

    I think "ANSI" is the default. Try changing it to "Unicode" and see whether this helps.

    Best regards,
    Bruce Campbell
    ASAP Language Services

  • Hi Bruce,

    That was it! I had created the file in Notepad++ without making any changes to the encoding. I've now saved it as Unicode (was UTF-8 originally) and it's working fine. Thank you!
  • Good morning, Nora!

    Here we go:

    1. When you use SendInput, %FixString%, AHK sends the content of the variable directly to the currently active control in the active window, so there is no need to first copy the content of the variable to the clipboard and then the clipboard content to Studio by sending [Ctrl]+[ V ].
      It is even possible to send the content of a variable directly to a control that is in a non-active window via the command ControlSend, but in the case of Studio, this wouldn't work too well because of the changing control names.
      In principle, SendInput, %FixString% should paste the corrected string back into the target segment, overwriting the existing target since it would still be selected by the initial Send, ^a command. If you add a Send, ^v after that, it is normal that the original unmodified target gets also pasted since the clipboard still contains only the unmodified target from the command Send, ^c.
    2. As already pointed out by Jesus, if you need to support special characters like accents, diacritic marks or other alphabets like Cyrillic or Greek, both the AHK script and any external file need to be in Unicode (UTF-8), otherwise you risk encountering corrupted characters. Advanced text editors like Notepad++ usually use UTF-8 as the default file encoding, but the standard Windows Notepad uses ANSI.
    3. Since we are not talking about a CSV file, the only character that would need to be escaped or that might cause trouble would be the tab character itself since it is used as a delimiter. All other characters should be handled correctly when added literally.

    Don't hesitate to get back to me if anything is still unclear ;-)

     

    Have a great day!

    Raphaël

  • Thank you for the explanation, Raphaël, I will have to play around a bit more with #1, as I can't get it to paste back to the Studio segment via SendInput + the variable. I also want to create a script to batch replace a bunch of these little things in the whole file via the Find and Replace dialog, so I guess I'll experiment a little with ControlSend, keeping in mind the issue with the changing control names.
  • Hello Nora Díaz,

    I know nothing about writing lines to make a script to work. And I am so glad that I found your script which actually saves me a lot of time of working. Thank you so much for this!!

    I mean this one:

    #p::
    Send, ^a
    Send, ^c
    StringReplace, clipboard, clipboard, dog, perro, All
    StringReplace, clipboard, clipboard, cat, gato, All
    StringReplace, clipboard, clipboard, raining, lloviendo, All
    Send ^v
    Return

    But I got a problem when I try this line: StringReplace, clipboard, clipboard, cto, Chief Technology Officer, All

    My wish is to expand the short "CTO" to full "Chief Technology Officer" every I meet the short word.
    But this sentence: "Director, cto" will become "DireChief Technology Officerr, Chief Technology Officer" because there is "cto" in the word "director" and I don't know how to fix this.

    Could you help me please??
    Thank you so much!!

  • Try with this:

    SendMode, Input

    ; -- Win + p -> Select all text + replace whole word only

    #p::
    Search := "cto"
    Replace := "Chief Technology Officer"
    Gosub, CheckKeysPressed
    Send, ^a
    Gosub, SelectToClip
    Clipboard := RegExReplace(Clipboard, "i)\b" Search "\b", Replace)
    Send, ^v
    Return

    SelectToClip:
    Clipboard := ""
    Send, ^c
    ClipWait, 0
    If ErrorLevel
        Exit
    Sleep, 50
    Return

    CheckKeysPressed:
    While GetKeyState("Ctrl","P") || GetKeyState("LWin","P") || GetKeyState("RWin","P") || GetKeyState("Shift","P") || GetKeyState("Alt","P")
        Sleep, 25
    Return
  • Many many thanks Rafa Gómez !!!
    It works perfectly!!
    I have a list of hundred words such as "cmo" for "Chief Marketing Officer", "&" for "and", "mba" for "Master of Business Administration"... Can you show me how to put more words to your script please?

    And I am using this script, it helps me to capitalize every words except "and, a, an,in....". I tried to combine your script (the one you just wrote for me) with the one I am using but it didn't work.

    ^+SPACE::
    Send, ^a
    Send, ^x
    StringUpper str, Clipboard, T
    head := SubStr( str, 1 , 1 )
    tail := SubStr( str, 2 )
    Clipboard := head RegExReplace( tail , "i)\b(a|an|and|in|the|with|of)\b", "$L1")
    StringReplace, clipboard, clipboard, &, and, All
    StringReplace, clipboard, clipboard, svp, Senior Vice President, All
    StringReplace, clipboard, clipboard, vp, Vice President, All
    StringReplace, clipboard, clipboard, mba, Master of Business Administration, All
    StringReplace, clipboard, clipboard, r&d, Research and Development, All
    StringReplace, clipboard, clipboard, m&a, Mergers and Acquisitions, All
    StringReplace, clipboard, clipboard, mena, Middle East and North Africa, All
    StringReplace, clipboard, clipboard, cfo, Chief Financial Officer, All
    StringReplace, clipboard, clipboard, ceo, Chief Executive Officer, All
    StringReplace, clipboard, clipboard, co-head, Co-Head, All
    Send ^v
    RETURN

    ****For the final result, my wish is the ability to do something like this:

    - From: vice president of r&d, japan & singapore
    - or: vp of r&d, japan & singapore

    Can transform immediately into:

    - Vice President of Research and Development, Japan and Singapore
    with just one key press.

    Please have a look and help me if you have spare time.

    I am truly appreciate your help.
    Thank you so much!!