how to check A string contains string B

bharat_juneja · New User Joined: 21 Dec 2005 Posts: 20 Location: US

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.

Problem:-
FNAME contains a string/name say Bharat
and FullName contains Bharat Juneja.

I need to check that :
1) FullName contains Fname
OR
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.

DavidatK · Posted: Wed Apr 05, 2006 10:43 pm

bharat_juneja,

A question.

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)

Do you want these found or not

Thans,

Dave

bharat_juneja · New User Joined: 21 Dec 2005 Posts: 20 Location: US

Well, the requirement is not pretty clear as of now.
But I assume all the above stated should also be found along with
"Bharat Juneja".

It will be great if you could also suggest -> If I don't want above 4 cases to be processed but only "Bharat Juneja" to get processed.

DavidatK · Posted: Thu Apr 06, 2006 12:42 am

bharat_juneja,

This code is one of several ways your query can be accomplished.