Wildcard search and replace ?

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
jazzer1
Participant
Posts: 37
Joined: Mon Mar 20, 2006 10:26 am

Wildcard search and replace ?

Post by jazzer1 »

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

Something like....If field_x like "%zz%", replace field_x with "xyz".
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

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).
techpeople
Participant
Posts: 3
Joined: Fri Jun 16, 2006 9:28 am

Re: Wildcard search and replace ?

Post by techpeople »

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".
Senior DataStage TX Consultant
(On-site, Off-site services)
Email: edukulla@yahoo.com
Tel: 925-699-3949
Fax: 775-251-7649
changming
Participant
Posts: 68
Joined: Wed Oct 13, 2004 3:35 am

Re: Wildcard search and replace ?

Post by changming »

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.
Post Reply