I have code a program which reads from a Db2 table and writes in to a flat file.
The table will have FIRST_NAME (40), MIDDLE_NAME(40) and LAST_NAME(40) and some other fields
The requirement as below,
1. Have to concatenate all the names.
2. Have to remove the set of special characters like %,$,@,* etc.
3. Have to remove the spaces between the first, middle and last name.
4. Have to remove the string present within double quotes r within braces.
Data in table
MIDDLE_NAME :- Manju-nath"hyr&*" 2345
LAST_NAME:- Kumar"sfgh(fdsf)jhfjh" M