Data360 Analyze

 View Only

  • 1.  Remove leading numbers/string/character

    Posted 03-10-2021 22:00

    I have some data here that I want to remove the leading 676 digits from it on both column.

     

     



  • 2.  RE: Remove leading numbers/string/character

    Posted 03-10-2021 23:01

    Hi Tevita

    The Trim Fields node can handle this.

    Node config:

    Sample output based on your input above:

    You can also optionally specify input fields to include/exclude from the Trim operation.

    Example attached.

    Regards