In Ledger one of Sundry Debtors name is 'Field manager Agricultural' which contains Special Character which is not visible. When export to XML it shows as 'Field manager Agricultural'. When i export to CSV the Agricultural word comes to next line. I want to remove Special Character (CRLF). How to remove it ? View attachment 7888
CR is Carriage Return - ASCII value is 13 LF is Line feed - ASCII value is 10 You need to alter your ledgers before exporting. Even Character "&" (ASCII value 20) will throw the same response.
Recently, in other threads, some members have given various pointers/functions to remove or trim unwanted spaces....... kindly use that.
I have used this function $$RemoveNonAlphaNumWithSplChar. The problem is that i have to specific other Special character as parameter which is required, which i cannot predict as the user can us any special character. $$StringPart($$RemoveNonAlphaNumWithSplChar:$Name:" ,[,],(,),|,\,/,!,~,`,<,>,?,',;,:,*,")):0:500
Instead of trying to rectify mistakes of users and removing characters............. Simply make a condition to force user to use only Alphabets and Numerals.