Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: remove values before second /

Results 1 to 4 of 4
Share This Thread →
  1. #1
    Jaykappy is offline Contributing User
    Join Date
    Feb 2005
    Posts
    1,278
    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
    alansidman's Avatar
    alansidman is offline Contributing User
    Join Date
    Feb 2008
    Location
    Lake County, IL
    Posts
    864
    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.

  3. #3
    Jaykappy is offline Contributing User
    Join Date
    Feb 2005
    Posts
    1,278
    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 10:05 AM.

  4. #4
    Jaykappy is offline Contributing User
    Join Date
    Feb 2005
    Posts
    1,278
    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

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

Similar Threads

  1. Compare Submitted Control values to DataSet values
    By NickG21 in forum .NET Development
    Replies: 0
    Last Post: January 18th, 2012, 02:20 PM
  2. Remove SQL Injection Values From Database Table
    By Misty in forum Microsoft SQL Server
    Replies: 3
    Last Post: November 20th, 2010, 05: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, 01:12 AM
  4. Replies: 1
    Last Post: February 20th, 2005, 07:16 PM
  5. Remove null values from an array
    By Timo in forum .NET Development
    Replies: 3
    Last Post: October 21st, 2004, 10:04 AM

ASP Free Advertisers and Affiliates