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