Forum Discussion

Kyle2612's avatar
Kyle2612
Regular Visitor
2 years ago
Solved

CUT OF STRING AT END

Hey guys

 

Today I struggled upon an issue i can't seem to resolve on my own. The data I receive consists of a string value which on its own consists of 3 values split by a comma, e.g. ABCD, EFGH, IJKL. However these are not always from the same format. They can also consist of 2 or 3 values, and all differ on its  own. E.g ABCD, EF, GHL can also exist, and so on. I'm looking for a way to cut off everything to the right of the second value, because the third value is not of interest. Because the third value can differ from 2-4 letters, I can't seem to find the right solution. In addition, it needs to stay a string since after removing the 3rd value, i want to split the values to make new rows for every 1st and 2nd value

Need Help
  • Syk's avatar
    Syk
    2 years ago

    First, split the rows by a delimiter.


    This will give you 3 columns (or more depending on your strings). Just remove the 3rd column

     


    If you're wanting to create rows from these values.... Select both rows and Transform > Unpivot Columns

     

     

     

1 Reply

  • Syk's avatar
    Syk
    Resident Rockstar
    2 years ago

    First, split the rows by a delimiter.


    This will give you 3 columns (or more depending on your strings). Just remove the 3rd column

     


    If you're wanting to create rows from these values.... Select both rows and Transform > Unpivot Columns