Find value in column

[pawelj795]

Hi, 
I have column like below.


I want to find customer number (e.g.39965929 -> in above example).

How to do this?

Maybe use FIND() function?

[amitchandak]

Check :https://docs.microsoft.com/en-us/dax/search-function-dax

[pawelj795]

@amitchandak 

Ok, but I need to find value between fourth and fifth space.

How to do this?

[v-kelly-msft]

Hi @pawelj795 ,

You need a calculated column as below:

Column = 
var a = SEARCH(" ",'Table'[Column1])
var b = SEARCH(" ",'Table'[Column1],a+1)
var c = SEARCH(" ",'Table'[Column1],b+1)
var d =SEARCH(" ",'Table'[Column1],c+1)
var e =SEARCH(" ",'Table'[Column1],d+1)
Return
MID('Table'[Column1],d+1,e-d)

And you will see:

For the related .pbix file,pls click here.

 
Best Regards,
Kelly

[pawelj795]

@v-kelly-msft 

It's not working in my file, I really don't know why ..

[pawelj795]

@v-kelly-msft 

I think I know what creating problem.

I have some rows without 5th space.

Is there any solution to get round this?