Forum Discussion

SamiS's avatar
SamiS
Frequent Visitor
4 years ago
Solved

Replace or remove values that are not in specified format. (Find and keep values)

I am working with a bad quality dataset that has many annoying errors. Please help me with one that I haven't solved yet.   There is two columns:   SERIAL-NUMBER and DESCRIPTION - Serialnumber sho...
Need Help
  • SamiS's avatar
    SamiS
    4 years ago

    Thanks to all who answered!

    In fact, I took a part from everybody's answer to build my own solution.

     

     

    I created a new column where...

    1...all acharacters but digits and used delimeters are removed.

    2...text is splitted by any defined delimeter.

    3...text is combined back with delimeter "-", but only if format is correct (4 digits + 4 digits)

     

     

SamiS's avatar
SamiS
Frequent Visitor
4 years ago

Thanks to all who answered!

In fact, I took a part from everybody's answer to build my own solution.

 

 

I created a new column where...

1...all acharacters but digits and used delimeters are removed.

2...text is splitted by any defined delimeter.

3...text is combined back with delimeter "-", but only if format is correct (4 digits + 4 digits)

 

 

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi SamiS ,

    Glad to hear that it can be solved by yourself with others' ideas and thanks for your sharing your workaround.

     

    You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

     

    Best Regards,
    Community Support Team _ Yingjie Li