Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merging data for a report

Status
Not open for further replies.

bbosader

MIS
Oct 21, 2002
1
US
I have a field that has a first and last name in it.
I need to break these into seperate fields. The problem is there is no space between the names.

Example
jonesandruw

Is there a way to seperate this data because I am using Crystal Report writer and these need to be seperate fields.

Thanks.

Brian
 
I think you are out of luck. there are no distinguishing attributes - each name is just a string of characters. You'll probably have to do it manually.

Who on earth gave you a file designed like that?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top