Fist and lastname

[rodybrinkhuis]

Hello,

I have a question:

Klant

Brink, Rob (OMD)

Jansen, Nick (OMD)

I have a table with the above data.

Now i want the folowing data:

First name	Last Name
Rob	Brink
Nick	Jansen

I have tried to use:

Capitalize (subfield(KLANT,',',2)) as [First Name],

Capitalize (subfield(KLANT,',',1)) as [Second Name],

But i don't get rid of the (OMD) in the first name.

Can you help me?

[Maria_Halley]

@rodybrinkhuis

I will move this post to the AppDev board instead, I think you will get more answered there.

[EliGohar]

@rodybrinkhuis 

Please try the following:

Temp:
LOAD * INLINE [
Klant
'Brink, Rob (OMD)'
'Jansen, Nick (OMD)'
];


Table:
Load 
Replace(Capitalize (subfield(Klant,',',2)),'(Omd)','') as [First Name],
Capitalize (subfield(Klant,',',1)) as [Second Name]
resident Temp;

Result:

[rodybrinkhuis · Accepted solution]

Thanks! This was the answer i was looking for.