Splitting "Name" field to FirstName,MiddleName,Las

[saroshputhanpurayil]

Hi,

I have job with on of field is "Name"
its content can be as follows

Amjath Ali Khan 3 parts
Sarosh Puthanpurayil 2parts
James 1part
Bijo K James 2 parts

I want to map this "Name" field to ---->FirstName,MiddleName,LastName in the target file.

can any one help me to solve this problem.

thanking you.

[saroshputhanpurayil]

sorry ,some corrections


Amjath Ali Khan ----------------> 3 parts
Sarosh Puthanpurayil -----------------> 2parts
James ------------------> 1part
Bijo K James ----------------> 3parts

[ArndW]

Parsing the string into components is simple, you can use the FIELD() function. The complexity comes in trying to figure out which part of the string goes where. If you have it, you can use the QualityStage components, if you don't you need to come up with your own rules as to determining which part of the string is which name part.

[chulett]

Exactly - you need to determine what each part must be when you don't have 'all three parts', and then enforce those rules.

[ray.wurlod]

Is "James" a first name or a last name? How do you know (that is, what is your business rule)?