Can't get substring to work properly

[bsabourin1962]

I have one field called 'Name', you are supposed to put full name and list it like this, 'Last, First, MI' in this one field separated by a comma, for each name, ex., 'Doe, John A.'. I need to be able to extract the first initial from the last name, the first initial from the first name, and the middle initial. So that the result would be listed in my 2nd field, called, 'Initial', and it would appear like this, 'JDA'. I have tried to make this work for hours to no avail. If possible, can you attach a sample form that can do this task? Thanks, the form could also be sent to my email: bsabourin@yahoo.com. Any and all help is appreciated. Thanks!

[Vjay_Reddy]

Hi,

Below document would help you..

https://workspaces.acrobat.com/?d=0q-5QHxYsYn54ztSrdiijA

Thanks

Vjay

[bsabourin1962]

Classification: UNCLASSIFIED

Caveats: NONE

Good Afternoon,

Thanks for sending the file. I finally was able to look at the code. I tried the attached file, and I noticed that your sample only gave me the first initial. Apparently, the loop was only able to go through and get the first name, and was not able to get the 2nd name, and middle initial.

Thanks,

Brian