When renaming columns using Find and Replace and using Regular Expressions, there is no option to have that rename recurring.

[4a0098b7f9b243add27a]

The functionality of the replacement could mirror the same for row-field values where "Multiple Occurrences" is a flag under Advanced Settings.

Column Rename Find & Replace options

Field Value Replace options

[Trifacta_Alumni · Accepted solution]

Hi, Jonathon--

Yes, this should be available with the next major update of GDP. Search term: Rename columns based on a pattern.

There will be a Match all occurrences checkbox at the bottom of the page.

Cheers,

-SteveO

[4dfface0b54019ae8eb8]

Wow that's quick, thank you guys, this will be really useful!

[4dfface0b54019ae8eb8]

PS: When is the next major update of GDP due?

[4dfface0b54019ae8eb8]

Seems to be a two month release cycle usually. Last one was in Nov 2018 so one it's due shortly. I guess it's a bit later due to Xmas holidays...

https://cloud.google.com/dataprep/docs/release-notes

[Trifacta_Alumni]

Hi, Christian--

Unfortunately, I don't have a timetable for this next major release. If you need to check it out now, it is already available in the free version of Wrangler: cloud.trifacta.com.

Cheers,

-SteveO

[4dfface0b54019ae8eb8]

Hi Steve, I tested today in the free Cloud version and it worked as expected, I can replace multiple matches of the searched string. Thanks

[4dfface0b54019ae8eb8]

PS: I got an error earlier trying to post this response:

Sorry! We encountered an unexpected error. Please try to post again. If the error persists, contact customer support. Error: 218283955-201772 (-1036038060)