Merging data for a report

[bbosader]

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

 

[mikey69]

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?