question about delimiter in mySQLman

[poolboi]

hi,

i've recently tried mySQLman and it's really great
just a question though about exporting

cos i realise exporting to excel file, there's things like delimitor and escape character i'm not sure what they do

but do they help ya to export data say eg. into excel into each of excels cells? cos when i tried exporting as per default settings, the data were all lump together in one cell and not in neat cells for each field

[debasisdas]

............... ............... cos when i tried exporting as per default settings, the data were all lump together in one cell and not in neat cells for each field

That is the work of delimiters.

Delimiters define the separators from field to field .

[poolboi]

alright
but there's a problem when the delimiter used is "|", cos my data when exported to excel are all in one cell
the fields are not group in seperate cells, even when i use "\t" which is tab delimited, it doesn't work too
so what else can i do?