Find and replace wildcard?

As per title. Is there a way to add a wildcard to the “Find and replace” rule?

I got this column and I’d like to remove everything after a ". ". A dot and a space. Which means all the “VAT exempt” and similar annotations related to VAT.
I’ve tried using * but it doesn’t seem to work.

Hey @Axel_Delgado,

To my knowledge you can’t add a wildcard in the “Find and replace” step.

But there’s a couple other options to get your desired effect:

Option 1

Use a “Split column” step and split the “detail” column by ". ". Now your first column will be what you wanted.

Option 2

Use a regex step to do find and replace with wildcards.

(Trickier option if you don’t regex already)


Brian Dawson
Automation Consultant

2 Likes

Option 1 did the trick. Thanks!

1 Like

Hi Brian, Here’s a slightly different question and I hope the answers not too obvious !! :wink:

How do I remove the entire email address for specific domain names e.g. @guest.booking.com or @m.expediapartnercentral.com
in a column of email addresses?

.

Hi @Mark_Berry - Happy to help! One way you could do this:

  • Use 2 Filter rows steps to create 2 branches- one will keep all rows that contain the email domains that you are targeting and the other will remove them
  • After the row that filters to keep the domains, use a Clean data step to remove all characters from the email column. This will remove the email address from that field
  • Finally, use a Stack tables step to add the newly cleaned data back to the rest of the data- be sure to ‘Match up data by column names’

This is how those steps will look:

I hope that helps but let me know if you have any questions!

1 Like