How to omit the last 5 characters in any text?

7788kit · 2024-09-03T10:38:26.942Z

Hi all,

For the life of me I cannot figure out how to do this. I want basically chop off the last 5 characters in a given piece of text, the text is always going to be longer than 5 characters but will vary in length e.g 10-15 characters.

I’ve tried:

Truncate, but that doesn’t work because of the text length variable
I’ve tried using regex (.{3}) but that only captures the last 3 characters. Any way I can invert what it captures?

Anyone have suggestions? Thanks a bunch!

georgecollier · 2024-09-03T10:50:31.257Z

Text:truncated to (Text:number of characters - 5) is a non-regex method that would work

timzyroyalz · 2024-09-03T10:59:35.760Z

use split by

adamhholmes · 2024-09-03T11:03:23.893Z

Timil4Tech:

use split by

How would that work?

georgecollier · 2024-09-03T11:04:05.363Z

You could use the same regex (.{5}) inside :find and replace. Replace with nothing to remove them. That’s probably the cleanest solution.

timzyroyalz · 2024-09-03T11:41:35.676Z

you can use split by to remove the characters for split by {goat} will remove characters starting from goat

7788kit · 2024-09-03T12:52:25.247Z

Didn’t know you could do that on truncate, this did the trick! Thanks!!

adamhholmes · 2024-09-03T13:48:28.070Z

Who mentioned anything about a goat?

But in any case, how is that applicable here?

Unless you mean, first establish what the last 5 characters are (by truncating from end to 5), then split the main text by those characters, and select the first item? That would work.

You could do the same with find and replace: truncate the string to 5 chars form the end, then use find and replace to replace those character in the original string with nothing.

Both would work, but Text:truncated to (Text:number of characters - 5) is simpler (I think so anyway).

boston85719 · 2024-09-03T17:30:18.156Z

adamhholmes:

Who mentioned anything about a goat?

I saw a truck driving down the road tonight with 3 goats tied to the back trying to trot behind it…jerk didn’t know he had been dragging one of those goats for a few hundred yards, the poor thing.

timzyroyalz · 2024-09-04T23:02:14.431Z

you are welcome

system · 2024-11-12T10:38:39.767Z

This topic was automatically closed after 70 days. New replies are no longer allowed.