Read string untill blank space

[#1]

Greetings!

Simple question:

I have a string such as "THIAGO RIBEIRO", and I want to treat it to outcome like "TRIBEIRO"...

I tried something like LEFT(NAME,1) & RIGHT(NAME,' '), but unsuccesfuly...

Can anyone see where I'm going wrong in the RIGHT func?

Thx again!!!

[Oleg_Troyansky · Accepted solution]

Functions left and right take the specific number of characters that should be included...

For your needs, function SUBFIELD would work better:

Part1 = SUBFIELD(Name, ' ', 1)

Part2 = SUBFIELD(Name, ' ', 2)

For the purpose of extracting first initial and last name, use a combination of the two:

left(Name,1) & SUBFIELD(Name, ' ', 2)

cheers,

[#3]

Oleg,

Owe you another one... Worked perfectly!

Thank you so much!