February 22nd, 2013, 08:59 AM
remove values before second /
Anyone know how to create a query that will delete everthing before a second / including the /
Or keep everything after the second /
For instance I have these values in a field
February 22nd, 2013, 09:40 AM
In a query, Assume your data is in Field1, then in a new field type this:
Office 2010, 2007, 2002
If I helped you, then click "give rep" button in the lower left corner.
February 22nd, 2013, 10:37 AM
That will give me all the characters after teh SECOND '/ ' ???
edit: dont know if you noticed but there are 2 / in the original values
Last edited by Jaykappy; February 22nd, 2013 at 11:05 AM.
February 22nd, 2013, 11:07 AM
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 /