Splitting and Manipulating a String

[GalmOne]

Hello,

I need to split a username string into a specific format. For example if the name is "john.doe", I then have to display "J. Doe" in TextBox136. Note, the period and the space following the first initial as well as the capitalized initials.

I have a working function which finds the username of the person logged in called UserName. All account names that I'm dealing with are in the format "firstname.lastname" and the variable "UserName" is assigned the value of the account name. In the example above, my UserName variable will automatically be assigned the value of "john.doe".



Please help, and Thanks!

[Kyle123]

This works for me:

Please Login or Register  to view this content.

[GalmOne]

Thanks, but that doesn't work for me. I used your function and then in the initialize event I put: TextBox136.Value = (GetUser) and I get a "Run-time erroe 9, Subscript out of range" warning.

[Kyle123]

Are you sure there's a full stop in that users windows logon. Or are you using your own username system?

[patel45]

if I understand well

Please Login or Register  to view this content.

[GalmOne]

Sorry Kyle, are you asking if there's a period in each username? I'm not sure what a fullstop is. And, no, I'm not using my own system. All login account names at work are in the format "firstname.lastname".

[Kyle123]

@patel45, some variable declaration would be nice, also it's generally not a good idea to use variable names that are key/reserved words in VBA

[GalmOne]

@patel, thanks for the code, but that doesn't seem to work either.

I tried "TextBox136.Value = UserFinal" in both the initialize event and then after the code you gave me and the textbox remained empty.

[Kyle123]

Yes, over this side of the pond a period is called a full stop

You'd only get an error like that if there wasn't a full stop in the username - how are you getting the username?

The fact that Environ("username") returns something that doesn't have a full stop suggests that you're getting the username from somewhere else.

What is the result of just calling the function Environ("username") alone?

[GalmOne]

I put
"usr = Environ("UserName")
MsgBox (usr)"
in my initialize event for my UserForm.

I then called the function "usr" via msgbox. It returned me a blank value.

[Kyle123]

That's quite strange. Can you post your code for getting the username?

I'm confused by your terminology also, usr isn't a function?

[GalmOne]

Please Login or Register  to view this content.

---------- Post added at 10:38 AM ---------- Previous post was at 10:31 AM ----------

Got it to work. Turns out since UserName lready used the "Environ" function, I removed "Environ" from the "getUser" function you made and it works perfectly. Thanks, Kyle!