Forum Discussion
DAX: Analyze text string and pull key term into new column
I have posted a similar post here: https://community.powerbi.com/t5/Desktop/Extracting-String-From-Column-into-New-Column/m-p/1242884
But am still have trouble extracting some information.
I have the following column named Issue Title:
And I would like to get the following column called Issue ID:
| CRQ000002138239 |
| CRQ000002138090 |
| CRQ000002138079 |
Unfortunately, I am getting this problem due to the instance of 'eCRQ'
Originally I was extracting issues with the key 'CRQ' by: Select the column (Issue Title) > Extract > Text between delimiters >
entering a single space fo reach delimiter
This approach works 90% of the time, but not on the instances where the CRQ ID (CRQXXXXXXX) is listed after eCRQ.
Sample data to make easier to copy:
| OPENG-2179 CRQ000002138239 > Update Shared Customer CTE ACPx Big IP iApp to include Product Based Routing for EDP > 2/6 @11pm |
| OPENG-2178 eCRQ > CRQ000002138090 > OE > Update iApp with Corrected Port Info for Server Refusing Connections |
| OPENG-2177 CRQ000002138079 > OE > Perform maintenance on BigIQ > Increase BigIQ CPU and RAM |
- Anonymous6 years ago
What if you use CRQ0?
If im correct the numbers wont be anything different then a 0 there, atleast for the next years.
1 Reply
- AnonymousNot applicable
What if you use CRQ0?
If im correct the numbers wont be anything different then a 0 there, atleast for the next years.