Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Count all fields with pattern

Hi,   I have a table where some of the fields do not match to my pattern and the pattern should be to take only those field which does not have a hyperlinks. Let's say that from 10 rows in column 5...
Need Help
adudani's avatar
adudani
Memorable Member
3 years ago

hi Anonymous ,

please provide a sample input table and output table/ screenshot.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Sure. Exemplary table:

     

    ID |  Manufacturer  |  Hyperlink             |

    1  |  Tesla                | http://tesla.co        |

    2  |  Nissan             | http://nissan.com  | 

    3  |  Renault           |                                |

    4  |  Volvo              |         -                      |

    5  | Toyota             |  N/A                        |

     

    1. I would like to have counted all "blanks" , "-" and "N/A" (maybe also others sign) catched and counted. But I do not know what user might put in "hyperlink" field except of above examples that's why better to have some kind of regex which counted all wrongly filled out fields. I mean for example those not starting from http:// and maybe show me with some tooltip? visualisation? another column? Not sure here. 

    2. Also, all those field without http:// should be marked in red to see at once.