Enterprise & Sell

Enterprise & Sell Answers & Best Practices Replace mutiple strings in a calculated field using sugar logic function: strReplace()

Click here to join this group and curate your SugarClub experience.

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

Christopher Hart over 1 year ago

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,.

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

Does anybody have any sugestions please

Parents

0 Andre Serrazina over 1 year ago
Hi Christopher Hart,

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?

strReplace("-","",strReplace(toString($mft_part_num),"",$name,false),false)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Andre Serrazina over 1 year ago
Hi Christopher Hart,

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?

strReplace("-","",strReplace(toString($mft_part_num),"",$name,false),false)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data