locked
Truncate expression RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User954998566 posted

    Hi, 

    I have SSN which is in this format 055-68-6748 , i need to truncate it to this format xxx-xx-6748 based on condition 

    so it would be iif(Fields!TruncateSSN.Value=1, Fields!SSN.value, 'XXX-XX-left(4,Fields!SSN.value ) 

    Can you help me correct this expression plz . 

    Thanks

    Wednesday, July 16, 2014 12:08 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User954998566 posted

    iif(Fields!TruncateSSN.Value=1, replace(Fields!SSN.value,Fields!SSN.value, "XXX-XX-"& left(4,Fields!SSN.value ) ), Fields!SSN.value ) 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, July 16, 2014 12:45 PM