Suppose that you receive a file in the comma separated value format. Assume that columns are labeled by "A", "B", "C", etc, and rows are labelled by 1, 2, 3, etc. Note that this kind of data and labels can be found in Excel, if you like. We want to extract a subset of data from the file, myCSV.txt, which is formated as explained above. The subset of data that we want is contained in the columns "C" to "E" and "G". Let's try the following steps:

Use the delimiter ',' for the option -d, select the fields from 3 to 5. The Linux command is:
Do the command-line above to save the result in the file called, mySub1.txt. Give the Linux command.
Assume that mySub2.txt contains the column "G" in the similar way above. Now the command ___________________________________ joins the two files, mySub1.txt and mySub2.txt and save the result in the file "mySub.txt'.
The command _________________________________ scrambles by translating the first 13 alphabets to the second 13 alphabets and vice versa.

The LQ Rules prohibit verbatim posting of homework assignments. If you will show what you have tried, people are willing to help, but don't ask someone to do the assignment for you.

2 members found this post helpful.

I am willing to pay its not homework btw I

Supposing I received a task like that, the first thing I would do is a web search.

Please note that we are all volunteers here. Your question is urgent to no one but you. A title such as "Extract data from CSV file" would have been far better than "Help Me Urgent Linux."

If you have not done so, you may want to read this.

3 members found this post helpful.

You can't afford most of the people here...and the ones you can afford are probably also looking for people to do their homework as well.
Who do you think you're kidding here??? I cannot FATHOM it being a work assignment, because if you got a job doing such things you'd have the skills to do the job. And, there's NO real reason a 'work assignment' would have you show your work, and write down how you did it.

Read the "Question Guidelines"...we aren't going to do your work for you, and please, don't lie to people when posting. We will be happy to help you, but show your effort first.

I really gotta wonder if this is a troll account. Who would ever post exact questions for a class like this? It's just a waste of money on schooling that isn't going to teach them anything.

Troll?

Honestly, after as long as you've been here (like me), can you really tell me you haven't seen a zillion "plz...homework! URGENT!" questions?? This is just the latest....

The content really isn't very trollish, but it's clearly poorly conceived.

(evil grin) Script-kiddie?

LQ needs a better methodology to SCREEN new posters.

What is a troll account ?

Per the LQ Rules, please do not post homework assignments verbatim. We're happy to assist if you have specific questions or have hit a stumbling point, however. Let us know what you've already tried and what references you have used (including class notes, books, and Google searches) and we'll do our best to help. Also, keep in mind that your instructor might also be an LQ member.

1 members found this post helpful.