Pulling out the letter out of string

[Anonymous]

Dear All,

I need to pull out the letter out of string data in column: 

For example from 5SNA 075065G0323 I need pull out "G", from 5SNA 0800N330100 "N", 5SLD 1200J450350 "J" etc.

I have checked the similar cases in this forum, but unfortunately my string does not have gaps between the figures to make an easy extract, maybe there is another way. Can you please give a hint?

Thanks in advance!

[Anonymous]

I think I wrote a bit confusingly, I need to pull the mentioned letters and have them in a separate colum accordingly

[Fowmy]

@Anonymous 

Did you check my solution?
It gives you the letters in a separate column.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Fowmy · Accepted solution]

@Anonymous 

Add the following column in Power Query:

 = Text.End(Text.TrimEnd([Column1],List.Transform({0..9}, each Number.ToText(_))),1)

Your table looks like this before adding the column

Result

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[amitchandak]

@Anonymous , You can use text.remove in power query and use id condition to control

https://docs.microsoft.com/en-us/powerquery-m/text-remove

In dax you can use

https://docs.microsoft.com/en-us/dax/replace-function-dax

https://docs.microsoft.com/en-us/dax/substitute-function-dax

[Greg_Deckler]

@Anonymous  - Perhaps split based upon space into two columns. Remove all alpha characters from second column. Splice them back together.