Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: How Can I Extract Part Of A String

Discussion in 'Information Technology' started by M Wells, Nov 16, 2005.

  1. M Wells

    M Wells
    Expand Collapse
    Guest

    This worked great for me but had to add a comma between " ". Query runs
    fine, but when I drop this field into my header, I am getting a Invalid
    procedure call.

    "Dennis" wrote:

    > Assuming there is always a space in your string, create an update query with
    > the field (I have called it Partcode) as the only column. In the Update To:
    > row put this
    >
    > Left([PartCode],InStr(1,[PartCode]," ",0)-1)
    >
    > "basara" wrote:
    >
    > > I have a field which consists of some thing like "R1113L Fuse part23 dxl" , I
    > > want only the first part, so whatever after the first space, i want to trim
    > > it off. Is there a way to run an update query to do it?
    > >
    > > Thanks...
    > >
    > > --
    > > someone in trouble
     
  2. Loading...

    Similar Threads Forum Date
    Extract From Steppenwolf, And The Reason I Do Not Socialise Blogs Oct 17, 2015
    Extract: The Untold History Of Sikh Rule Under Ranjit Singh Ji In Lahore Sikh Personalities May 28, 2014
    Indian Americans Pioneering Cancer Research From Herbal Extracts Health & Nutrition Jan 25, 2011
    Extracts Of Conversation Interfaith Dialogues Dec 15, 2007
    Sikh Gurus Sikh History Vol 2, Guru Nanak Sahib, Part B History of Sikhism May 15, 2017

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page