I have a table that has data i want to parse out part of for a separate column in the query.
THE LINE READS;
[COLOR=red yellow]IPSec ESP Tunnel Inb: Packet authentication failed username: xxxxxx\xxxxxx SPI: ttttttt. Dump of failed hash follows.[/color]
I WROTE;
[blue]IIf(InStr([Detail1],"authentication failed"),Right([Detail1],InStr(1,[Detail1],"Username: ")*1))[/blue]
Results;
[COLOR=red yellow]xxxxxx\xxxxxx SPI: ttttttt. Dump of failed hash follows.[/color]
I ONLY WANT;
[COLOR=red yellow]xxxxxx\xxxxxx[/color]
I TRIED;
[blue]IIf(InStr([Detail1],"authentication failed"),Right([Detail1],InStr(1,[Detail1],"Username: ")*1))-InStr(Right([Detail1],Len([Detail1])-InStr([Detail1],"S"))*1)[/blue]
But it takes an error.
Let me say thank you in advance for your help.
THE LINE READS;
[COLOR=red yellow]IPSec ESP Tunnel Inb: Packet authentication failed username: xxxxxx\xxxxxx SPI: ttttttt. Dump of failed hash follows.[/color]
I WROTE;
[blue]IIf(InStr([Detail1],"authentication failed"),Right([Detail1],InStr(1,[Detail1],"Username: ")*1))[/blue]
Results;
[COLOR=red yellow]xxxxxx\xxxxxx SPI: ttttttt. Dump of failed hash follows.[/color]
I ONLY WANT;
[COLOR=red yellow]xxxxxx\xxxxxx[/color]
I TRIED;
[blue]IIf(InStr([Detail1],"authentication failed"),Right([Detail1],InStr(1,[Detail1],"Username: ")*1))-InStr(Right([Detail1],Len([Detail1])-InStr([Detail1],"S"))*1)[/blue]
But it takes an error.
Let me say thank you in advance for your help.