Working totally from your post and copying the data and the first command, mine gives output:
I guess we need to know what Operating System and Shell and also version of join.
---------- Post updated at 11:36 ---------- Previous update was at 11:22 ----------
Quote:
The original data files were Excel files that the campus generated. We converted the files to CSV before extracting the information. So I only know as far as downloading the file?
We need to check the format of the data files. This "sed" just shows funny characters and record terminators. A normal unix text file will be terminated with a "newline" character which is displayed as "$" in this example.
If I deliberately make the file incorrect by converting it to Microsoft text format it will look like this. This may be enough to upset your "join" but mine still works.
Last edited by zaxxon; 04-15-2010 at 08:03 AM..
Reason: code tags, ty
I have a one line bat script run off a XP machine that tar's and compresses some files from a Sol 8 box. It goes something like this (a bit simplified)....
plink -pw <passwd> user@host "tar -cvf - -C / tmp/a_file | compress " > a_file.tar.Z
So this works....and it's worked many times. But now... (3 Replies)
Hi everybody,
I am hoping somebody here will be either be able to solve my troubles or at least give me a push in the right direction :) .
I am developing a shell script to read in 4 different files worth of data that each contain a list of:
username firstname secondname group score
I... (2 Replies)
Hi!
I'm having problems with pipes... I need comunnications with childs processes and parents, but only one child can comunnicate with parent (first child), others childs can't.
A brief of code:
if(pipe(client1r)<0){
perror("pipe");
}
... (1 Reply)
So I want to join two files that have a lot of rows
The file named gen1 has 2 columns:
head gen1
1008567 0.4026931012
1119535 0.7088912314
1120590 0.7093805634
1145994 0.7287952590
1148140 0.7313924434
1155173 0.7359550430
1188481 0.7598914553
1201155 0.7663406553
1206921... (2 Replies)
Hi,
I have the following code in my xml file:
<aaaRule loginIdPattern=".*"
orgIdPattern=".*" deny="false" />
<aaaRuleGroup name="dpaas">
<aaaRule loginIdPattern=".*" orgIdPattern=".*"
deny="false" />
I want to retrieve orgIdPattern and loginIdPattern parameter value based on... (2 Replies)
Hi I'm a beginner, and i've been having trouble joining two lines.
I need to convert this file
1097ALABAMA Mobile County METHOMYL INSE
CTICIDES 6 1.6200000E+00 1.8000001E+00
1003ALABAMA Baldwin County ... (5 Replies)
Dear friends,
:)
I create new user
useradd -g other -d /export/home/sltftp -m -s /bin/bash -c "SLT user account for TMA ftp backup" sltftp
now i need do restrict thees
chmod
delete
overwrite
rename
from this user:(for all the files in the server ,sltftp user can only able to download... (4 Replies)
Hi guys,
So what I am trying to accomplish is to replace a whole string starting with some designated string.
eg:
When even I find a string starting with :
eai.endpoint.url=
replace the entire line with:
eai.endpoint.url=http://www.endpoint.com/API
Righ now I am trying to... (4 Replies)
I use authconfig command to join linux computers to AD
How do I specify which OU they go in?
I llook at authconfig --help but not see antyhing\
Can I use --ldapbasedn=<dn> to select what OU it should go iN (0 Replies)
Discussion started by: red888
0 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)