Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Modifying output column
Top Forums Shell Programming and Scripting Modifying output column Post 302837017 by Jotne on Thursday 25th of July 2013 04:18:28 AM
Old 07-25-2013
@diehard
With 28 posts, you should now that you should use code tags
And also you should post an example output.

This should work, but its some ugly.
Code:
awk '	{
	printf "%s ",$1
	}
	{	
	if ($2~/pin[0-9][0-9][A-E]/) printf "%.5sA ",$2; 
	else if ($2~/pin[0-9][0-9][F-J]/) printf "%.5sF ",$2;
	else printf "error "
	}
	{	
	if ($3~/pin[0-9][0-9][A-E]/) printf "%.5sA\n",$3; 
	else if ($3~/pin[0-9][0-9][F-J]/) printf "%.5sF\n",$3;
	else printf "error\n"
	}
	' file

Code:
D1 pin16F pin20F
R1 pin20A pin20A
VCC1 pin20A pin16F

This User Gave Thanks to Jotne For This Post:
diehard
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Modifying the final output file

Hey all, I am haivng n number of files all of them are of the same format but different details. i.e File1 is having the folloeing details: "Account1",123 "Account2",10 "Account3",12355 "Accountn",555 File2 is having the folloeing details: "Account1",1234 "Account2",100... (5 Replies)
Discussion started by: charbel
5 Replies

2. Shell Programming and Scripting

Sub. numbers in column of output with If

This is my script. I am pulling the status of some hard where, but the status is in numerical form. The number 4 means Major and the 5 means Critical. In my script I would like to show the alarm type in aplha rather than numeric form. So if instead of seeing a 4 or 5 you would see MAjor or... (11 Replies)
Discussion started by: ja156194
11 Replies

3. UNIX Desktop Questions & Answers

Loop column output

I need help in what to do with a bash script? I'm trying to run a command to output the data from a table and then insert it into commands. Looping for each row of data. For example the output data from a table: 10 John house 20 Jane apt 30 Joe townhomeThen I need to take the output... (1 Reply)
Discussion started by: handband2
1 Replies

4. Shell Programming and Scripting

4 column tsv file, output 1 specific column

Hello all siteexplorer.search.yahoo.com can output results in tsv format, when opened in excel I get 4 columns. I would like to wget that file, which I can do. I would then like to pull the 2nd column and output it only. I've searched around and found a few bits and pieces but nothing I've... (6 Replies)
Discussion started by: casphar
6 Replies

5. Shell Programming and Scripting

getting the column header in the output !

i have a script that access the database and then returns some row. but in the command prompt it it not showing the column header. how to get that ? below the script: ------------------------------------------------------------------------ #!/bin/ksh .... (4 Replies)
Discussion started by: ali560045
4 Replies

6. Shell Programming and Scripting

top output for six processes with the same name, output changed from column to row

Hi, I have a system under test, and I use a script that does a ps. The output, is in the following format, it's basically the timestamp, followed by the rss and vsize. 09:03:57 68404 183656 68312 181944 69860 217360 67536 182564 69072 183172 69032 199276 09:04:27 68752 183292 70000 189020... (5 Replies)
Discussion started by: Bloke
5 Replies

7. Shell Programming and Scripting

Converting line output to column based output

Hi Guys, I am trying to convert a file which has a row based output to a column based output. My original file looks like this: 1 2 3 4 5 6 1 2 3 1 2 3 (8 Replies)
Discussion started by: npatwardhan
8 Replies

8. Shell Programming and Scripting

Column to row output

Hello All, i have a file with the contents like shown below Name = POLICY1 Selected = 1 Written = 0 Name = POLICY2 Selected = 6 Written = 8 Name = POLICY3 Selected = 4 Written = 26 I want the output to be... (5 Replies)
Discussion started by: vinredmac
5 Replies

9. Shell Programming and Scripting

Column output

awk -v OFS="\t" -v ORS="\r\n" 'NR==FNR{A=$4; next} A {$4=$4 " " A}1' refseq_genes.txt LCH_exons.txt > output2.txt Trying to output the data to separate columns in excel, but the 4th column seems to be merged together. This is more of just a learning question. Thank you :). (1 Reply)
Discussion started by: cmccabe
1 Replies

10. Shell Programming and Scripting

How to append the output in a new column?

input1 john 20 bob 30 input2 john 60 bob 100 cat input1 >> output cat input2 >> output ouput john 20 bob 30 john 60 bob 100 desired output input1 input1 input2 input2 john 20 john 60 (3 Replies)
Discussion started by: quincyjones
3 Replies

LEARN ABOUT DEBIAN

lpbb

LPBB(4) 						   BSD Kernel Interfaces Manual 						   LPBB(4)

NAME

     lpbb -- parallel port I2C bit-banging interface

SYNOPSIS

     device iicbus
     device iicbb

     device lpbb
     device iic

DESCRIPTION

     The lpbb driver supports the Philips official I2C parallel bit-banging interface.

					      LS05 pin 14 (Vcc) o      -------
								|      |     |
		 +--+--+---------------------+--+--+------------+------+-o 1 |
		 |  |  |		     |	|  |	       ===.1uF | +5V |
       -------- [R][R][R] 3x10K       3x10K [R][R][R]	LS05	|      |     |
       |      |  |  |  |		     |	|  |	pin 7 o-+------+-o 2 |
       | 12 o-+--+  |  |   3| 4	     |	|  |	(Gnd)	       | GND |
       | 17 o-+-----|--|----| >o-------------+--|--|--------------+    |     |
       |      |     |  |    |/	      8 /|9	|  |	 10 /|11  +----+-o 3 |
       | 15 o-+-----+--|--------------o< |------+--|------o< |----+    | SCL |
       |      |        |   1| 2	|	   |	    |	       |     |
       |  9 o-+--------|----| >o-------------------+--------------+----+-o 4 |
       |      |        |    |/				  6 /|5   |    | SDA |
       | 11 o-+--------+----------------------------------o< |----+    -------
       | 10 o-+-+					    |		4-pin
       | 13 o-+-+--oGND 					     Connector
       | 25 o-+-+      ------------------ Part List --------------------------
       --------        | 1 - .1 uF capacitor   | 6 - 10K 5% resistors	     |
       25-pin male D   | 1 - 4-pin connector   | 1 - 25-pin male D connector |
       connector to PC | 1 - 74LS05 open collector hex inverter 	     |
       printer port    -------------------------------------------------------

SEE ALSO

     iicbb(4), iicbus(4), ppbus(4)

HISTORY

     The lpbb manual page first appeared in FreeBSD 3.0.

AUTHORS

     This manual page was written by Nicolas Souchu.

BSD
								 October 25, 1998							       BSD
All times are GMT -4. The time now is 09:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy