sugar logic function: strReplace()

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

Hi Andre,

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

How can I remove all characters except numbers?

Thank you very much!

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

Hi Andre,

 Thank you very much! 
Could you please share some regular expression sample? Or the reference that I can study? I couldn’t find one...

Hi Andre,

 Thank you very much! 
Could you please share some regular expression sample? Or the reference that I can study? I couldn’t find one...

You can create custom sugarLogic formulas by reviewing this article. You can understand how to build a regexp in js layer this way.

([0-9]+)

that reg expression should work for searching numbers... you may try it out here: https://regexr.com/ 

Could it be an option to extend Sugar with the new Sugar Logic functions to solve the task?

Thank you very much, Dmytro.

I’m not sure how to extend sugar... I just have an admin role and our instance is on cloud. It seems I can’t modify php file which I’m not familiar with, neither....

please bear with my naive question: which language is the Studio—>sugar Logic function, is it php?

Because when I search strReplace, it seems it’s str_replace....

Sophie,

DevClub is a forum for developers that develop Sugar's new functionality or customize the current one with code developments - with JS and PHP.

AFAIK Sugar Logic is not a developer's language however as for me it looks like a programming language.
From my non-developers perspective, it is a special format for setting up formulas for Calculated fields (which are read-only fields in SUgar)

But the main challenge is that, if I understood Andre correctly, is that out-of-the-box Sugar Logic cannot be used to solve your task, and Andre suggests extending SUgar with a new Sugar Logic function so that you could employ it then

Cloud instance is not an obstacle for SUgar development, therefore, if you are not a developer, you may hire a developer to extend Sugar first - if you decide to follow this way.

But if you prefer not to develop SUgar, you may clear out data in Excel yourself then activate validation to keep phones data clear in the future.
Once the data is cleared in your CRM, you might be in a position to perform filtering via API endpoints without additional  on-the-fly data transformations that may affect performance