This topic contains 2 replies, has 0 voices, and was last updated by MJPNUH 6 years, 10 months ago.

  • Author
    Posts
  • #22630 Score: 0

    MJPNUH
    • Contributions: 0
    • Level 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.

  • #22631 Score: 0

    JCirocco
    • Contributions: 0
    • Level 1

    Something like

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

  • #22632 Score: 0

    MJPNUH
    • Contributions: 0
    • Level 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.

You must be logged in to reply to this topic.