Forum Discussion

acortez's avatar
acortez
New Member
1 year ago
Solved

Power Query extract account number from a column with different texts

I need to extract the account numbers only, what formula should I use for custom column?   Thanks!  
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    filter by items that contain a dash "-"

  • SundarRaj's avatar
    SundarRaj
    1 year ago

    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!

     

     

SundarRaj's avatar
SundarRaj
Super User
1 year ago

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!