2 Replies Latest reply on Jul 17, 2018 1:30 PM by Erin Blad

    Split value with no special characters

    Erin Blad

      I'm trying to find a function similar to what you would find in Excel where you could split your data into multiple columns based on a preset number of characters.  I have a list of User IDs with no spaces or special characters like this:

         

      000000079701GMME251S
      000000079701HNDK321W
      00000079701MRRJ160WD

       

      and I need each value to be split with one character in each column.  So the first ID would be:

      Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9Header 10Header 11Header 12Header 13Header 14Header 15Header 16Header 17Header 18Header 19Header 20
      000000079
      7
      01GMME251S

       

      I saw how to do this with Regex if you have a carriage return, but what do you do if there's no character to separate by?