If I have a string "Vulnerability1" which currently reads "Absence of Personnel, Improper Disposal of Media - i.e. disposal of media which hasnt been wiped clean, Inadequate Recruitment Procedures" and I want to strip the "Absence of Personnel, " off it and leave variable "Vulnerability2" to read "Improper Disposal of Media - i.e. disposal of media which hasnt been wiped clean, Inadequate Recruitment Procedures" how would you do it?


My best attempt:

vulnerability2 = right(vulnerability1,instr(vulnerability1,"Absence of Personnel, "))

 

vulnerability2 = "Improper Disposal of Media - i.e. disposal of media which hasnt been wiped clean, Inadequate Recruitment Procedures"

 

Sorry, the variable changes - God! I thought this was a mature forum

 

LOL @ Chris

How about this...

vunerability2: Right([vunerability1],Len([vunerability1])-InStr([vunerability1],",")-1)

 

This gives error:

Error Type:
Microsoft VBScript compilation (0x800A0414)
Cannot use parentheses when calling a Sub
/new_cit/risk/exploits/exploits1.asp, line 51, column 87

 

Try it without the square brackets (needed 'em in the Access query from whence it came)

Mark

 

I removed the square brackets, and replaced the : for a = and it errors:

Error Type:
Microsoft VBScript runtime (0x800A0005)
Invalid procedure call or argument: 'Right'
/new_cit/risk/exploits/exploits1.asp, line 51

 

How about right$ instead of right?

Mark