Forum Discussion

chydewf1's avatar
chydewf1
Frequent Visitor
8 years ago
Solved

Filtering row based on format

Hi,   I have a list of part numbers where i want to filter anything out that is not in a particular format.   The format I want to keep is:   XX-#####-X-###   Where x = any letter of the alph...
Need Help
  • chydewf1's avatar
    chydewf1
    8 years ago

    Hi v-huizhn-msft

     

    I think I have solved it - The following seems to work well

     

    = if(mid(Table[Column],11,1)="-"&& mid(Table[Column],9,1)="-"&& mid(Table[Column],3,1)="-",TRUE,FALSE)

     

    Thanks for your help

     

    Chris

chydewf1's avatar
chydewf1
Frequent Visitor
8 years ago

Hi v-huizhn-msft

 

Thanks for your reply.

 

It almost works but does not filter this sort of thing:

 0.8X-V175

 

Ideally I would say if the 3rd, 9th and 11th characters are "-" then return TRUE

 

Is there any way I can achieve this?

 

Thanks

 

Chris

 

chydewf1's avatar
chydewf1
Frequent Visitor
8 years ago

Hi v-huizhn-msft

 

I think I have solved it - The following seems to work well

 

= if(mid(Table[Column],11,1)="-"&& mid(Table[Column],9,1)="-"&& mid(Table[Column],3,1)="-",TRUE,FALSE)

 

Thanks for your help

 

Chris