Removing last word from string.

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

Removing last word from string.

How can I remove the last word in a string?


Accepted Solutions
Solution
‎06-22-2016 04:07 PM
Regular Contributor
Posts: 154

Re: Removing last word from string.

Good question. This was answered on StackOverflow as well as in this code example.

 

Essentially, you can pass -1 in to CALL SCAN to get the last word, and once you've found it, it's trivial to remove.

View solution in original post


All Replies
Solution
‎06-22-2016 04:07 PM
Regular Contributor
Posts: 154

Re: Removing last word from string.

Good question. This was answered on StackOverflow as well as in this code example.

 

Essentially, you can pass -1 in to CALL SCAN to get the last word, and once you've found it, it's trivial to remove.

Occasional Contributor
Posts: 19

Re: Removing last word from string.

Thanks! Any advice on how to remove the second word from a string? I'm trying to check between two variables that excluding the 2nd word both strings are identical.

Regular Contributor
Posts: 154

Re: Removing last word from string.

Try the same steps, but using CALL SCAN with a count of 2.

Occasional Contributor
Posts: 19

Re: Removing last word from string.

That only keeps the first and 2nd word, but I want the entire string minus the 2nd word.

Regular Contributor
Posts: 154

Re: Removing last word from string.

Oh, I see. Well in the StackOverflow post,

substr(starting_word,1,pos-2);

is used to return a string that includes all but the last word.

 

You'll probably need this:

call scan(original_string, 2, pos, length);

to get the length and position of the second word, then

first_piece = substr(original_string, 1, pos-1)

(maybe pos-2 to remove the space between the words)

 

and

second_piece = substr(original_string, pos+length, lengthOfString)

(you'll have to calculate lengthOfString using the LENGTH function)

 

Then use a CAT function (see here for a good description of the different choices) to combine first_piece and second_piece.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 2132 views
  • 1 like
  • 2 in conversation