Replace values by conditional match

dedeerdedeer Member Posts: 9 Contributor II
Hi all,

I searched the community and couldn't find the answer. Maybe it was solved before but I need it urgently. So appreciate if you answer again. 

I am working on a very messy dataset. As you look above, models L200, L 200, MITSUBISHI L200 etc. (I mean all of them) are the same model of a brand. I would like to replace any value that has "200" with "L200". 

ex  value  - --------------------- -new value
MITSUBISHI L 200              -L200
L 200                                    -L200
L200 4x4                              -L200
so on. 

is there any easy way of doing it? 

Best Answer

Sign In or Register to comment.