Setting the delimiter that Sybase query returns

airdoc has asked for the wisdom of the Perl Monks concerning the following question:

Is there any way to set the delimiter that a select statement query for Sybase returns?

If I do a select (*), each column is delimeted by a space,
however some of the data fields have spaces in them
and I need to be able to split data output by something other than a space.

Thanks
airdoc

Comment on Setting the delimiter that Sybase query returns

Replies are listed 'Best First'.
Re: Setting the delimiter that Sybase query returns by jfroebe (Parson) on May 22, 2007 at 16:57 UTC
`my $query = "select * from my_table"; my $sth = $dbh->prepare($query); $sth->execute or die "Error: unable to run query! " . $dbh->errstr; while (my $cols_ref = $sth->fetchrow_arrayref ) { print "@$cols_ref\n"; print "$_ : " foreach @$cols_ref; print "\n"; }` [download] Jason L. Froebe Help find a cure for breast cancer! Net proceeds benefit the Susan G. Komen Breast Cancer Foundation and the National Philanthropic Trust. Help by donating - I'm walking 60 miles in 3 days in August 2007. (The day I return from TechWave is the first day of the Walk). Blog, Tech Blog	[reply] [d/l]
Re: Setting the delimiter that Sybase query returns by thezip (Vicar) on May 22, 2007 at 16:49 UTC
It's quite difficult to help with your problem when you don't provide any code or (at least) context. Perhaps you could show us the relevant bits of what you're actually doing, and then maybe we'll be able to give you an appropriate solution. Where do you want them* to go today?*	[reply]