473,480 Members | 1,531 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

question about delimiter in mySQLman

170 New Member
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
Apr 8 '08 #1
2 1333
debasisdas
8,127 Recognized Expert Expert
..............................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 .
Apr 8 '08 #2
poolboi
170 New Member
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?
Apr 8 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
3790
by: Rick | last post by:
Hi, I'm having a little problem with the string tokenizer. For example, I got this data string : "0#0#0#0####0#0#0#.. and so on....." How obvious, the # char will be the delimiter. But as you...
17
1917
by: Anthony Roberts | last post by:
If I end indentation levels with "pass" statements, will I piss off people that have to read my code? eg: for i in xrange(0,5): if i: print i pass print i * -1 pass
3
4246
by: Bernard Delmée | last post by:
Hello, I can't seem to be able to specify the delimiter when building a DictReader() I can do: inf = file('data.csv') rd = csv.reader( inf, delimiter=';' ) for row in rd: # ...
13
1111
by: Kitty | last post by:
Hi, I have a question about vector. Suppose that I have "vector<Object>" container, where Object is some class. I would like to output this vector<Object> into a file to save. Then, in the next...
4
11466
by: Raquel | last post by:
Could someone explain to me what the reason is for having a character delimiter (which is double quotes by default) for performing Loads/Imports on UDB? I would think that column delimiter along...
7
19749
by: Suma | last post by:
I have background in SQL server and none in DB2 hence the question. SQL Server has a bcp command - I am looking for an equivalent utility in db2 I have a table called Employee(empid int ,fname...
4
2025
by: alacrite | last post by:
I have a class that I want to turn its contents into csv file. I want to be able to set the value of the delimiter, the name of the file it gets saved to, the path of that file, and maybe a few...
8
309
by: Stu Cazzo | last post by:
Hi all, I have a question on why strtok is doing what it's doing for my splitString( string2 ); call. Below is the output for the entire program: token was: word1 token was: word2 token...
4
3400
by: kretik | last post by:
I've been trying to coax this class to use something other than the default '$' but it seems setting it to something else has no discernible effect. Is it necessary to inherit from the class to do...
0
7044
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6908
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7045
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7087
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6741
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5341
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
2995
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1300
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
563
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.