Forum Discussion
Solved
Power Query | Batch Replace String
Hi, How do I replace this: Foreign Language 1 Foreign Language 2 Foreign Language 3 Foreign Language 4 Foreign Language 5 Foreign Language 6 into this in a single pass: In ...
In that case you can use this code:
= Table.TransformColumnNames(Table1, each try Translations{[Foreign = _]}[English] otherwise _)It searches each column name in the Translations table and - if found - replaces it with English; if not found then leave it as is.
Basically, this is how the raw data looks like:
| Foreign Language Header 1 | Foreign Language Header 2 | Foreign Language Header 3 | Foreign Language Header 4 | Foreign Language Header 5 | Foreign Language Header 6 |
| Data | Data | Data | Data | Data | Data |
| Data | Data | Data | Data | Data | Data |
| Data | Data | Data | Data | Data | Data |
| Data | Data | Data | Data | Data | Data |
| Data | Data | Data | Data | Data | Data |
| Data | Data | Data | Data | Data | Data |
| Data | Data | Data | Data | Data | Data |
| Data | Data | Data | Data | Data | Data |
| Data | Data | Data | Data | Data | Data |
In that case you can use this code:
= Table.TransformColumnNames(Table1, each try Translations{[Foreign = _]}[English] otherwise _)It searches each column name in the Translations table and - if found - replaces it with English; if not found then leave it as is.
As usual from you MarcelBeug an excellent knowledge share, Another gem in my M treasure chest..
Thank you!!!