Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Concatenating the initials of names from last, first and middle initials from one field name.

Avatar

Avatar
Validate 1
Level 2
lpianwi
Level 2

Like

1 like

Total Posts

69 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
lpianwi
Level 2

Like

1 like

Total Posts

69 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
lpianwi
Level 2

29-05-2013

Hi All,

Good day. Please I am having problem writing script to cocatenate the first letter of the last name, first letter of the first name, and the middle initial from a name field.

Is there an example I can use.

Thanks

v/r

Tammy

View Entire Topic

Avatar

Avatar
Validate 1
Level 2
lpianwi
Level 2

Like

1 like

Total Posts

69 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
lpianwi
Level 2

Like

1 like

Total Posts

69 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
lpianwi
Level 2

30-05-2013

Vjay,

Good morning, and thank you for the code. It is not working right.

Are you assuming that there are 3 different fields called Lastname, Firstname, and Middlename?

There is only one field called Rater_Name, which should have a last name, first name, and middle name entered into it. This Rater_Name entered should concatenate into an initial field called RaterInitial.

I was thinking that since there are no distinct fields, that a script that will concatenate the first character of any words entered into the Rater_Name field after any space or comma could work, but I do not know how the script will look like.

Thanks

v/r

Tammy