Share via

Data Cleanup in Power Query/Power BI

Bei Jing 1 Reputation point
2022-06-19T04:52:37.71+00:00

Greetings,

I have a single column of data with dash or hyphen between letters and digits. I would like to use Power Query to clean up the format with the following rule*.

*No dash before or after a letter, but okay between numbers.

sample file attached with variations of the data value and desired outcome after transformation steps. Letters contain only upper case "A".."Z" and digits contains "0".."9". There is no special characters other than "-". None of the data values has a leading or ending with a "-".

Thanks.212659-sampledata.pdf

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
41,443 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-06-19T12:44:21.517+00:00

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and 145510-image.png if the reply is helpful--

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.