How Extract TicketNumber from Text

[lboldrino]

i need only the ticketnumbers from any desciption, 

my steps:

duplicate the column:

  WorkDescription - Copy

= Table.TransformColumns(#"Reordered Columns", {{"WorkDescription - Copy", each Text.BeforeDelimiter(_, "—"), type text}})

= Table.TransformColumns(#"Extracted Text Before Delimiter", {{"WorkDescription - Copy", each Text.AfterDelimiter(_, "#"), type text}})

and now?

how can i extract only the ticketnumbers?

thanx for any idea! 

lg 

[mahoneypat · Accepted solution]

Please see this video that covers just this scenario.

Power BI Tales From The Front - Extracting Numbers From Text - YouTube

Regards,

Pat

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file and clearly show the result you are expecting.

[PhilipTreacy]

Hi @lboldrino 

Please see this PBIX file for 2 examples of doing this.  Please supply sample data in questions so we don't have to retype everything.  You can just copy/paste the data/text.

One question- in your data above, there are cells where there is more than 1 ticket number, do you only want to extract the first number?

In the first example in my file I've just created a list of ticket numbers from some sample data I typed in.

giving this result

Note that the numbers as displayed in scientific notation, you can change them to text if you need/want to, but leave them as number type if you need to do any numeric calculations.

The 2nd example is more in line with yours, giving this result

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.