01-09-2009
count number of nonempty columns in row
Hi,
Suppose i have a inputfile in csv format.
How to use awk to count 'the number of nonempty columns in each row' minus one, and add the value as a new column in the end
For cosmetic reason, it's even better to include a descriptive label for the last column in the first row.
for example, i want to convert
London,a,b,c,,,,->London,a,b,c,,,,,3
York,a,b,,,a,a ->York,a,b,,,a,a,4
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi
i am pretty new to unix .i am ETL guy
I need a unix script to take row count of a file and write it to another file
the problem with wc-l is it include filename also
wc -l abc.dat
will give me like 1000 abc.dat
i just want 1000 to be written
can u just take 2 min to write a simple... (1 Reply)
Discussion started by: er_zeeshan05
1 Replies
2. Shell Programming and Scripting
Hi Experts,
The question may look very silly by seeing the title, but please have a look at it clearly.
I have a text file where the first 5 columns in each row were supposed to be attributes of a sample(like sample name, number, status etc) and the next 25 columns are parameters on which... (3 Replies)
Discussion started by: ks_reddy
3 Replies
3. Shell Programming and Scripting
I have a sorted file like:
Apple 3
Apple 5
Apple 8
Banana 2
Banana 3
Grape 31
Orange 7
Orange 13
I'd like to search $1 and if $1 is not the same as $1 in the previous row print that row and print the number of times $1 was found.
so the output would look like:
Apple 8 3
Banana... (2 Replies)
Discussion started by: dcfargo
2 Replies
4. Shell Programming and Scripting
Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count
The input file:
21 2341 A
21 2341 A
21 2341 A
21 2341 C
21 2341 C
21 2341 C
21 2341 C
21 4567 A
21 4567 A
21 4567 C
... (6 Replies)
Discussion started by: juelillo
6 Replies
5. Shell Programming and Scripting
This is the source file, we called it errorlist.out
196 server_a server_unix_2 CD
196 server_b server_win_1 CD
196 server_c server_win_2 CD
196 server_bd server_unix_2 CD
196 server_d server_unix_2 CD
196 server_es server_win_1 CD
196 ... (14 Replies)
Discussion started by: sQew
14 Replies
6. Shell Programming and Scripting
Input
A.1 Q.1
A.1 Q.2
A.1 Q.3
A.2 Q.4
Explanation:
Final Output
A.1 Q.1 s1 t1
A.1 Q.2 s1 t2
A.1 Q.3 s1 t3
A.2 Q.4 s5 t5
---------- Post updated 09-28-12 at 03:38 AM ---------- Previous update was 09-27-12 at 09:10 AM ----------
Hi Guys, I was able to do until... (11 Replies)
Discussion started by: quincyjones
11 Replies
7. UNIX for Dummies Questions & Answers
we want the count of number of records to be printed on each row.
For Ex:
if there are 5 records on one unique id , the count "5'' should be printed on each record in other column. Please help for this. I am using unix & Cygwin.
Below are sample records:
KCZ0650473... (2 Replies)
Discussion started by: ElijaRajesh
2 Replies
8. UNIX for Beginners Questions & Answers
I have a file abc.csv, from which I need column 24(PurchaseOrder_TotalCost) to get the sum_of_amounts with date and row count into another file say output.csv
abc.csv-
UTF-8,,,,,,,,,,,,,,,,,,,,,,,,,
... (6 Replies)
Discussion started by: Tahir_M
6 Replies
9. Shell Programming and Scripting
I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end
Source file will have
001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C
Need Output from every 5 tab and remove the comma from end of each row
... (4 Replies)
Discussion started by: ranjancom2000
4 Replies
10. Shell Programming and Scripting
I have a file with 48 rows. I am counting 6 rows and adding 6 to that number and repeating the operation, and then output the value in column 1. For the second column, I would like to get sort of a binary output (1s and 2s) every 3rd row. This is what I have:
awk '{print ++src +... (1 Reply)
Discussion started by: Xterra
1 Replies
LEARN ABOUT DEBIAN
cdk_position
cdk_position(3) Library Functions Manual cdk_position(3)
NAME
cdk_position - curses widget positioning key-bindings
SYNOPSIS
Position methods for the Cdk widgets allow the user to move the widget around the screen via the cursor/keypad keys.
DESCRIPTION
The following key bindings can be used to move the widget around the screen.
+---------------------------------------------------------------+
|Key Action |
+---------------------------------------------------------------+
|Up Arrow Moves the widget up one row. |
|Down Arrow Moves the widget down one row. |
|Left Arrow Moves the widget left one column |
|Right Arrow Moves the widget right one column |
|1 Moves the widget down one row and left one |
| column. |
|2 Moves the widget down one row. |
|3 Moves the widget down one row and right one |
| column. |
|4 Moves the widget left one column |
|5 Centers the widget both vertically and hori- |
| zontally. |
|6 Moves the widget right one column |
|7 Moves the widget up one row and left one |
| column. |
|8 Moves the widget up one row. |
|9 Moves the widget up one row and right one |
| column. |
|t Moves the widget to the top of the screen. |
|b Moves the widget to the bottom of the |
| screen. |
|l Moves the widget to the left of the screen. |
|r Moves the widget to the right of the screen. |
|c Centers the widget between the left and |
| right of the window. |
|C Centers the widget between the top and bot- |
| tom of the window. |
|Escape Returns the widget to its original position. |
|Return Exits the function and leaves the wid- |
| getwhere it was. |
+---------------------------------------------------------------+
+---------------------------------------------------------------+
The numbers 0-9 are chosen to correspond to the numeric keypad on your terminal. Cdk does not handle the application mode keypad control
sequences, since those are not defined via terminfo. To use the numeric keypad you should ensure that it is in normal (or NumLock) mode.
SEE ALSO
cdk(3), cdk_binding(3), cdk_display(3), cdk_screen(3)
cdk_position(3)