How join works and the specific parameters to my problem? Post: 302413463

Sponsored Content

Homework and Emergencies Homework & Coursework Questions How join works and the specific parameters to my problem? Post 302413463 by Lechnology on Thursday 15th of April 2010 10:39:57 PM

04-15-2010

Registered User

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.)

If it will help, the original files are these:
Enrollment Excel file
Grade Excel File

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

Lechnology

View Public Profile for Lechnology

Find all posts by Lechnology

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Plink problem....only works if passwd is in the script

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...

2. Shell Programming and Scripting

A join problem?

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...

3. Programming

Problem with Pipes => Only works first pipe

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"); } ...

4. UNIX for Dummies Questions & Answers

problem with join

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...

5. UNIX for Dummies Questions & Answers

how to join two files using "Join" command with one common field in this problem?

file1: Toronto:12439755:1076359:July 1, 1867:6 Quebec City:7560592:1542056:July 1, 1867:5 Halifax:938134:55284:July 1, 1867:4 Fredericton:751400:72908:July 1, 1867:3 Winnipeg:1170300:647797:July 15, 1870:7 Victoria:4168123:944735:July 20, 1871:10 Charlottetown:137900:5660:July 1, 1873:2...

6. Shell Programming and Scripting

how to retrieve specific parameters using a xml tag

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...

7. UNIX for Dummies Questions & Answers

Join Lines at a specific point

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 ...

8. Solaris

How to Limit ftp access parameters for specific users?

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...

9. Shell Programming and Scripting

Replacing whole string starting with specific works

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...

10. Red Hat

How to join Linux pc to active directory in specific ou with authconfig?

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

LEARN ABOUT DEBIAN

file2sm

FILE2SM(1)							  ICI executables							FILE2SM(1)

NAME

       file2sm - shared-memory linked list data ingestion test program

SYNOPSIS

       file2sm fileName

DESCRIPTION

       file2sm stress-tests shared-memory linked list data ingestion by repeatedly writing all text lines of the file named fileName to a shared-
       memory linked list that is the root object of a PSM partition named "file2sm".

       After writing each line to the linked list, file2sm gives a semaphore to indicate that the list is now non-empty.  This is mainly for the
       benefit of the complementary test program sm2file(1).

       The operation of file2sm is cyclical.  After copying all text lines of the source file to the linked list, file2sm appends an EOF line to
       the linked list, containing the text "*** End of the file ***", and prints a brief performance report:

	       Processing I<lineCount> lines per second.

       Then it reopens the source file and starts appending the file's text lines to the linked list again.

EXIT STATUS

       0   file2sm has terminated.

FILES

       No configuration files are needed.

ENVIRONMENT

       No environment variables apply.

DIAGNOSTICS

       Can't attach to shared memory
	   Operating system error.  Check errtext, correct problem, and rerun.

       Can't manage shared memory.
	   PSM error.  Check for earlier diagnostic messages describing the cause of the error; correct problem and rerun.

       Can't create shared memory list.
	   smlist error.  Check for earlier diagnostic messages describing the cause of the error; correct problem and rerun.

       Can't create semaphore.
	   ION system error.  Check for earlier diagnostic messages describing the cause of the error; correct problem and rerun.

       Can't open input file
	   Operating system error.  Check errtext, correct problem, and rerun.

       Can't reopen input file
	   Operating system error.  Check errtext, correct problem, and rerun.

       Can't read from input file
	   Operating system error.  Check errtext, correct problem, and rerun.

       Ran out of memory.
	   Nominal behavior.  sm2file is not extracting data from the linked list quickly enough to prevent it from growing to consume all memory
	   allocated to the test partition.

BUGS

       Report bugs to <ion-bugs@korgano.eecs.ohiou.edu>

SEE ALSO

       sm2file(1), smlist(3), psm(3)

perl v5.14.2							    2012-05-25								FILE2SM(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Plink problem....only works if passwd is in the script

Discussion started by: Yinzer955i

2. Shell Programming and Scripting

A join problem?

Discussion started by: jamjamjammie

3. Programming

Problem with Pipes => Only works first pipe

Discussion started by: serpens11

4. UNIX for Dummies Questions & Answers

problem with join

Discussion started by: peanuts48