Remove Space / Build Name 1

[Webflex]

Hi

I'm trying to build an output starting with AUTH_USER that consists of First Initial and Surname without any space, for example 'Alexander Smith' becomes 'ASmith' not 'A Smith'

As implemented below I get 'A Smith' and have problems with the length of the surname.

strNTUserShortName=Left(strNTUserFullName,1)+Right(strNTUserFullName,10)

Basically I want everything to the right of the space and the first initial to the left, can you think of a way to do this before I abandon this idea.

TIA
Webflex

 

[simonchristieis]

try using the split method

myarray = Split(strNTUserFullName)

strNTUserShortName=Left(strNTUserFullName,1) & myarray(1)

Hope this helps

Simon

 

[Webflex]

perfect, thanks, works a treat