Question: Need help with Linux problem 5.Find the people who donated at least $10.00 in any month in the file move5.txt. For this, I just want

Need help with Linux problem

5.Find the people who donated at least $10.00 in any month in the file move5.txt. For this, I just want their full name and phone number, but nothing else. This data should be sorted by their last name.

The code I have:

grep '$[1-9][0-9]\.' $1 | sed 's/$[A-Za-z]*$$[ A-Za-z]*$$[0-9]$*[^%$]*$$.*$/\2 \1\3/' > move5.txt

the format of file being manipulated:

Jane Smith%(314)422-1234%$10.00%$50.00%$15.00

John Doe%(926)516-1234%$5.00%$75.00%$25.25

The output I'm getting to move5.txt is:

Jane Smith%( 314)422-1234

John Doe%( 926)516-1234

I need it to just output the first and last name with phone number using the above commands. Need to remove the % and the weird whitespace after (

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

# ! / bin / bash #Author: Name #Purpose: This script processes a data file to produce 5 output files based on specified criteria #Check if a file name is provided if [ [ $# = = 0 ] ] then echo Usage:...

Attention! In the beginning of each program ( Bash script file ) , after # ! / bin / bash line, there should be comments with the authors name and the the purpose of the script. Up to 3 points will...

Attention! In the beginning of each program ( Bash script file ) , after # ! / bin / bash line, there should be comments with the author s name and the the purpose of the script. Up to 3 points will...

I need this done using GREP, AWK, and SED commands. I am really struggling with item 5 in particular. All would be extremely helpful, as 3 and 4 are throwing me off as well. [30 points] Write a Bash...

# ! / bin / bash #Author: Name #Purpose: This script processes a data file to produce 5 output files based on specified criteria #Check if a file name is provided if [ [ $# - eq 0 ] ] echo "Usage: $...

markets questions and answers The cloud provider estimates that, based on historical data of the cloud environment, over the next 24 months there is a 22% chance that the physical server hosting the...

I am doing tax return project. attachments are the materials professor provide. He wants me to do a current year engagement file (Similar with prior year engagement file). AC 371 Tax Return Project...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Hey i need help with a final semester project that i am doing where i was trying to do it by my self but could not do and this final assignmentis due by the first week of december. When doing the...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

Suppose that the market is initially at an equilibrium price of $6 and an equilibrium quantity of 40 units. If the government decides to add a $2 per-unit tax on this good, producer surplus will fall...

what is difference between positive term series and power series? How to test a power series for convergence?

A plan for acquiring and using resources over a specified time period is Blank _ _ _ _ _ _ . Multiple choice question. profit planning the budget responsibility accounting the budget period

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...