10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Trying to match $1 of target.txt to $5 of file.txt. If there is a match then in an output.txt file $1,$1 (row underneath),$6,$4,$7 from file.txt are printed on the same line as $1 of target.txt. The input is from excel and the output should be tab-deliminated. Thank you :).
target.txt... (2 Replies)
Discussion started by: cmccabe
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I wanted to merge the content and below is input and required output info.
Input:
/hello,a,r
/hello,a,L
/hello,a,X
/hi,b,v
/hi,b,c
O/p:
/hello,a,r:L:X
/hi,v,:v:c
Use code tags, thanks. (6 Replies)
Discussion started by: ankitas
6 Replies
3. Shell Programming and Scripting
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Discussion started by: mtucker6784
6 Replies
4. Shell Programming and Scripting
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
Discussion started by: ks_reddy
4 Replies
5. Shell Programming and Scripting
Hi,
I have a file with multiple columns and for column 5 I want to extract that row into another file if it is equal to or greater than a certain value.
For example:
FAR 4 5 7 LOP
GAT 3 3 3 POL
I want values that are greater than 5 for column 4. So the final file will look like... (1 Reply)
Discussion started by: phil_heath
1 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I would like to know how can I delete rows of a text file if from the 3rd column onwards there is only zeros?
Thanks in advance (7 Replies)
Discussion started by: fadista
7 Replies
7. Shell Programming and Scripting
Hi all
I have a text file with the following format:
id col1 col2 col3 col4 col5 col6 col7 ...
row1 0 0 0 0 0 0 0
row2 0 0 0 0 0 0 0
row3 0 0 0 0 0 0.2 0
row4 0 0 0 0 0 0 0
row5 0 0 0 0 0 0 0
row6 0 0 0 0.1 0 0 0
row7 0 0 0 0 0 0 0
row8 0 0 0 0 0 0 0
row9 0 0 0 0 0 0 0
...
The file... (2 Replies)
Discussion started by: gautig
2 Replies
8. Shell Programming and Scripting
Hi,
I need help to add a certain values to end of each line in the same file.
Here is my input file
name:aaa
id :123
salary
job
qulification
name:bbb
id :124
salary
job
qulification
name:ccc
id :345
salary
job
qulification (2 Replies)
Discussion started by: jpkumar10
2 Replies
9. Shell Programming and Scripting
Hi,
I have code which is like this
<TABLE name="UsageDetail_24>
<ROW>
<Date24><!]></Date24>
<Time24><!]></Time24>
<Destination24><!]></Destination24>
<Rate24><!]></Rate24>
<Duration24><!]></Duration24>
<Cost24><!]></Cost24>
<Allowance24><!]></Allowance24>
</ROW>
<ROW>... (3 Replies)
Discussion started by: legolad
3 Replies
10. Shell Programming and Scripting
Hi,
I want a UNIX command that can filter out rows with certain criteria.
The file is tab deliminated. Row one is just a value. Basically what I want to do is select based on the name and character at the end (o). So lets lets say i want a row that has WashU and (o) then it would print... (2 Replies)
Discussion started by: phil_heath
2 Replies