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
Hi Somesh,
Can you tried below code