Need to Slite item in cell '(s)

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.
--
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9976-need-to-slite-item-cell-s.html
Johnson II Johnson ESG Inc.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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" wrote in message
news:80A9DFBF-BF3B-4360-AD40-50FA10054FCB@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976
> 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.

If it's always "First Name: ", that's 12 characters, so you can use
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976

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" 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
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976
> 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.

to strip spaces also (oracle thingy)
Trim(Mid(MyField, InStr(MyField, ":") + 2))
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976

Pieter

"Douglas J Steele" 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" 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.
>
>


Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976

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" wrote in message
news:eQGIb$2eGHA.3468@TK2MSFTNGP03.phx.gbl...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976
> to strip spaces also (oracle thingy)
> Trim(Mid(MyField, InStr(MyField, ":") + 2))
>
> Pieter
>
> "Douglas J Steele" 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" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976
>>>
>>> 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.
>>
>>
>
>

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

Pieter

"Douglas J. Steele" 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" wrote in message
> news:eQGIb$2eGHA.3468@TK2MSFTNGP03.phx.gbl...
>> to strip spaces also (oracle thingy)
>> Trim(Mid(MyField, InStr(MyField, ":") + 2))
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976
>>
>> Pieter
>>
>> "Douglas J Steele" 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" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9976
>>>> colons
>>>> for each example tag.
>>>> --
>>>> Johnson II Johnson ESG Inc.
>>>
>>>
>>
>>
>
>