5 Replies Latest reply on May 7, 2017 12:01 PM by siplus

# how to get initials from Fullname field?

I am facing the following problem:

i have a field "Fullname" where i insert full name of my clients, they almost have 2 names. i need the initials of those names.

i can get the first initial, but i can't get the secound name.

i did use the "left(fiedlname; 1)".

any help will be welcome.

• ###### 1. Re: how to get initials from Fullname field?

Let ([

myList = Substitute(FullName; " "; ¶) ];

initials =

Left(GetValue(myList; 1); 1) &

Left(GetValue(myList; 2); 1) &

Left(GetValue(myList; 3); 1) &

Left(GetValue(myList; 4); 1)

)

/* and go on if you have Barnaby Marmaduke Aloysius Benjy Cobweb Dartagnan Egbert Felix Gaspar Humbert Ignatius Jayden Kasper Leroy Maximilian Neddy Obiajulu Pepin Quilliam Rosencrantz Sexton Teddy Upwood Vivatma Wayland Xylon Yardley Zachary Usansky as your client */

)

1 of 1 people found this helpful
• ###### 2. Re: how to get initials from Fullname field?

Let ([

myList = Substitute(FullNameField; " "; ¶) ];

Iniciais =

Left(GetValue(myList; 1); 1) &

Left(GetValue(myList; 2); 1) &

Left(GetValue(myList; 3); 1) &

Left(GetValue(myList; 4); 1)

)

//

i got 0 "zero"

1 of 1 people found this helpful
• ###### 3. Re: how to get initials from Fullname field?

The function needed a little tweaking to work.

-Tom

Let ([

myList = Substitute(FullName; " "; ¶) ];

Left(GetValue(myList; 1); 1) &

Left(GetValue(myList; 2); 1) &

Left(GetValue(myList; 3); 1) &

Left(GetValue(myList; 4); 1)

)

1 of 1 people found this helpful
• ###### 4. Re: how to get initials from Fullname field?

i should get it done on the first try,

i forgot the Calculation Result Set was "number" it would be "Text".

Now working