473,387 Members | 3,033 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Separate two words

Hi: I have data where first and last name are in one field. I need help
how to i separate first and last name in ASP

Thanks,

Aug 9 '06 #1
3 2068
"Eric" <eh******@gmail.comwrote in news:1155161189.375181.215950
@i42g2000cwa.googlegroups.com:
Hi: I have data where first and last name are in one field. I need help
how to i separate first and last name in ASP
Use the split function, assuming you have a delimiter of some description
between the names, even if it is only a space.

Aug 9 '06 #2
"Eric" <eh******@gmail.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...
Hi: I have data where first and last name are in one field. I need help
how to i separate first and last name in ASP
Unless every both the first and last names are one word it's complex.

For example,
John Doe
John Q. Public
Dr. John Smallbooty
John Bigbooty, Jr.
John Von Booty

How many names are you looking at?
Aug 9 '06 #3
Eric wrote:
Hi: I have data where first and last name are in one field.
I need help how to i separate first and last name in ASP
How do you plan to deal with multiple spaces, as in these examples?

Townes Van Zandt
Stevie Ray Vaughan
George Herbert Walker Bush

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.
Aug 9 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Nathan Lamont | last post by:
I would like to make use of two separate PHP applications which happen to share some class names; trying to include both from one script results in the expected error, "cannot redefine class foo."...
5
by: anonymous | last post by:
with X Y separate dual-bus super sub , maybe reverse by freq Y is super-bus X or Y maybe set to internal base ( default ) X@ X! Y@ Y! ( top of stack X@ y@ --> TOS ) >X >X >Y Y> intelligent...
2
by: Joe | last post by:
hi, i have a search form that will only search the whole string when searching a query. i would like to have the search string split into separate words so that each word could be used as part...
4
by: marcelf3 | last post by:
Hello, I am a novice/moderate html programmer and I wonder how to tell the browser from which start point and to which end point in the text will each page be printed. In other words, I have a...
3
by: Virgo | last post by:
The code below cout's separate words from file "text.txt". int main() { vector<string> words; ifstream in("text.txt"); string word; while(in >> word) words.push_back(word); for(int i = 0; i...
0
by: marcelf3 | last post by:
Hello, I am a novice/moderate html programmer and I wonder how to tell the browser from which start point and to which end point in the text will each page be printed. In other words, I have a...
8
by: nickdu | last post by:
I'm trying to isolate "applications" into their own application domain within a single process. I've quoted applications because it's a logical representation of an application. Basically it...
6
by: Yanhao Zhu | last post by:
Hi, all, If I have an array like int m = new int { 0, 1, 2, 3 }, is there a way I can separate the array into two, like int m01 = somefunction?(m,0,2) // m01 will hold 1st and 2nd items in...
7
by: xephia | last post by:
Hey all, I am resorting to posting this question after getting absolutely nowhere in four days of searching (except for maybe negative steps, got mad at my laptop and broke my delete key :( ) ...
2
by: colleen1980 | last post by:
Hi: Can any one please tell me how do i separate city state and zip. I ask this question in previous post. But when the city name is in two words it mess up my values otherwise it works. ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.