The user copies a text from excel or some where..When he pasted into the application string field or text box, SOH character gets appended.
SOH character - https://i.stack.imgur.com/sspjH.png
char(1) gets appended and causes the parse exception
Either we need to remove using trim or some function or should not allow the text at all. What would be the best approach in this case?