Removing initial characters from string

fromo
fromo Registered, Dataiku Frontrunner Awards 2021 Winner, Dataiku Frontrunner Awards 2021 Finalist, Dataiku Frontrunner Awards 2021 Participant Posts: 2 ✭✭✭✭

I am trying to use a prepare recipe to remove the first x characters from a string and keep the remaining characters.

Tagged:

Answers

  • Ignacio_Toledo
    Ignacio_Toledo Dataiku DSS Core Designer, 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: 415 Neuron

    Hi @fromo
    . This should do the trick:

    2020-11-22_20-49.png

     In that example I'm removing 3 characters, you can change the 3 with whatever value you might want to use.

    Cheers!

  • yethin
    yethin Dataiku DSS Core Designer, Registered Posts: 2 ✭✭✭✭

    Could you help me with a similar formula for removing end characters from string

  • Mattsco
    Mattsco Dataiker, Registered Posts: 125 Dataiker

    Hi Yethin,

    In the find and replace processor you can use the regex: .{3}$ to remove the last 3 characters.

Setup Info
    Tags
      Help me…