Forum Discussion

Oros's avatar
Oros
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Split column DIGIT to NON-DIGIT

Hello.  

 

I tried to split a column from DIGIT to NON-DIGIT, but the decimal is created in another column.  Any help is appreciated.  Thanks.

 

 

This SHOULD BE the result:

 

But this is the result (wrong)

 

  • Hi Oros 

    You are on the right track, but split by number of characters.  Go to home tab, split column,number of characters.

    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos πŸ‘are nice too.
    Nathaniel

     

     

     

5 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion

    Hi Oros ,

    Any other parameters or restraints? Will these all be grams? or will they all be 4 letters at the end?

    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos πŸ‘are nice too.
    Nathaniel

      • Nathaniel_C's avatar
        Nathaniel_C
        Icon for Community Champion rankCommunity Champion

        Hi Oros 

        You are on the right track, but split by number of characters.  Go to home tab, split column,number of characters.

        Let me know if you have any questions.

        If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos πŸ‘are nice too.
        Nathaniel