[MJPNUH Contributions: 0Level 1☆]

Hello,

Quick one but I can't stitch it together, I'd like to remove the final 3 characters from a string value (remove the second half of a postcode) in a search, What's the easiest way to do it? The final 3 characters will be random, alpha-numeric values so there's no consistency.

Thanks

Mike
This is a cached copy. Click here to see the original post.

[JCirocco Contributions: 0Level 1☆]

Something like

SUBSTR({zipcode}, 1, (LENGTH({zipcode}-3))

[MJPNUH Contributions: 0Level 1☆]

Originally posted by JCirocco

View Post

Something like

SUBSTR({zipcode}, 1, (LENGTH({zipcode}-3))

Hey JCirocco

That worked a treat, very slight tweak to order:

SUBSTR({zipcode}, 1, (LENGTH({zipcode})-3))

Thanks a lot.

[Author]

Posts