Need to Slite item in cell '(s)

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

 

[Douglas J Steele]

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)

 

[Rick B]

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?

 

[Pieter Wijnen]

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

Pieter

 

[Douglas J. Steele]

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.

 

[Pieter Wijnen]

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

Pieter

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.