Details about this thread
  • State Not Answered
  • Replies 1 reply
  • Subscribers 319 subscribers
  • Views 628 views
  • Users 0 members are here

Replace mutiple strings in a calculated field using sugar logic function: strReplace()

Christopher Hart

I am using the below to replace a string which works well

strReplace($mft_part_num,"",$name,false)

However some of the parts start with a dash " - " which I also want to replace witrh blank.

This is not working,. 

Fullscreen
1
strReplace("-","",toString(strReplace($mft_part_num,"",$name,false)))
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Does anybody have any sugestions please

  • 0 Sugar Employee Badge

    Hi , 

    I tried a similar scenario and it's working on my test. 
    You are missing the Boolean flag on your second formula.

    Can you try something like this? 

    Fullscreen
    1
    strReplace("-","",strReplace(toString($mft_part_num),"",$name,false),false)
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX