IF Statement and Subfield function

[#1]

Hi everyone, I have an issue and i m trying to solve it. Here we go:

I have a field called CUSTOMERS, which can be a person or a company.

If it is a person the name is in the format: First Name Last Name Middle Name (eg JOHN TAYLOR ANDREW)

If it is a company it just shows the name of the company (eg XEROX SA)

The way to distinguish them is by another field called STATUS. So if it is a person then Status is Person. If it is a company it could be either Ltd, SA etc.

What I want to do is to keep the name of the customer as is if it is a company, and create two fields LAST NAME and FIRST NAME(or 3 if i want to keep middle name as well).

Any ideas???   Thanks much

[danieloberbilli]

Maybe something like this. Please find qvw attached:

[danieloberbilli]

But it needs some finetuning in case there is more than 1 middle name. In this case you could use the mid() und subfieldfunctions to identify the start position of the middle words.

[#4]

Thanks for the answer. The table on top is exactly what i am looking for.

However, I don't want to use INLINE. I have extracted all the customers in an Excel file

and I m using this. There are about 3K customers.

Any suggestions?

[danieloberbilli · Accepted solution]

instead of the inline load you can just use your load from...

like

Load *,

...

;

Load

STATUS,

CUSTOMERS,

...

from xyz.xls

[#6]

Thanks man. Very helpful!!!

[#7]

hi

I was looking for same solution. i got it from your answer. Just in Time!!!!!!!

thanks