Is there a way to do a wildcard search and replace ?
Something like....If field_x like "%zz%", replace field_x with "xyz".
Wildcard search and replace ?
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).
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3
- Joined: Fri Jun 16, 2006 9:28 am
Re: Wildcard search and replace ?
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
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".
Senior DataStage TX Consultant
(On-site, Off-site services)
Email: edukulla@yahoo.com
Tel: 925-699-3949
Fax: 775-251-7649
(On-site, Off-site services)
Email: edukulla@yahoo.com
Tel: 925-699-3949
Fax: 775-251-7649
Re: Wildcard search and replace ?
no, he does not want to replcae the a single set of string, he wants to replace the whole feild.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".