topic Re: Fist and lastname in App Development

Fist and lastname

rodybrinkhuis — Tue, 02 Nov 2021 09:56:02 GMT

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?

Re: Fist and lastname

Maria_Halley — Tue, 02 Nov 2021 09:58:52 GMT

@rodybrinkhuis

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

Re: Fist and lastname

EliGohar — Tue, 02 Nov 2021 12:36:43 GMT

@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:

Re: Fist and lastname

rodybrinkhuis — Thu, 04 Nov 2021 07:32:19 GMT

Thanks! This was the answer i was looking for.