Suneel_gowda
New User
Joined: 18 Aug 2010 Posts: 1 Location: Bangalore
|
|
|
|
Hi All,
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.
Ex:-
Data in table
FIRST_NAME:- Sunil$&(2345)
MIDDLE_NAME :- Manju-nath"hyr&*" 2345
LAST_NAME:- Kumar"sfgh(fdsf)jhfjh" M
Out data : Sunil Manjunath 2345 Kumar M
Regards,
Sunil |
|