Jump to content
Sign in to follow this  

Multiple replacement with StringRegExpReplace

Recommended Posts



Could you please tell me what's wrong in the following instruction :

$Output = StringRegExpReplace($Input, "[àâäçéèêëîïñôöùûüÀÂÄÇÉÈÊËÎÏÑÔÖÙÛÜ]", "[aaaceeeeiinoouuuAAACEEEEIINOOUUU]")

I thought it would replace each character one by one, like the following sed command :

sed "y/[àâäçéèêëîïñôöùûüÀÂÄÇÉÈÊËÎÏÑÔÖÙÛÜ]/[aaaceeeeiinoouuuAAACEEEEIINOOUUU]/" Input.txt > Output.txt

But apparently, the destination regexp is taken as a whole.

For example, I get :

Déjà -> D[aaaceeeeiinoouuuAAACEEEEIINOOUUU]j[aaaceeeeiinoouuuAAACEEEEIINOOUUU]

instead of :

Déjà -> Deja

Is there a simple command for multiple regexp vs. regexp replacement ?

If no, I'll do some kind of loop to replace each characters one by one.

Cheers !

Edited by Faalamva

Share this post

Link to post
Share on other sites


I believe you will need to run an SRER for each replacement letter - you can obviously group the letters to be replaced. I would also suggest a 2D array to hold the pattern strings and replacement letter - like this: ;)

Global $aList[2][2] = [["[àâä]", "a"], ["[éèêë]", "e"]] ; obviously you include all of the possibilities

$sText = "Déjà"

For $i = 0 To UBound($aList) - 1
    $sText = StringRegExpReplace($sText, $aList[$i][0], $aList[$i][1])

MsgBox(0, "Result", $sText)

Note that you can use a simple StringReplace for a single letter (c and n) - but if you using a loop it might be just as quick to run an regex on everything. ;)


Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see my UDFs:


ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area


Share this post

Link to post
Share on other sites

You can even check the

Local $String = 'Déjà'

Local $Replaced

While 1
$Replaced = RegExBackRef($String, '(.*?)([àâäéèêë])(.*)', '\2', "ReplaceFunc")
If $Replaced = -1 Or @error Then ExitLoop
$String = $Replaced

MsgBox(64, 'Test', $String)

Func ReplaceFunc($sMatch)
Switch $sMatch
Case "é","è","ê","ë"
Return "e"
Case "à","â","ä"
Return "a"
EndFunc   ;==>ReplaceFunc
Added this as the third example

Regards :)

My code:

PredictText: Predict Text of an Edit Control Like Scite. Remote Gmail: Execute your Scripts through Gmail. StringRegExp:Share and learn RegExp.

Run As System: A command line wrapper around PSEXEC.exe to execute your apps scripts as System (LSA). Database: An easier approach for _SQ_LITE beginners.

MathsEx: A UDF for Fractions and LCM, GCF/HCF. FloatingText: An UDF for make your text floating. Clipboard Extendor: A clipboard monitoring tool. 

Custom ScrollBar: Scroll Bar made with GDI+, user can use bitmaps instead. RestrictEdit_SRE: Restrict text in an Edit Control through a Regular Expression.

Share this post

Link to post
Share on other sites

Melba23, that's pretty much what I have done, in a more elegant way, thank you ! :sorcerer:

PhoenixXL, thank you also for your example, though it looks a bit less straightforward.

Edited by Faalamva

Share this post

Link to post
Share on other sites

Azjio, it doesn't answer this topic's problem, but by a funny twist of fate, your code will help me for another problem that will soon emerge : reduce all multiple consecutive characters. So, thank you too ! :bye:

Share this post

Link to post
Share on other sites

This is something I considered myself recently. It might be of use.

When making multiple string replacements within a single string, longer strings should generally be replaced first to avoid erroneously replacing substrings within subsequent search patterns. For this we need to sort the search patterns by length (in descending order).

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this