remove values before second /

[Jaykappy]

Anyone know how to create a query that will delete everthing before a second / including the /
Or keep everything after the second /

Thanks

For instance I have these values in a field

453545/somethingthrf/Iwantthis
wes/fdjjgndfgjnjgnkgjkjngng/andthis

Result:

Iwanthis
andthis

[alansidman]

In a query, Assume your data is in Field1, then in a new field type this:

Expr1: Right([field1],Len([field1])-InStrRev([field1],"/"))

[Jaykappy]

That will give me all the characters after teh SECOND '/ ' ???

edit: dont know if you noticed but there are 2 / in the original values

[Jaykappy]

Gotcha...that worked great...THANKS

I was thinking finding the second / and then grabbing after...seems your is doign it the other way....grabbing everything to the right of the /

THANKS again....apprecaited