Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Atm my data is like a list of sentence like following:
FPTS is our (Case ID)
Column
I want to find the word "FPTS" and extract it's ID and have it inside a new colomn. As you can see the word I need to extract doesn't have the same position all the time! sometimes it shifts What I try to do is extract FPTS-xxxx from above which would be:
would help a lot to find a solution!
Solved! Go to Solution.
Hi!
So, use this expression to concatenate the value!
"FPTS-" &Text.Start(Text.AfterDelimiter([<yout original text column here>], "FPTS-"),4)
Cheers
Hi, @Anonymous!
We can solve it in a bunch of ways. a Simpler one is to extract the desired data into a new Column using M language in your Query editor.
So, let's see how to do it!
First of all, in Query Editor, click on "Add Column" and select "Custom Column".
If you need to extract just the numbers, this code can deal with it:
If you want to have the original value, you can concatenate the text with this code in M language:
"FPTS-" &Text.Start(Text.AfterDelimiter([<yout original text column here>], "FPTS-"),4)
That's it
Ps.: If you do not use the original column in your report, be sure to delete it before finishing your data preparation, just to get a great performance with your final model.
If I helped you to reach your goals, please, mark this as solution!
Take care!
It helped a lot thank you so much 🙂 only last step were to still have the "FPTS-" part or would that be to complicated to add in the custom colomn: So instead of only have the numerical value also have the "FPTS-" the reason for this is it well be used for a reference point to another colomn 🙂
Hi!
So, use this expression to concatenate the value!
"FPTS-" &Text.Start(Text.AfterDelimiter([<yout original text column here>], "FPTS-"),4)
Cheers
It's solved thank you so much 🙂
These photo I just attached is the solution I really want "atm this were done manually" but really don't it to do auto, because have over 4000 rows so manual process on this is not a option :S
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
17 | |
17 | |
16 |
User | Count |
---|---|
29 | |
27 | |
18 | |
14 | |
13 |