How to remove Carriage Return from String while inserting into database

Hi All,

 

We are using Portal designed forms and we have a requirement to get Feedback from Customer and it is a Paragraph Field.

Since it is a Paragraph Field, customers are giving Feedback in the form of new lines, like below

Hi

This is a Requirement

Here is a issue

We have to solve

When this data is inserted into Database (SQL Server) it is getting inserted as below.

Hi
 This is a Requirement
 Here is a issue
 We have to solve

For this we tried to solve by using below expression

difference(split(ac!additionalInformation,char(13)),{char(13)})

but the result for this is  Hi, This is a Requirement, Here is a issue, We have to solve.

Now we have to remove comma from this so we tried below expression but that did not work

difference(split(difference(split(ac!additionalInformation,char(13)),{char(13)}),char(44)),{char(44)}).

 

Note: If user gives comma in the string it should not be removed.

Please help us in resolving this issue.

 

Thanks in advance.

 Discussion posts and replies are publicly visible