Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Hi Fellows,
I have been struggling to fix an issue in csv records to compose sql statements and have been really losing sleep over it. Here is the problem:
I have csv files in the following pipe-delimited format:
Column1|Column2|Column3|Column4|NEWLINE
Address Type|some descriptive... (4 Replies)
Hi
I have two csv files, with the following formats:
FileA.log:
Application, This occured blah
Application, That occured blah
Application, Also this
AnotherLog, Bob did this
AnotherLog, Dave did that
FileB.log:
Uk, London, Application, datetime, LaterDateTime, Today it had'nt... (8 Replies)
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
I have been looking everywhere for a solution and it seems as though awk may do the trick. I am very much a newbie in the awk scripting world but it seems to appear one of the best text parsing tools from what I've read on this forum.
Scenario:
I have about 50 cisco config files randomly... (7 Replies)
Hi all,
Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table.
Please see the attached html and PNG of what it looks like.
... (7 Replies)
Greetings,
After a few hours of trial and error, I decide to ask for some help.
I am new to AWK and shell script, so please don't laugh :p
I made the below script, to gather data from some logs and have the output into a CSV file :
#!/bin/sh
#Script to collect Errors
... (9 Replies)
Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any better idea?
export FILE="/abc/autom/file/geo_JOB.csv"
Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
Discussion started by: Hope
16 Replies
LEARN ABOUT DEBIAN
cldump
cldump(1) User Manuals cldump(1)NAME
cldump - Clarion database extractor
SYNOPSIS
cldump [options] database.dat
DESCRIPTION
cldump extracts the data contained in a Clarion database; Clarion is a Windows IDE similar to Delphi or others, and has its own (simple)
database format.
cldump can extract the data contained in such a database, and export it to CSV, SQL (including the database schema, keys and indexes) or
its own format (this format will give you all the meta information, but isn't easily parsable).
A Clarion database consists in a set of files :
.DAT files contain the data,
.Kxx files contain the key/index data,
.MEM files contain the memo entries associated to the data.
OPTIONS -x n, --decrypt n
Decrypt an encrypted file. Required argument n indicates the location where the key will be retrieved. Valid values are in the range
1 - 4 inclusive. n = 1 usually works.
Decryption happens in-place so KEEP A BACKUP as there is no guarantee the decryption process won't fail. Encrypted files must be
decrypted before they can be dumped.
Note that only the data file and the memo file are decrypted in this process; key/index files are left untouched as cldump doesn't
use them.
-d, --dump-active
Dump active entries only
-D, --dump-data
Dump the actual data (active and deleted entries)
-m, --dump-meta
Dump meta information (no SQL or CSV output format exist for this option)
-f c, --field-separator c
Set the field separator to character c. Only valid for CSV output (see below).
-c, --csv
Dump data or schema in CSV format
-S, --sql
Dump data or schema in SQL format
-s, --schema
Dump database schema
-M, --mysql
Use MySQL specific construct (backticks, ...)
-n, --no-memo
Do not dump memo entries
-U[charset], --utf8[=charset]
Transcode strings and memos from charset to UTF-8 (charset defaults to ISO8859-1; for the list of supported charsets, see iconv
--list)
OUTPUT
cldump outputs the data to stdout or stderr depending on the output format selected, the data to extract and the type of the data (data,
meta data).
BUGS
The SQL output could be improved. Not all the types supported by the Clarion database format are implemented yet (due to lack of test data-
bases using these types of data); see the source code for details.
Please report bugs to jb@jblache.org; if possible, please send patches as the set of test databases I have is very limited.
AUTHOR
cldump was written by Julien BLACHE <jb@jblache.org>.
HOMEPAGE
http://www.technologeek.org/projects/cldump/
Linux November 2010 cldump(1)