Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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...


  3. OP
    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. OP
    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. OP
    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. OP
    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. OP
    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.
    >>>
    >>>

    >>
    >>

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


Share This Page