Forum Discussion

MichaelBauld's avatar
MichaelBauld
Frequent Visitor
4 years ago
Solved

Extracting the first letter after a defined text string within a column

Hi all,    I have a dashboard showing invoice payments by supplier name. This is filtered by the first letter of each supplier account as processing invoices is assigned to staff  by the first lett...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    MichaelBauld , Try like

     


    Pos = var _pos = SEARCH([Column1],,0)+4
    return
    mid([Column1],_pos,1)

ddpl's avatar
ddpl
Icon for Solution Sage rankSolution Sage
4 years ago

MichaelBauld ,

Try below steps in Power Query...

 

Step 1: Replace "t/a " (t/a[space]) with ","

 

Step 2: Add a Custom Column...

Your Need = if Text.Contains( [Suppliers], "," ) = true 
            then Text.Start( Text.AfterDelimiter( [Suppliers], "," ), 1 ) 
            else Text.Start( [Suppliers], 1 )

 

Hope it will work for you.