Skip to main content
Question

How To remove carriage return from Multi-Line text field

  • March 11, 2022
  • 0 replies
  • 360 views

Hello,

I have searched for this subject and found 1 post with 0 responses.  

I'm pulling in info from QB using Power Query, a Multi-line text field is not pulling at all when there

are multiple lines created using a carriage return / line feed.  Is there a function similar to CLEAN (instead of TRIM)? or how can I replace the non visible carriage return using another text formula field (without taking the table down clean it and re-uploading)

thanks,



------------------------------
Ayman Hanash
------------------------------

    MarkShnierYou
    Forum|alt.badge.img+24
    Try this as a formula text field.

    SearchAndReplace([My multi line text field], "\n", " ")

    That says to replace any carriage returns with a space.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
      Forum|alt.badge.img+3

      The issue is with other non-printing characters.
      Windows, Mac & Windows deals with this differently. 
      Some only add <carriage return>, <New Line> or Both of them at the end of each line.
      "\n" will only get <carriage return>
      You can UUEncode the text to get all of the problem characters, then run a SearchandReplace() for each one then decode the text.  it is not pretty but it works.
      This also work to find and remove Non-printing ASCII, Unicode & emoji Characters which can cause problems.

      NOTE: Quickbase HTML processing will modify what is displays on the view form, to see what is actually in the field you must EDIT the record and get the data from the field.

      I hope this will point you to the correct information.

      Terms & ConditionsAccessibility statement