Forum Discussion
Solved
Filter by a alphanumeric sequence
Hi all, In a certain table I have duplicated rows where the old ones have this format "name_XXXX-XXX_customer", and the new ones "XXXX-XXX_customer". I want to display in the report only the new ...
- Perhaps not the most efficient way, but I'm trying to think of ways I can explain to you that don't require custom M code. In the Transform Data Power Query Editor:
Select the Customer column,
Click on the Add Column tab in the ribbon and choose Extract > Text Before Delimiter
Choose _ as your delimter and expand Advanced options.
Start from Right and skip 1 delimiter.
This should give you a new column with the Name portion or blank. Filter this column using the arrow to select only null or blank values.
Close and Apply your changes.
Save.
Perhaps not the most efficient way, but I'm trying to think of ways I can explain to you that don't require custom M code. In the Transform Data Power Query Editor:
Select the Customer column,
Click on the Add Column tab in the ribbon and choose Extract > Text Before Delimiter
Choose _ as your delimter and expand Advanced options.
Start from Right and skip 1 delimiter.
This should give you a new column with the Name portion or blank. Filter this column using the arrow to select only null or blank values.
Close and Apply your changes.
Save.
Select the Customer column,
Click on the Add Column tab in the ribbon and choose Extract > Text Before Delimiter
Choose _ as your delimter and expand Advanced options.
Start from Right and skip 1 delimiter.
This should give you a new column with the Name portion or blank. Filter this column using the arrow to select only null or blank values.
Close and Apply your changes.
Save.
Thanks! I'll try and come back