Navigation:  DMC User Interface > Tweak > Replacement Groups

If you need to do Multi-Replacements on STRINGS during a Data Transfer for one or several

columns you can use this module to define them.

 

 

These "groups" go by pairs : a Search (for) value and a Replace (with) value - plus a Row ID

to let you move them up or down inside the table ie :. if the Table contains 'Monsieur' linked to

'Mister' and 'Madame' linked to 'Madam' , then in this column each occurrence of 'Monsieur' will

be replaced by 'Mister' AND each occurrence of 'Madame' will be replaced by 'Madam'

 

You can also Import groups from an external ASCII (csv or txt) Table formatted like this "Search","Replace" :

"Monsieur","Mister"

"Madame","Madam"

.....

 

If you need to have a COMMA inside a search or a replace text then please

use |,| and DMC parser will recognize it as such

 

If you need to have one or several SPACES inside a search or a replace text then please

use <SP> and DMC parser will recognize it as such

In the screen capture the last entry means DMC will search for ' S ' and replace it with ' South '

 

The Table will first be emptied and then only the import will begin.

 

DUPLICATES IN CSV TABLE

You will be offered to SKIP them - the first "duplicate" record will be imported - (or not).  If you select not

to skip them, you will be prompted for EACH duplicate to keep the PREVIOUS value or replace it with the newly

found one. NOTE : if the CSV table to import contains many records and many duplicates this process can be time consuming

---