Thread Details
  • State Verified Answer
  • Replies 10 replies
  • Answers 1 answer
  • Subscribers 370 subscribers
  • Views 3569 views
  • Users 0 members are here
Forum Actions

sugar logic function: strReplace()

sophie sun

Hello there,

anybody please help with the strReplace?

I want to replace two characters inside a word: " " and "-" via Studio-->module--->fields---->edit formula(using logic function).

But when I write:  strReplace([" ","-"],"",$field)  it doesn't work....

How can I do that, please?

One more thing, if I will repeatably use one calculated result, can I create a variable there? Like this: 

$t = strReplace(" ","",$field)

strlen($t)

it looks like, I will get error...

Thanks in advance for any help!

Parents
  • 0

    sugarLogic function strReplace only support strings, not array. You should call it twice, one for " " and another one for "-".

    So the final formula would be strReplace(" ","",strReplace("-","",$field))

    Cheers

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Hi Andre,

    If my string has different other characters: -   .   ()  etc.

    How can I remove all characters except numbers?

    Thank you very much!

Reply Children
  • +1 in reply to sophie sun

    It can bee accomplished by creating a custom sugarLogic formula which uses regular expression for replacing any characters but numbers. This is not a big deal to do.

    Cheers

    André Lopes
    Lampada Global
    Skype: andre.lampada