How to remove Carriage Return from String while inserting into database

=load(
  local!AscIICode:code("Hi,
                     This is a Requirement
                     Here is a issue
                     We have to solve"),
                   
  trim(
    joinarray(
      char(
        remove(
          local!AscIICode,
          wherecontains(
            tointeger(10,13,9), /* Characters to remove */
            local!AscIICode
          )
        )
       ),""
      )
    )
)

Try CODE function, it converts the characters into Unicode

Hi Vinay,

Thank you for your reply.
I am able to solve this by writing an expression, which is similar as you suggested.
The expression is

joinarray(difference(split(pv!rejectionDetails.rejectionInfo,char(13)),{char(13)})," ")

Thank you once again

Hi,

If user enter tab, the above expression doesn't work, you also need to remove the TABs

Hi,
As I told initially when I was using only this expression difference(split(pv!rejectionDetails.rejectionInfo,char(13)),{char(13)}) there were commas, but when i used joinarray on top of it with separator as null, it removed comma as well.
I tested this in my system and is working without any issue.

Just be advised that both char(13) and char(10) are used for line breaks depending on the type of form (portal vs. tempo or sail); last I checked, portal forms actually submit BOTH char(13) and char(10) with each linebreak, whereas tempo/sail uses only char(10). (I could be slightly off, it's been a while since I last dealt with this, but it was something very close to this at least).

I'm not sure if you're seeing different results or not, but you might need to check and account for this.

If you install the Appian Regular Expression Functions plugin, you can write a VERY simple expression rule to trim whitespace:

regexreplaceall("^[\s]+|[\s]+$",ri!text,"")

I made a slight modification to replace the line breaks with spaces to avoid having words stuck together.

Basically you can just create a rule with "text" as a rule input and just paste this in.

a!localVariables(  
  local!textAscii:code(ri!text),
  trim(
    joinarray(
      char(
        updatearray(
          local!textAscii,
          wherecontains(
            tointeger(10, 13, 9),
            local!textAscii
          ),
          32
        )
      ),""
    )
  )
)

Hi Somesh,

Can you tried below code