🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Replace values by conditional match

dedeer

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.

Image: https://us.v-cdn.net/6030995/uploads/editor/qj/ym67p3haz41p.png

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?

Find more posts tagged with

AI Studio

RegEx

Replace

Accepted answers

hbajpai

Hey @dedeer ,

You can use Generate attributes to create a cleaned attribute as following. If it just few cases that you want to clean.

if(contains(model,"200"),"L200",model)

Also, you can explore regex with Replace operator for a more generalized solution.

All comments

hbajpai

Hey @dedeer ,

You can use Generate attributes to create a cleaned attribute as following. If it just few cases that you want to clean.

if(contains(model,"200"),"L200",model)

Also, you can explore regex with Replace operator for a more generalized solution.