Welcome to SPN

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

Sign Up Now!

Need to Slite item in cell '(s)

Discussion in 'Information Technology' started by Mr Johnson, Jul 28, 2006.

Tags:
  1. Mr Johnson

    Mr Johnson
    Expand Collapse
    Guest

    Hello,

    I have data that I import. With in the cells I have
    Example

    First Name: Jeff
    First Name: Sandra
    First Name: Jerimaih

    What I want to do is split "First Name" from the "Name", there are colons
    for each example tag.
    --
    Johnson II Johnson ESG Inc.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News WWI Sikh Heroes Need To Be Remembered: Dr Atamjit Breaking News Sep 11, 2016
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016
    Sikh News Sikh Seva Volunteers Keep The Food Service Drive For The Needy Going After Passing Away Of Breaking News Jul 29, 2016
    Need some info regarding bibek wrt eating Sikh Rehat Maryada Jan 14, 2016
    Spiritual Why We Only Need To Pray For Naam Blogs Dec 20, 2015

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    You say "cells". Are you using Access or Excel? Access does not have
    cells.

    Splitting the literal "First Name:" into a separate field from the actual
    name and doing the same with last name will not result in a normalized
    database design.

    What exactly are you trying to accomplish? What end results do you want
    from this database?

    --
    Rick B



    "Mr Johnson" <lordjeffj@yahoo.com> wrote in message
    news:80A9DFBF-BF3B-4360-AD40-50FA10054FCB@microsoft.com...
    > Hello,
    >
    > I have data that I import. With in the cells I have
    > Example
    >
    > First Name: Jeff
    > First Name: Sandra
    > First Name: Jerimaih
    >
    > What I want to do is split "First Name" from the "Name", there are colons
    > for each example tag.
    > --
    > Johnson II Johnson ESG Inc.
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    If it's always "First Name: ", that's 12 characters, so you can use

    Mid(MyFIeld, 13)

    If it's not always the same text (so that the colon isn't always in position
    11), but there always is a colon, you can use

    Mid(MyField, InStr(MyField, ":") + 2)


    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Mr Johnson" <lordjeffj@yahoo.com> wrote in message
    news:80A9DFBF-BF3B-4360-AD40-50FA10054FCB@microsoft.com...
    > Hello,
    >
    > I have data that I import. With in the cells I have
    > Example
    >
    > First Name: Jeff
    > First Name: Sandra
    > First Name: Jerimaih
    >
    > What I want to do is split "First Name" from the "Name", there are colons
    > for each example tag.
    > --
    > Johnson II Johnson ESG Inc.
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    to strip spaces also (oracle thingy)
    Trim(Mid(MyField, InStr(MyField, ":") + 2))

    Pieter

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:%23ZS09D2eGHA.3484@TK2MSFTNGP04.phx.gbl...
    > If it's always "First Name: ", that's 12 characters, so you can use
    >
    > Mid(MyFIeld, 13)
    >
    > If it's not always the same text (so that the colon isn't always in
    > position
    > 11), but there always is a colon, you can use
    >
    > Mid(MyField, InStr(MyField, ":") + 2)
    >
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Mr Johnson" <lordjeffj@yahoo.com> wrote in message
    > news:80A9DFBF-BF3B-4360-AD40-50FA10054FCB@microsoft.com...
    >> Hello,
    >>
    >> I have data that I import. With in the cells I have
    >> Example
    >>
    >> First Name: Jeff
    >> First Name: Sandra
    >> First Name: Jerimaih
    >>
    >> What I want to do is split "First Name" from the "Name", there are colons
    >> for each example tag.
    >> --
    >> Johnson II Johnson ESG Inc.

    >
    >
     
  6. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Funny you should mention that. I spent part of today helping a co-worker who
    got bit by the fact that he was getting fixed length fields back from SQL
    Server.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Pieter Wijnen" <wijnen.nospam.please@online.no> wrote in message
    news:eQGIb$2eGHA.3468@TK2MSFTNGP03.phx.gbl...
    > to strip spaces also (oracle thingy)
    > Trim(Mid(MyField, InStr(MyField, ":") + 2))
    >
    > Pieter
    >
    > "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    > news:%23ZS09D2eGHA.3484@TK2MSFTNGP04.phx.gbl...
    >> If it's always "First Name: ", that's 12 characters, so you can use
    >>
    >> Mid(MyFIeld, 13)
    >>
    >> If it's not always the same text (so that the colon isn't always in
    >> position
    >> 11), but there always is a colon, you can use
    >>
    >> Mid(MyField, InStr(MyField, ":") + 2)
    >>
    >>
    >> --
    >> Doug Steele, Microsoft Access MVP
    >> http://I.Am/DougSteele
    >> (no e-mails, please!)
    >>
    >>
    >> "Mr Johnson" <lordjeffj@yahoo.com> wrote in message
    >> news:80A9DFBF-BF3B-4360-AD40-50FA10054FCB@microsoft.com...
    >>> Hello,
    >>>
    >>> I have data that I import. With in the cells I have
    >>> Example
    >>>
    >>> First Name: Jeff
    >>> First Name: Sandra
    >>> First Name: Jerimaih
    >>>
    >>> What I want to do is split "First Name" from the "Name", there are
    >>> colons
    >>> for each example tag.
    >>> --
    >>> Johnson II Johnson ESG Inc.

    >>
    >>

    >
    >
     
  7. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Been there done that etc... (a lot of char fields around)

    Pieter

    "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:OSa9%23U5eGHA.4976@TK2MSFTNGP02.phx.gbl...
    > Funny you should mention that. I spent part of today helping a co-worker
    > who got bit by the fact that he was getting fixed length fields back from
    > SQL Server.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "Pieter Wijnen" <wijnen.nospam.please@online.no> wrote in message
    > news:eQGIb$2eGHA.3468@TK2MSFTNGP03.phx.gbl...
    >> to strip spaces also (oracle thingy)
    >> Trim(Mid(MyField, InStr(MyField, ":") + 2))
    >>
    >> Pieter
    >>
    >> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    >> news:%23ZS09D2eGHA.3484@TK2MSFTNGP04.phx.gbl...
    >>> If it's always "First Name: ", that's 12 characters, so you can use
    >>>
    >>> Mid(MyFIeld, 13)
    >>>
    >>> If it's not always the same text (so that the colon isn't always in
    >>> position
    >>> 11), but there always is a colon, you can use
    >>>
    >>> Mid(MyField, InStr(MyField, ":") + 2)
    >>>
    >>>
    >>> --
    >>> Doug Steele, Microsoft Access MVP
    >>> http://I.Am/DougSteele
    >>> (no e-mails, please!)
    >>>
    >>>
    >>> "Mr Johnson" <lordjeffj@yahoo.com> wrote in message
    >>> news:80A9DFBF-BF3B-4360-AD40-50FA10054FCB@microsoft.com...
    >>>> Hello,
    >>>>
    >>>> I have data that I import. With in the cells I have
    >>>> Example
    >>>>
    >>>> First Name: Jeff
    >>>> First Name: Sandra
    >>>> First Name: Jerimaih
    >>>>
    >>>> What I want to do is split "First Name" from the "Name", there are
    >>>> colons
    >>>> for each example tag.
    >>>> --
    >>>> Johnson II Johnson ESG Inc.
    >>>
    >>>

    >>
    >>

    >
    >
     

Share This Page