Messy data handling in 1 column

[Anonymous]

Hi everyone, I've got a file format I'm trying to handle which puts a whole bunch of different information into the 1 column.

It has date fields - eg 31/07/2018 

It has user names 

It has invoice numbers

There are other columns shown too which are necessary but I wanted to be able to split out the data in the aforementioned column into separate columns. 

E.g. 1 column dates, another for users etc

Is there some sort of functions I can use to do this or DAX code that takes regular expressions (REGEX) to do this too?

thank you!

EDIT: Example image from Edit Query page attached - this shows how time fields and date fields are shown in the one column. I don't show it here but there are also user names in the same field that I'd like to parse. Hope this helps.

[Ashish_Mathur]

Hi,

Share data in a form that can be pasted in an Excel file.  What do the numbers in column B represent?  For the data that you paste here, show the expected result as well.

[HotChilli]

I don't think the initial problem was fully descriptive. 

Are you trying to get a table that looks like

User  01/07/2020 10

Jeff    11/08/2020 15

?

[Anonymous]

Hi @HotChilli , sorry was in  other projects over the last 2 days. That's exactly what I'm trying to do. Keep the value column as it is but trying to extract user names, and dates from the column where those data inputs are combined.