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)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

MichaelBauld , Try like

 


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

  • MichaelBauld's avatar
    MichaelBauld
    Frequent Visitor
    4 years ago

    Thanks amitchandak , using this variable and combined with the IF and MID functions I've the column pulling the correct letters.