rik1471

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, "))

ChrisB

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

rik1471

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

markr1963

LOL @ Chris

How about this...

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

rik1471

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

markr1963

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

Mark

rik1471

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

markr1963

How about right$ instead of right?

Mark