Search and replace function

  • Posts: 287
  • Karma: 2
  • Thank you received: 5

Search and replace function was created by alanwjackson

We have a search and replace function
that worked great when redoing database and table names
i want to use it to do mass updates on email addresses
when i did the search, it only presented packages, no objects
I tried the replace and everything got messed up, I had to do a restore
luckily no damage done
can it be enhanced for email addresses?
I was attempting to replace This email address is being protected from spambots. You need JavaScript enabled to view it., with
ajackson@a2bf.com,rhadkar@a2bf.com,

later on I will replace This email address is being protected from spambots. You need JavaScript enabled to view it., with ' ', to remove my name
I am retiring at the beginning of nov 2021 and want to get my replacements name on all the emails, then remove my when the time comes
3 weeks 4 days ago #21330
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 1179
  • Karma: 3
  • Thank you received: 144

Replied by Peter.Jonson on topic Search and replace function

Hi Alan.

Thank you for the feedback.
We will have a look at this one for you.
Peter Jonson
ETL Developer
3 weeks 3 days ago #21331

Please Log in or Create an account to join the conversation.

  • Posts: 1179
  • Karma: 3
  • Thank you received: 144

Replied by Peter.Jonson on topic Search and replace function

Hi Alan.

1) I think in your case it is much better to use global variables instead of hard coding emails
Please have a look at the following tutorial
www.etl-tools.com/tutorials/13-global-variables.html

2) We have extended the functionally of Replace string wizard to allow replacing individual package properties
We also added search properties dialogue to the package designer

I hope you will find those changes useful.
Peter Jonson
ETL Developer
2 weeks 6 days ago #21333
Attachments:

Please Log in or Create an account to join the conversation.

 

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies