Remove special characters from string

Dheerendra
Dheerendra Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Registered Posts: 21 ✭✭✭✭

Hi Team,

Could you help how to remove special characters from string.

Example - sfgdfddjFYDSRY$^$&^*dfdgGH%#@sfdfhdsfh8686BHJ!)**(

Now I need from string from above example.

Please help

Thanks

Dheerendra

Answers

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,601 Neuron

    @dhyadav79
    ,

    just a quick thought. You might want to look at a visual recipe. In particular the find a replace function.

    https://doc.dataiku.com/dss/latest/preparation/processors/find-replace.html

    —Tom

  • Manuel
    Manuel Alpha Tester, Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Dataiku DSS Adv Designer, Registered Posts: 193 ✭✭✭✭✭✭✭

    In the prepare recipe, there is also the Simplify processor that is helpful to normalise text automatically. I would test it with your data.

    I hope this helps.

Setup Info
    Tags
      Help me…