Question

[rodybrinkhuis]

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]

HI @rodybrinkhuis ,

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

[rodybrinkhuis]

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]

Brink and Jansen in one row?

[rodybrinkhuis]

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

[abhijitnalekar]

Hi @rodybrinkhuis ,

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

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

[rodybrinkhuis · Accepted solution]

Thanks. This was the answer i was looking for.

[abhijitnalekar]

Great..

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