Retrieving everything before Space in field 2

[timtom]

Hi. I've got a field with people's full name inside. I want the first name only to do something with.

How do I get "Adam" from "Adam Smith" and "Liz" from "Liz Taylor"?

Thanks for any help you may be able to give
Sarah

_{WASN'T FIT ENOUGH FOR THE POLICE FORCE}​

 

[link9]

dim theName, nameArray, firstName
theName = "Adam Smith"
nameArray = split(theName," &quot
firstName = ubound(nameArray)

response.write("My first name is " & firstName)

 

[timtom]

firstname should actually be ubound(namearray(0)) but that was easy enough to work out.

Thanks link, much appreciated

_{WASN'T FIT ENOUGH FOR THE POLICE FORCE}​

 

[link9]

actually, it should be

nameArray(lbound(nameArray))

sorry bout that. fast fingers.


paul

 

[Ovatvvon]

odd, either of the ubound or lbounds only return the number of position in the array the information lays at...for instance:
firstName = lbound(nameArray)
returns a 0 (zero) for me. If I use timtom's approach, the ubound and lbound features won't work at all because you're already specifying the placeholder, so what works for me is:
firstName = nameArray(0)
lastName = nameArray(1)

Perhaps it's just my server or else I missed somthing? -Ovatvvon :-Q

 

[Ovatvvon]

ok, after I submitted this now I see Paul's other message, tried that and that does work as well. -Ovatvvon :-Q

 

[link9]

right, it was totally my bad. What I was trying to do was what I posted last, thereby specifying I wanted the lowest position of the array like:

nameArray(lbound(nameArray))

in other words:

nameArray(0)

Likewise, if you ask for:

nameArray(ubound(nameArray))

it would give you the last name. In other words:

nameArray(1)

lbound() returns the lower boundary of an array
ubound() returns the upper boundary of an array


paul

 

[link9]

Some serious message criss-crossing going on here. I missed your very last post, as well.

LOL