Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mdb-parsecsv(1) [debian man page]

MDBTools(1)															       MDBTools(1)

NAME
mdb-parsecsv - Convert CSV table dump into C file. SYNOPSIS
mdb-parsecsv file DESCRIPTION
mdb-parsecsv is a utility program distributed with MDB Tools. mdb-parsecsv takes a CSV file representing a database table, and converts it into a C array. NOTES
If the first argument does not exist as a file, mdb-parsecsv will look for the same filename with '.txt' appended. The file extension is stripped, and the output written to the base name plus a '.c' extension. ENVIRONMENT
MDB_JET3_CHARSET Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1). MDBICONV Defines the output charset to use for the SQL file. Default is UTF-8. mdbtools must have been compiled with iconv. MDBOPTS semi-column separated list of options: o use_index o no_memo o debug_like o debug_write o debug_usage o debug_ole o debug_row o debug_props o debug_all is a shortcut for all debug_* options SEE ALSO
gmdb2(1) mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-schema(1) mdb-tables(1) AUTHORS
The mdb-parsecsv utility was written by Brian Bruns. 0.7 13 July 2013 MDBTools(1)

Check Out this Related Man Page

MDBTools(1)															       MDBTools(1)

NAME
mdb-array - Export data in an MDB database table to a C array. SYNOPSIS
mdb-array database table DESCRIPTION
mdb-array is a utility program distributed with MDB Tools. mdb-array prints a C source code file to stdout, containing an array representing the data of the specified table. ENVIRONMENT
MDB_JET3_CHARSET Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1). MDBICONV Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv. MDBOPTS semi-column separated list of options: o use_index o no_memo o debug_like o debug_write o debug_usage o debug_ole o debug_row o debug_props o debug_all is a shortcut for all debug_* options SEE ALSO
gmdb2(1) mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1) AUTHORS
The mdb-array utility was written by Brian Bruns. 0.7 13 July 2013 MDBTools(1)
Man Page

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Insert Header Name

Can anyone help. I have sql to CSV showing header with ALIAS names but I want to generate CSV file with user friendly name i.e from AIAN8 to Adress Book Number etc. SELECT AIAN8 || , || F0101.ABALPH || , || AICO || showing following below in CSV output intead of above Address... (4 Replies)
Discussion started by: s1a2m3
4 Replies

2. Shell Programming and Scripting

SQL Script's output to a CSV file

I need to call and execute an SQL script within a KSH script and get the output/extracted data into a CSV file. Is there any way to get the out put in a CSV file other than spooling ? I tried spooling. Problem is if there is any wrning/comment/Error they all will be spooled into the csv file. I... (4 Replies)
Discussion started by: Sriranga
4 Replies

3. Shell Programming and Scripting

formatting into CSV format of SQL session output

I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format . The output should be like this 'a','b','c', (4 Replies)
Discussion started by: mady135
4 Replies

4. AIX

No Suitable Driver for MS Access database

Hi, I am running a JDBC:ODBC code to access .mdb file in my windows system successfully but, not able to access MS Access mdb file in AIX Unix box. when I am trying to run the same piece of code in AIX Unix box it is saying "No Suitable Driver". I need some immediate help. (0 Replies)
Discussion started by: thirunp
0 Replies

5. Shell Programming and Scripting

txt file to CSV

hi.. I have a text file which looks likes this 2258 4569 1239 258 473 i need to convert it into comma seperated format eg:2258,4569,1239,258,437 pls help (8 Replies)
Discussion started by: born
8 Replies

6. UNIX for Dummies Questions & Answers

Problem in creating CSV file

Hi guys, I am not experienced with Unix, so please dont mind if the question seem to be irrelevant. I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail. -I stored the query o/p in a file. -I... (6 Replies)
Discussion started by: sumitburnwal88
6 Replies

7. Shell Programming and Scripting

Connect Perl with MS Access (.mdb file)

Hi Guys, How All are Doing In Perl I am getting an issue that I want to share with all you guys. I have a .mdb file(MS Access) that contain many tables. With the help of Perl I want to Connect that mdb file and after Connecting I want to fire a sql query lets say (select * from Table1). ... (3 Replies)
Discussion started by: adisky123
3 Replies

8. Shell Programming and Scripting

File manipulation

I have a CSV file that needs to be loaded to a DB. It appears the copy utility expects fixed number of tokens per line so as to insert data into the corresponding database fileds. My input looks like c1,c2,c3,n1,n2,n3 c1,c2,c3,n1,n2,n3,n4,n5,n6 c1,c2,c3,n1,n2 c1,c2,c3,n1,n2,n3,n4,n5,n6 ... (7 Replies)
Discussion started by: wincrazy
7 Replies

9. Shell Programming and Scripting

How to separate data coming in one column of CSV file?

I am running an ISQL command on Sybase DB and getting output of a query in an CSV file. The issue is that all the data comes in to the same column, i want them to be separated in different columns. SQL_COMMAND=command.sql file=file.txt formatFile=formatFile.txt report=report.csv echo... (1 Reply)
Discussion started by: Sharma331
1 Replies

10. Shell Programming and Scripting

Read CSV file and delete hdfs, hive and hbase tables

I have a CSV file with hdfs directories, hive tables and hbase tables. 1. first column - hdfs directories 2. second column - hive tables 3. third column - hbase tables I have to check the csv file and look for the first column and delete the hdfs directory from the hdfs path, now... (2 Replies)
Discussion started by: shivamayam
2 Replies

Featured Tech Videos