help please new to linux

ryan133 · 02-16-2017, 07:36 AM

hello, i have a question. im working on an assignment where i have a file1 and a file2

file1
name, ryan
address, 1212
country, canada

file2
car, chevy
truck, ford
van, honda

i want to create a file3 only showing
ryan
1212
chevy

i know i have to use copy and paste but i cannot figure out the command

Turbocapitalist · 02-16-2017, 07:54 AM

Welcome. We can't do homework for you but we can point in the right direction when you get stuck. Which commands have you tried?

If your data is in columns you can read the manual pages for join or uniq, you will find a hint in the "see also" section.

Code:

man join
man uniq

Though you might need to use sort on your data first.

Edit: never mind. I misread the data and you'll probably need another way to merge. Which ways have you tried besides pasting?

ryan133 · 02-16-2017, 08:16 AM

i think im supose to use cut but not 100% sure ive been trying cut -f but not working

Turbocapitalist · 02-16-2017, 08:19 AM

Ok. Read the page for cut

Code:

man cut

In addition to -f, the option you probably want may be -d, which will tell it how to identify the separator between the columns.

However, before you try that, how are you supposed to know which data to extract? What did the assignment or the teacher say about that?

ryan133 · 02-16-2017, 08:33 AM

this is what it says to do
Use the appropriate commands to create a file from the two created above containing the student first name, last name street, city and Postal Code

i changed the what it looked like on here but thats what it says have to create a 3rd file containing just few words for file 1 and 2

Turbocapitalist · 02-16-2017, 08:44 AM

Hmm. Those instructions look incomplete. How should you know that 'chevy' is associated with 'ryan' in the two files?

ryan133 · 02-16-2017, 08:51 AM

Create a file of about 10 records containing the following data (you create the values) separated by commas:
Student id
First name
Last name
Age
Phone number

Create a file of about 10 records containing the following data (you create the values) separated by commas:

Student id
Street
City
Postal code

Use the appropriate commands to create a file from the two created above containing the student first name, last name street, city and Postal Code

thats it

Turbocapitalist · 02-16-2017, 08:57 AM

Oh. I would interpret those such that each set of data be listed in rows.

Code:

Student id, First name, Last name, Age, Phone number
1234, tommy, tutone, 23, 867-5309
4567, bon, scott, 24, 362-436

and so on. If you do it like that, then you can use cut

JeremyBoden · 02-16-2017, 09:02 AM

Why not just get yourself a database with "rows" in it?

grail · 02-16-2017, 09:12 AM

Another good example how the more accurate the information you provide, the easier it is to get assistance

TB0ne · 02-16-2017, 03:37 PM

Quote:

Originally Posted by ryan133

Create a file of about 10 records containing the following data (you create the values) separated by commas:
Student id
First name
Last name
Age
Phone number

Create a file of about 10 records containing the following data (you create the values) separated by commas:

Student id
Street
City
Postal code

Use the appropriate commands to create a file from the two created above containing the student first name, last name street, city and Postal Code

thats it

Great...so go do it. We aren't going to do your homework for you, as has been told to you previously. We will ALWAYS be happy to help you if you're stuck, but so far, you've posted one command, haven't read the man page for it, and posted a follow up question with no effort shown of your own.

Post what YOU, PERSONALLY have written/done/tried, and tell us what you're confused about. We can explain man pages, give you examples, etc., but we aren't going to give you a handout.

techchamp · 02-17-2017, 06:42 AM

I am posting the direct answer as this is for an assignment and not an enterprise activity.

cat file1 | awk '{print " "$2}' |sed 's/,/ /g' |head -2 >file0;cat file2 | awk '{print " "$2}' |sed 's/,/ /g' |head -1 >>file0;cat file0

Thanks,
Techchamp - Linux

techchamp · 02-17-2017, 06:45 AM

Quote:

Originally Posted by techchamp

I am posting the direct answer as this is for an assignment and not an enterprise activity.

cat file1 | awk '{print " "$2}' |sed 's/,/ /g' |head -2 >file0;cat file2 | awk '{print " "$2}' |sed 's/,/ /g' |head -1 >>file0;cat file0

Thanks,
Techchamp - Linux

[-- advertising link removed by moderator -- ]

TB0ne · 02-17-2017, 08:19 AM

Quote:

Originally Posted by techchamp

I am posting the direct answer as this is for an assignment and not an enterprise activity.
cat file1 | awk '{print " "$2}' |sed 's/,/ /g' |head -2 >file0;cat file2 | awk '{print " "$2}' |sed 's/,/ /g' |head -1 >>file0;cat file0

Congratulations; you've done someones homework for them, and they have learned absolutely nothing from the exercise. Read the LQ Rules about homework questions, and if you're going to post something like this, don't then follow it up to advertise your 'linux learning' blog, which is also against the LQ Rules about advertising.

sundialsvcs · 02-17-2017, 08:26 AM

Also ... "students, that's what your instructor is there for."

The purpose is to give you exercises that you can, in fact, solve by yourself

and then to help you succeed in doing them. In this way, you learn about the various command-line tools that you are being introduced to in the class, and you develop the mode of thought that lets you do things like this using them.

"Yeah, it's a little mind-blowing, especially at first." (One columnist wrote a series of articles called A Sip From the Fire-Hose.) But, that's how you learn it. You come to expect to feel like this for a little while – until you solve it, which you know how to do.