Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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
  • Anonymous's avatar
    Anonymous
    6 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    What if you use CRQ0?

    If im correct the numbers wont be anything different then a 0 there, atleast for the next years.