Replace last characters of a string with its entire elements

Question

I have an element in my dataframe which I want to modify. I have a column with the following type of values

https://mns-xyz-eu.abc.com/ccs/proposal?action=view&proposalId=12345

I want to replace the entire string with just the last 5 characters (i.e) Replace the entire character string with 12345 in this case.

How do I achieve this? Thanks a lot.

`substr(string, nchar(string) - 4, nchar(string))` – Ronak Shah Aug 11 '19 at 13:02 — Ronak Shah, Aug 11 '19 at 13:02

A. Suliman · Answer 1 · 2019-08-11T12:57:14.160

0

One option is using a positive look behind using stringr::str_extract

str_extrct('https://mns-xyz-eu.abc.com/ccs/proposal?action=view&proposalId=12345', 
           '(?<=proposalId\\=)\\d+')
#Simple option
str_extract('https://mns-xyz-eu.abc.com/ccs/proposal?action=view&proposalId=12345', '\\d+')

edited Aug 11 '19 at 12:57

answered Aug 11 '19 at 12:51

A. Suliman

12,923
5
24
37

Replace last characters of a string with its entire elements

1 Answers1