Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Find alphabetical letters from a string

Hi,   I need to be able to extract MT940 (type :61:) sums from the string. Basically the issue is that i have the following:   1911011101C5555,55NTRF201911015U//SOM 19111503828   What i need to...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    This expression will break up a string into a list based on alpha characters.

     

    Text.SplitAny([nameofstringhere],Text.Combine({"a".."z","A".."Z"}))

     

    Now just reference the second value with the index of {1}

    Text.SplitAny([nameofstringhere],Text.Combine({"a".."z","A".."Z"})){1}

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

ImkeF  can likely help with the Power Query. One method you might be able to use in DAX assuming you always have 2 decimal points would be something like:

Column = 
    VAR __Start = 12
    VAR __Decimal = FIND(",",[Column1],__Start,LEN([Column1]) - __Start - 1)
RETURN
    MID([Column1],__Start,__Decimal -__Start + 3)