Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
I think I wrote a bit confusingly, I need to pull the mentioned letters and have them in a separate colum accordingly
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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
@Anonymous - Perhaps split based upon space into two columns. Remove all alpha characters from second column. Splice them back together.