Power Query extract account number from a column with different texts

[acortez]

I need to extract the account numbers only, what formula should I use for custom column?

Thanks!

[lbendlin · Accepted solution]

filter by items that contain a dash "-"

[v-sgandrathi]

Hi @acortez,

hank you @SundarRaj and @lbendlin for your response regarding the issue.

I'm glad that your query was resolved. If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

 Thank you for your understanding!

Thanks for connecting with the Microsoft Fabric Community Forum.

[v-sgandrathi]

Hi @acortez,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If the response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thanks for using Microsoft Fabric Community Forum.

[v-sgandrathi]

Hi @acortez,

I wanted to follow up on the previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a Kudos so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank You for choosing Microsoft Community Forum.

[SundarRaj · Accepted solution]

Hi @acortez 
1. You could use a List.Transform function and extract only the Account Numbers. I'll attach an image of the code dor your reference. Thanks!

[lbendlin · Accepted solution]

filter by items that contain a dash "-"