Hi, My job is reading FirstName from the table and I want to filter the names which have numbers/special chars in it i.e. ABC13CD, AMN$%£RE and would like to use the valid name which have only chars in it. Could you please help me in getting some help in this. Regards, Ram
Hi Ram, I'm not promising that this is the best way to do it, but it is the way I have used. Basically I use a tMap. The field to be 'filtered' goes through this processing. (see graphic). This removes quotes, converts all types of dash to a hyphen, changes curly quotes to straight quotes. You could add extra bits to remove other unwanted characters or use a regex.
Data validation is the process of ensuring that a program operates on clean, correct and useful data. It uses routines, often called "validation rules" "validation constraints" or "check routines", that check for correctness, meaningfulness, and security of data that are input to the system . Dissertation writing service this way you can always be sure that your data is properly validated/escaped and you don't need to remember if the variable has been previously validated.