Forum Discussion
Data manipulation based on an unstructured column
Hello everyone, I'm dealing with some data where the primary key is not structured well, so I should somehow extract the information using power query or any other solution from your point of vie...
Create a custom column in Power Query using this expression:
Text.Select([Column1],{"0".."9"})
Hi, thank you for your answer. However, there are some incidents like:
| Passasu | Passau Uni | Germany | AAC82821 |
and for those incidents, I have to take like "AAC82821" including the char.
Additionally, when there is an incident like (779 University | 212131), this solution retrieves 779212131 where I have to include only 212131. Is there also a condition or function for ignoring those types of strings in the data?