|
Replace |
  
|
|
Replace |
|
You have the possibility to use in each column a "replace" condition :
Define the "String to replace" and the "Replacement string" and simply check the appropriate box to let DMC perform this action on each record for the selected column
in this example if the column DESIGNATION contains the text 'Mr' it will be replaced by 'Mrs'
You can also check the External Table "grouped" values to read for this column EACH "pair" of 'Search' and 'Replace' values from a TPS Table declared in DMC
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 also have the possibility to use an UPPERCASE (no case sensitivity) on the 'Search' value so as to include several possibilities of values contained in your data
ie. : Search = 'Hungry' or = 'HUNgry' or = 'hungry' etc .... all those will be replaced by the 'Replace' value IF you check the "UPPER on Search" box
During the data transfer DMC will, for each record, loop on this external table and search for EACH "Search" string and in case of a match will replace it with the "replace" value found
NOTE : The default replacement group Table is selected when you use this Mapping Option BUT when you save the Task as a Profile a COPY of this file is SAVED and is LINKED to the Profile
This means you can use several External replacement files and "link" each to a specified profile - they will also be restored with the profile
the files are copied and renamed under cgf_import/projects_profiles/replace_(ProfileID)