Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Extract a specific strong from a column

Hi,

 

this seems like a really straight forward task but I can't find a solution

 

I have a table of expenses, and I need to exclude the expenses that are mileage from my data.

 

Unfortunately the only data I have to go off for this is an inconsistent "description" column, with values that might look like this:

 

DescriptionCost
Drive to meeting - mileage - James54.22
Site visit - 33245 - mileage13.00
Catering - 33245128
Jess - Uber to airport - 4455075
mileage - Harry - 17/1042.10
Equipment hire - 33450 - Suppliers pty ltd - approved by Jess500
33245 - mileage10

 

All I want to do is create a column that extracts each instance of "mileage" from the "description" column, which I will then use to filter out the results I do not want. All of the default extract options are no good as the data is too inconsistent.

  • Hi Anonymous ,

    Is this what you are looking for? 


    If so, you can create a conditional column as below: 

1 Reply

  • m_alireza's avatar
    m_alireza
    Solution Specialist

    Hi Anonymous ,

    Is this what you are looking for? 


    If so, you can create a conditional column as below: