0

Remove break lines in a text field

How can i auto-remove any break lines from a pasted text?

3 replies

null
    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    you can add a trigger after update:

    ---

    YOURFIELD:=replace(YOURFELD,"

    "," ")

    ---

    regards

    Leo

    • telemarket2
    • 5 yrs ago
    • Reported - view

    Thank you Leo!

    There is a way to concatenate more that one replace function?

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    Yes, you can write the commands one semicolon at a time, e.g.

    YOURFIELD:=replace(YOURFELD,"

    "," ");

    YOURFIELD:=replace(YOURFELD,"  "," ");

    YOURFIELD:=replace(YOURFELD,"ä","ae");

    YOURFIELD:=replace(YOURFELD,"ö","oe")

     

    Leo

Content aside

  • 5 yrs agoLast active
  • 3Replies
  • 2144Views