|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
September 15th, 2004, 09:55 AM
|
|||
|
|||
|
How do I extract data from a string?
Hey fellas. I need to extract data from a string, but I'm not sure how to do it. The string may be something like: ~FORMID=RMBALINQ~GRIDQRYONLY=0~PAGEOPT=SHOWNAME=Y; LKFILTER=Y;LKTABLE=NAME;LOOKUPID=RMAR;LOOKUPDEFAUL T=NAME.TYPE IN ('R','A') AND NAME.STATUS IN ('C','N','A');~PROGRAM=MRIRmTran.WebIO~PROGRAMID=L edgerBal~TABLE=MGNT~LASTDATE=1/28/2004 10:20:17 AM~USERID=BPRI
I need to return the date that comes after LASTDATE=. For example, I only want to return the value 1/28/2004 from the string above. Any help will be greatly appreciated! RC
|
|
#2
September 15th, 2004, 12:48 PM
|
||||
|
||||
|
Example
Code:
str = "~FORMID=RMBALINQ~GRIDQRYONLY=0~PAGEOPT=SHOWNAME=Y; LKFILTER=Y;LKTABLE=NAME;LOOKUPID=RMAR;LOOKUPDEFAUL T=NAME.TYPE IN ('R','A') AND NAME.STATUS IN ('C','N','A');~PROGRAM=MRIRmTran.WebIO~PROGRAMID=L edgerBal~TABLE=MGNT~LASTDATE=1/28/2004 10:20:17 AM~USERID=BPRI"
tildeSplit = Split(str, "~")
For i = 0 To UBound(tildeSplit)
equalSplit = Split(tildeSplit(i), "=")
For j = 0 To UBound(equalSplit)
If Trim(CStr(equalSplit(j))) = "LASTDATE" Then
strDateValue = equalSplit(1)
End If
Next
Next
Response.write("<br><br>" & strDateValue)
|
|
| Viewing: ASP Free Forums > Database > SQL Development > How do I extract data from a string? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
