Forums › Cached › Customization › Searches / List Views

This topic contains 3 replies, has 0 voices, and was last updated by BrianE 6 years, 9 months ago.

  • Author
    Posts
  • October 5, 2017 at 3:29 pm #22708 Score: 0

    Mike Kennedy
    • Contributions: 0
    • Level 1
    • ☆

    I'm trying to figure out how to get this to work.

    Code:
    CASE WHEN {shipaddress1} IS NULL THEN {shipaddress2} // Works
    ELSE (
    CASE WHEN {shipaddress1} IN 'Attn: ' THEN {shipaddress2} // Does not Work
    ELSE {shipaddress1} // It allway goes here
    END
    )
    END
    If shipaddress1 has "Attn:" at the beginning, then I want to print shipaddress2 instead

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

  • October 5, 2017 at 4:26 pm #22709 Score: 0

    pcutler
    • Contributions: 0
    • Level 1
    • ☆

    are you looking for

    Code:
    CASE WHEN {shipaddress1} LIKE 'Attn:%' THEN…

  • October 5, 2017 at 7:50 pm #22710 Score: 0

    Mike Kennedy
    • Contributions: 0
    • Level 1
    • ☆

    That worked.

    Thanks PCutler

    Code:
    CASE WHEN {shipaddress1} IS NULL THEN {shipaddress2}
    ELSE (
    CASE WHEN {shipaddress1} LIKE 'Attn:%' THEN {shipaddress2}
    ELSE {shipaddress1}
    END
    )
    END

  • January 24, 2018 at 10:02 am #22711 Score: 0

    BrianE
    • Contributions: 0
    • Level 1
    • ☆

    The two levels of case statements are not really needed:

    Code:
    CASE WHEN {shipaddress1} IS NULL THEN {shipaddress2}
    WHEN {shipaddress1} LIKE 'Attn:%' THEN {shipaddress2}
    ELSE {shipaddress1}
    END

  • Author
    Posts

You must be logged in to reply to this topic.