Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dear,
I have huge data with mixed of numbers and text. I want to remove all suffux text (like T,A, B etc) from the data. Suffix is not organised, some time only one Text, some time twice, 3 etc...
As - Is | To be |
A205T | A205 |
A205TM | A205 |
A220TP | A220 |
A220TO | A220 |
A300AU | A300 |
A300AR | A300 |
A300BFF | A300 |
A300BGGH | A300 |
A300BII | A300 |
A300BRR | A300 |
A300DS | A300 |
A300DE | A300 |
A300DF | A300 |
A300DG | A300 |
A300DH | A300 |
A300DJ | A300 |
A300EK | A300 |
A300EQ | A300 |
A770 | A770 |
A770KO | A770 |
A770AB | A770 |
A770Gyy | A770 |
A770Gk | A770 |
Santhosh
Solved! Go to Solution.
You can accomplish this by going into Power Query and Extracting the first characters; which is your case seems to be the first 4 characters.
In Power Query:
Thank You !! I tired this option.
Sorry, the count is mixed, it is not organised, I don't how many different varient count I have in data.
CT2535KE - CT2535 E55A-E55 E45RTYU -E45
|
Try this:
Thank you very much !!!!
Glad I could help! Please mark the post as a solution to help others! 😁
User | Count |
---|---|
86 | |
83 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |