#1
  1. No Profile Picture
    Contributing User
    ASP Good Citizen (1000 - 1499 posts)

    Join Date
    Feb 2005
    Posts
    1,280
    Rep Power
    36

    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 /

    Thanks

    For instance I have these values in a field

    453545/somethingthrf/Iwantthis
    wes/fdjjgndfgjnjgnkgjkjngng/andthis

    Result:

    Iwanthis
    andthis
  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Feb 2008
    Location
    Lake County, IL
    Posts
    865
    Rep Power
    152
    In a query, Assume your data is in Field1, then in a new field type this:
    Code:
    Expr1: Right([field1],Len([field1])-InStrRev([field1],"/"))
    Alan Sidman
    Office 2010, 2007, 2002

    If I helped you, then click "give rep" button in the lower left corner.
  4. #3
  5. No Profile Picture
    Contributing User
    ASP Good Citizen (1000 - 1499 posts)

    Join Date
    Feb 2005
    Posts
    1,280
    Rep Power
    36
    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.
  6. #4
  7. No Profile Picture
    Contributing User
    ASP Good Citizen (1000 - 1499 posts)

    Join Date
    Feb 2005
    Posts
    1,280
    Rep Power
    36
    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

Similar Threads

  1. Compare Submitted Control values to DataSet values
    By NickG21 in forum .NET Development
    Replies: 0
    Last Post: January 18th, 2012, 03:20 PM
  2. Remove SQL Injection Values From Database Table
    By Misty in forum Microsoft SQL Server
    Replies: 3
    Last Post: November 20th, 2010, 06:52 AM
  3. How to Remove duplicate values from combo box
    By papegowda_bj in forum Visual Basic Programming
    Replies: 4
    Last Post: November 11th, 2009, 02:12 AM
  4. Replies: 1
    Last Post: February 20th, 2005, 08:16 PM
  5. Remove null values from an array
    By Timo in forum .NET Development
    Replies: 3
    Last Post: October 21st, 2004, 11:04 AM

IMN logo majestic logo threadwatch logo seochat tools logo