Find and append a value to a field

KristinDavis

I'm trying to align some inconsistencies with our data. What I'd like to do is find any value that does not end with a '/' and append it with that character.

1. Is there a case statement where we can look for a field that does or does not end in a character?
2. I assume if I can do that, I can just append those without with the '/'

KristinDavis

Thank you both! This was really helpful. I ended up using a modification:

CASE
WHEN RIGHT(Page Path,1) = '/' THEN Page Path
ELSE CONCAT(Page Path,'/')
END

MarkSnodgrass

You could do this:

CASE WHEN RIGHT(myfield,1) = '/' THEN myfield ELSE CONCAT(myfield,'/') END

GrantSmith

Here's a regex version:

REGEXP_REPLACE(`field`, '^(.+)\/?', '$1/')

KristinDavis

Thank you both! This was really helpful. I ended up using a modification:

CASE
WHEN RIGHT(Page Path,1) = '/' THEN Page Path
ELSE CONCAT(Page Path,'/')
END