Yes, I pretty much did a copy/paste, modify the file names, gave it an output. Your solution is similar to what I included in #3 of my original post, only I tried to include all the fields just to see if anyone of them would output.
I should point out that it just outputs the field separators from the second file as my first posts shows.
Sorry to be a pedant, but what command did you type?
All four of the sample commands posted contain logic errors, syntax errors, or typing errors? Space characters are very important in this type of command line.
These were the command lines posted: The first two are identical and have no space character after "-o". The third omits the "-o" switch. The fourth is not really relevant.
All four of the sample commands posted contain logic errors, syntax errors, or typing errors?
Are you asking is there any error output? I've done that with a 2>error.txt, and it was blank. I don't think there's any logic, syntax or typing error as I've followed the book (Tansley) and examples I've found online explaining join.
Quote:
On the off-chance .... have any of the data files been copied from a Microsoft Operating System?
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?
So this is what I've done. Course2.txt and Grades2.txt have the 4 sample entries posted.
Quote:
10015|GEOL |158|NATURAL DISASTERS|Rezaie Boroon Mohammad Hassan|
10016|GEOL |158|NATURAL DISASTERS|Hamane Angelique C.|
10020|ART | 101A |WORLD ART|Anderson Paul A|
10021|ART | 101B |WORLD ART|Aguilar-Moreno Jose Manuel|
Working totally from your post and copying the data and the first command, mine gives output:
Code:
10015|GEOL |158|NATURAL DISASTERS|Rezaie Boroon Mohammad Hassan|1.64
10016|GEOL |158|NATURAL DISASTERS|Hamane Angelique C.|1.93
10020|ART | 101A |WORLD ART|Anderson Paul A|1.19
10021|ART | 101B |WORLD ART|Aguilar-Moreno Jose Manuel|2.59
I guess we need to know what Operating System and Shell and also version of join.
Code:
My "join" is this (According to the "what" command):
what /usr/bin/join
/usr/bin/join:
$Revision: B.11.11_LR
Fri Oct 27 00:58:04 PDT 2000 $
---------- 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.
Code:
sed -n l Courses2.txt
10015|GEOL |158|NATURAL DISASTERS|Rezaie Boroon Mohammad Hassan|$
10016|GEOL |158|NATURAL DISASTERS|Hamane Angelique C.|$
10020|ART | 101A |WORLD ART|Anderson Paul A|$
10021|ART | 101B |WORLD ART|Aguilar-Moreno Jose Manuel| $
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.
Code:
sed -n l Courses2.txt
10015|GEOL |158|NATURAL DISASTERS|Rezaie Boroon Mohammad Hassan|\r$
10016|GEOL |158|NATURAL DISASTERS|Hamane Angelique C.|\r$
10020|ART | 101A |WORLD ART|Anderson Paul A|\r$
10021|ART | 101B |WORLD ART|Aguilar-Moreno Jose Manuel| \r$
Last edited by zaxxon; 04-15-2010 at 08:03 AM..
Reason: code tags, ty
I am using SSH Secure Shell 3.2.9 (Build 283). Campus operates on XP, I have both Vista and 7. My first attempts were at school (uploading, extracting, attempting to join). When that failed, I tried again at home (reupload, etc.)
Again, I only know as far as downloading the file. I did, however, remove column headings from both files and the sum totals from the bottom of the Enrollment file before saving the Excel file as a CSV (comma delimited).
Code:
sed -n l ~/Lab1/Courses2.txt
10015\r|GEOL |158|NATURAL DISASTERS|Rezaie Boroon Mohammad Hassan|$
10016\r|GEOL |158|NATURAL DISASTERS|Hamane Angelique C.|$
10020\r|ART | 101A |WORLD ART|Anderson Paul A|$
10021\r|ART | 101B |WORLD ART|Aguilar-Moreno Jose Manuel|$
Hmm, looks like it's attached to the Catalog column (the catalog column was originally the last column of the Enrollment CSV file).
I've used tr -d "\r" to remove it (that part worked) but now I noticed (via sed) there's also a \ within the Catalog number of some of the entries. Is this a line break in SSH? Either way, it's still not working.
EDIT: Nevermind, was cramming too much stuff into one command line (copying a copy of file, etc.). Looks like it worked.
Thanks y'all.
Last edited by Lechnology; 04-16-2010 at 12:41 AM..
Reason: Found solution
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)
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)
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 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)
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)
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'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)
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)
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)
