topic Re: Question in Management & Governance

Question

rodybrinkhuis — Thu, 21 Oct 2021 07:10:09 GMT

Hello,

I have a question about the following:

I want to get the information to see Brink and Jansen as First Name:

I tried this:

subfield(KLANT,' ',1) , purgechar(KLANT, ', ') as [First Name],

What is the solution?

Thanks!

abhijitnalekar — Thu, 21 Oct 2021 07:22:53 GMT

Have you tried substring like subfield('Brick,abd Mr', ',') as FirstName

rodybrinkhuis — Thu, 21 Oct 2021 10:37:54 GMT

Abhijitnalekar thanks for your reactor. But i think that was not the solution i was hoping. I was hoping that i got the result Brink and Jansen.

abhijitnalekar — Thu, 21 Oct 2021 10:41:14 GMT

Brink and Jansen in one row?

rodybrinkhuis — Thu, 21 Oct 2021 10:45:43 GMT

Yes that was the thing i was hoping for. For example the table below.

abhijitnalekar — Thu, 21 Oct 2021 10:57:16 GMT

Can you please share the sample data? reason being asking for data as

subfield(A, ',') as FirstName this supposed to be worked.

rodybrinkhuis — Thu, 21 Oct 2021 12:26:48 GMT

Thanks. This was the answer i was looking for.

abhijitnalekar — Thu, 21 Oct 2021 12:29:47 GMT

Great..

Happy to help you. Please mask reply as a solution if that works for you.