- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-10-2021 05:30 AM | |||
Anonymous
| 02-08-2023 07:57 AM | ||
Anonymous
| 03-14-2019 08:29 AM | ||
12-15-2024 05:04 AM | |||
Anonymous
| 04-04-2023 05:49 AM |
User | Count |
---|---|
131 | |
102 | |
85 | |
53 | |
46 |