Snitz Forums 2000 - Splitting topic subject

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP (Non-Forum Related)

Splitting topic subject

New Topic

Topic Locked

Printer Friendly

Author

Topic

StephenD
Senior Member

Australia
1044 Posts

Posted - 07 April 2007 : 04:20:14

My T_SUBJECT values are stored as 'Bloggs, Joe 6161/2007'

I'm trying to extract the surname and firstnames sperately and am running into trouble.



if inStr(Topic_Subject,",") <> 0 then
   array1 = split(Topic_Subject,",")
newArray = ""

For a = 0 to Ubound(array1)
	array2 = Split(array1(a)," ,")
Next

AnonJr
Moderator

United States
5768 Posts

Posted - 07 April 2007 : 09:33:33

If the values are consistently stored as "LName, FName mm/dd/yyyy" then you may just find it easier to split on the space and trim the comma from the last name. This is assuming that you are following the indicated format (spacing and all), here's a rough first run:

array1 = Split(Topic_Subject," ")
LName = Trim(Replace(array1(0),",",""))
FName = Trim(array1(1))
Date = cDate(array1(2))

Or something along those lines depending on what you needed. Or maybe I just need another cup of coffee....

StephenD
Senior Member

Australia
1044 Posts

Posted - 08 April 2007 : 20:34:39

Thanks for that AnonJr, worked perfect.

AnonJr
Moderator

United States
5768 Posts

Posted - 09 April 2007 : 12:24:29

Glad to help.

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.18 seconds.