where in the GUI it accepts any special charactersWhy? Why not have the same rules in both places?
Please suggest me which delimeter can be used to split the string (CUSTNAME & CUSTNO) which does not matches with any of the special characters that CUSTNO can have?Why? Why do you want to have two sets of rules?
Udaya Shankara Gandhi wrote:In most applications customers can be companies and company names can have special characters including '!' so it's not wise to use it as a delimiter.
You can any use character as a delimeter which wont repeat in your customer name and customer id data retrieving from the database. My suggestion is use *!* as a delimeter (expecting no person name contains it :) ).
797836 wrote:Are you sure using a different delimiter will not cause just as much impact on the dependent 'functionality'? Not to mention the fact that there will be some data where it will not work. If the code needs to change then better change it with a solution that is fool proof rather than a fragile one.
" Keep them in separate fields and read them back separately"
At this point of time is really tough as that existing code change will have an huge impact on other dependent functionalities. Hence this is ruled out. Is there any other way to deal with it?
Can you tell me how to tell what the first name is and what the last name is for each of those examples? Of course not.
1. abcdefg 2. hijklmnopqr