Power BI
Under ReviewAbility to use wildcards in power query transformation find section of replace values.
bhobgood on 17 Mar 2015 08:12:03
In the transformation area of replace values it would be nice to be able to use a wildcard in the value to replace field. For example we have transaction descriptions like... Placement [EB-12375596] and it would be great to be able to enter something like... Placement% to capture all of these. I've got several work-arounds but this would be a great feature for those who don't know SQL.
- Comments (16)
RE: Ability to use wildcards in power query transformation find section of replace values.
Ditto! Would be nice to have. I now have to add several steps to cover several different "literal" scenarios, whereas a wildcard would reduce it down to one step. In addition it would be nice if you could search for values only or text only, or a combination. Something like ".0#" would look for a values ".00", ".01", ".02"... ".09" but NOT ".0a" or any other non-digit string, and replace it with the value provided. (We would need a char for "any values".) Or if you wanted to replace text strings use "?" for single char, and * for any characters.
RE: Ability to use wildcards in power query transformation find section of replace values.
this is really needed!
RE: Ability to use wildcards in power query transformation find section of replace values.
Must have feature!!
RE: Ability to use wildcards in power query transformation find section of replace values.
Would prefer Regex
RE: Ability to use wildcards in power query transformation find section of replace values.
Must have feature!!
RE: Ability to use wildcards in power query transformation find section of replace values.
Must have feature!!