need a field scanned, separated in .xls format

[thisisboni]

Hi,

I posted this in another forum to get a partial reply
I have a column the dB as 'member_list' its a char field and contains a list of names separated by ';' - (eg. peterser;dickensm;patadem
this format is constant but the # of names can change !
I was trying to come up with a formula which splits this field and returns each individual in a diff. line - say for the above it will return:
peterser
dickensm
patadem

on a sugessiton I tried replace({table.field},";",chr(13)) which workd well on the crystal end BUT I need this imported to excel and this is where it gets messed up

in the db: there are 2 fields

member_list, group_role

the member_list field needs scanned and separated into each line and for each I need to repeat the 'group_role' beside -and the output format needed is xls.

thanks
Sam

p.s: I am on Crystal X with an Oracle 9i backend

 

[Madawc]

Try Split, which will divide the data at the ";". You can then refer to them as [1], [2] etc. Do a SEARCH for Split in

http://www.tek-tips.com/threadminder.cfm?pid=767

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10