I have a file which has the first name let's say FNAME pic x(12)
which needs to be match with the name in file FullName pic x(25).
This fullName is a combination of first name and last name logically but its not physically divided in 2 parts of first name and last name.
FNAME contains a string/name say Bharat
and FullName contains Bharat Juneja.
I need to check that :
1) FullName contains Fname
2) The part of FullName from beginning of the string till the first space encounters i.e. before the last name starts should match with the FNAME in the first file.
I hope its clear. Please ask if you need any clarifications.
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
if fullname contains
' Bharat Juneja' (space preceeds Bharat)
'Bharati Juneja' (additional letter added to Bharat)
'Juneja Bharat' (first name follows last name seperated by space)
'Juneja,Bharat' (first name follows last name seperated by comma)