Replace Query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Alifeller
    Junior Member
    • Nov 2019
    • 1

    Replace Query

    Hello,

    Is it possible to search a string in a field and replace using a formula?
    I can do this easily in MySQL. I have searched the Forum with 0 results/hits.

    what I am attempting to do it clean up upon entry for example field "website" is user copies and paste it includes "https://" or "http://"
    I find it pointless to enter this info and it takes up space based on the limit of the field.
    Basically I was to remove "https://" or "http://" from the string upon saving mywegmansconnect.

    Regards.
    Last edited by Alifeller; 11-30-2019, 06:29 AM.
  • Maximus
    Senior Member
    • Nov 2018
    • 2731

    #2
    Hello,
    go to Administration -> Entity Manager -> YourEntity -> Filds -> create a new field of the "URL" type and enable a "trim" parameter for this field. It will remove "https://" or "http://" part.

    Comment

    Working...