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
=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,
If user enter tab, the above expression doesn't work, you also need to remove the TABs