DSXchange

Is there a way to do a wildcard search and replace ?

Something like....If field_x like "%zz%", replace field_x with "xyz".

Yes, but it depends in which type of object you wish to do this. If you want to do changes in the Designer you can do them along the lines you put, but there is no standard interface to do this for all objects in the repository (although you can work with the repository directly, although it is neither supported nor encouraged).

I assume you are trying to replace something in maps? If so yo can do it this way also.

First Export the map to xml file, then do search, replace and save the xml. Then re-import the xml file as map. you will see all the changes.

Regards,
Kiran

jazzer1 wrote:Is there a way to do a wildcard search and replace ?

Something like....If field_x like "%zz%", replace field_x with "xyz".

techpeople wrote:I assume you are trying to replace something in maps? If so yo can do it this way also.

First Export the map to xml file, then do search, replace and save the xml. Then re-import the xml file as map. you will see all the changes.

Regards,
Kiran

jazzer1 wrote:Is there a way to do a wildcard search and replace ?

Something like....If field_x like "%zz%", replace field_x with "xyz".

no, he does not want to replcae the a single set of string, he wants to replace the whole feild.