Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Des/awk for change format and adding integers in a column of data?
Top Forums UNIX for Dummies Questions & Answers Des/awk for change format and adding integers in a column of data? Post 302856203 by Twinklefingers on Monday 23rd of September 2013 10:59:52 AM
Old 09-23-2013
Des/awk for change format and adding integers in a column of data?
Greetings!

I need a quick way to change the format in a table of data

Here is an example of the input:
Code:
10	72	Value=177	VDB=0.0245	Value4=0,0,171,0
10	274	Value=238	VDB=0.0433	Value4=29,0,205,0
10	312	Value=222	VDB=0.0384	Value4=8,0,190,19
10	540	Value=405	VDB=0.0391	Value4=13,30,153,195
10	542	Value=403	VDB=0.0384	Value4=45,35,121,188
10	637	Value=341	VDB=0.0418	Value4=0,1,122,195
10	645	Value=370	VDB=0.0368	Value4=0,1,131,211
10	674	Value=366	VDB=0.0323	Value4=0,5,148,200
10	854	Value=356	VDB=0.0418	Value4=14,11,188,119
10	888	Value=396	VDB=0.0374	Value4=0,0,209,176
10	892	Value=397	VDB=0.0351	Value4=0,1,210,176
10	909	Value=402	VDB=0.0374	Value4=1,6,205,186

What I need is the "Value4" column to be just a number (no text) and that number is the total of all the comma-separated integers.

Desired output:
Code:
10	72	Value=177	VDB=0.0245	171
10	274	Value=238	VDB=0.0433	234
10	312	Value=222	VDB=0.0384	217
10	540	Value=405	VDB=0.0391	391
10	542	Value=403	VDB=0.0384	389
10	637	Value=341	VDB=0.0418	318
10	645	Value=370	VDB=0.0368	343
10	674	Value=366	VDB=0.0323	353
10	854	Value=356	VDB=0.0418	332
10	888	Value=396	VDB=0.0374	385
10	892	Value=397	VDB=0.0351	387
10	909	Value=402	VDB=0.0374	398

I feel like this shouldn't be too difficult to do using sed/awk, but can't figure it out.

Any help is greatly appreciated.

Thanks!
 

4 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Format - Inventory Row data into Column - Awk - Nawk

Hi All, I have the following file that has computer data for various pcs in my network... Snap of the file is as follows ******************************************************************************* Serial 123456 Computer IP Address lo0:... (1 Reply)
Discussion started by: aavam
1 Replies

2. Shell Programming and Scripting

awk - script help: column to row format of data allignment?

Experts Good day, I have the following data, file1 BRAAGRP1 A2X B2X C2X D2X BRBGRP12 A3X B3X Z10 D09 BRC1GRP2 LO01 (4 Replies)
Discussion started by: rveri
4 Replies

3. Shell Programming and Scripting

Change data in one column with data from another file's column

Hello, I have this file outputData: # cat /tmp/outputData __Capacity^6^NBSC01_Licences^L3_functionality_for_ESB_switch __Capacity^2100^NBSC01_Licences^Gb_over_IP __Capacity^1837^NBSC01_Licences^EDGE_BSS_Fnc __Capacity^1816^NBSC01_Licences^GPRS_CS3_and_CS4... (1 Reply)
Discussion started by: nypreH
1 Replies

4. Shell Programming and Scripting

Adding new column data in csv from UNIX

Adding new column data in csv from UNIX Hi I need to add new column data daily to existing csv file. Please assist 7/11 7/10 7/9 7/8 space 10 GB 20 GB I was able to generate current day's data in csv but unable to add the previous 30 days data to the same csv Please use code tags,... (2 Replies)
Discussion started by: archana25
2 Replies

LEARN ABOUT SUNOS

iconv_8859-2

iconv_8859-2(5) 					Standards, Environments, and Macros					   iconv_8859-2(5)

NAME

       iconv_8859-2 - code set conversion tables for ISO 8859-2 (Latin 2)

DESCRIPTION

       The following code set conversions are supported:

       +--------------------------------------------------------------------+
       |		  Code Set Conversions Supported		    |
       +--------------+--------+--------------+--------+--------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |   Target Output    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |MS 1250       |win2    | Windows Latin 2    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |MS 852	      |dos2    | MS-DOS Latin 2     |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |Mazovia       |maz     | Mazovia	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |DHN	      |dhn     | Dom Handlowy Nauki |
       +--------------+--------+--------------+--------+--------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   ISO 8859-2 to MS 1250
       For the conversion of ISO 8859-2 to MS 1250, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |    MS 1250	|  ISO 8859-2	 |   MS 1250	 |
       |24	       | 4		|261		 |271		 |
       |177-237        | 40		|265		 |276		 |
       |241	       | 245		|266		 |234		 |
       |245	       | 274		|267		 |241		 |
       |246	       | 214		|271		 |232		 |
       |251	       | 212		|273		 |235		 |
       |253	       | 215		|274		 |237		 |
       |254	       | 217		|276		 |236		 |
       |256	       | 216		|266		 |236		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-2 to MS 852
       For the conversion of ISO 8859-2 to MS 852, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |    MS 852	|  ISO 8859-2	 |   MS 852	 |
       |24	       | 4		|316		 |327		 |
       |177-237        | 40		|317		 |322		 |
       |240	       | 377		|320		 |321		 |
       |241	       | 244		|321		 |343		 |
       |242	       | 364		|322		 |325		 |
       |243	       | 235		|323		 |340		 |
       |244	       | 317		|324		 |342		 |
       |245	       | 225		|325		 |212		 |
       |246	       | 227		|326		 |231		 |
       |247	       | 365		|327		 |236		 |
       |250	       | 371		|330		 |374		 |
       |251	       | 346		|331		 |336		 |
       |252	       | 270		|332		 |351		 |
       |253	       | 233		|333		 |353		 |
       |254	       | 215		|334		 |232		 |
       |255	       | 360		|335		 |355		 |
       |256	       | 246		|336		 |335		 |
       |257	       | 275		|337		 |341		 |
       |260	       | 370		|340		 |352		 |
       |261	       | 245		|341		 |240		 |
       |262	       | 362		|342		 |203		 |
       |263	       | 210		|343		 |307		 |
       |264	       | 357		|344		 |204		 |
       |265	       | 226		|345		 |222		 |
       |266	       | 230		|346		 |206		 |
       |267	       | 363		|347		 |207		 |
       |270	       | 367		|350		 |237		 |
       |271	       | 347		|351		 |202		 |
       |272	       | 255		|352		 |251		 |
       |273	       | 234		|353		 |211		 |
       |274	       | 253		|354		 |330		 |
       |275	       | 361		|355		 |241		 |
       |276	       | 247		|356		 |214		 |
       |277	       | 276		|357		 |324		 |
       |300	       | 350		|360		 |320		 |
       |301	       | 265		|361		 |344		 |
       |302	       | 266		|362		 |345		 |
       |303	       | 306		|363		 |242		 |
       |304	       | 216		|364		 |223		 |
       |305	       | 221		|365		 |213		 |
       |306	       | 217		|366		 |224		 |
       |307	       | 200		|367		 |366		 |
       |310	       | 254		|370		 |375		 |
       |311	       | 220		|371		 |205		 |
       |312	       | 250		|372		 |243		 |
       |313	       | 323		|374		 |201		 |
       |314	       | 267		|375		 |354		 |
       |315	       | 326		|376		 |356		 |
       |366	       | 367		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-2 to Mazovia
       For the conversion of ISO 8859-2 to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |    Mazovia	|  ISO 8859-2	 |   Mazovia	 |
       |24	       | 4		|323		 |243		 |
       |177-237        | 40		|324-325	 |40		 |
       |240	       | 377		|326		 |231		 |
       |241	       | 217		|327-333	 |40		 |
       |242	       | 40		|334		 |232		 |
       |243	       | 234		|335-336	 |40		 |
       |244-245        | 40		|337		 |341		 |
       |246	       | 230		|340-341	 |40		 |
       |247-253        | 40		|342		 |203		 |
       |254	       | 240		|343		 |40		 |
       |255-256        | 40		|344		 |204		 |
       |257	       | 241		|345		 |40		 |
       |260	       | 370		|346		 |215		 |
       |261	       | 206		|347		 |207		 |
       |262	       | 40		|350		 |40		 |
       |263	       | 222		|351		 |202		 |
       |264-265        | 40		|352		 |221		 |
       |266	       | 236		|353		 |211		 |
       |267-273        | 40		|354-355	 |40		 |
       |274	       | 246		|356		 |214		 |
       |275-276        | 40		|357-360	 |40		 |
       |277	       | 247		|361		 |244		 |
       |300-303        | 40		|362		 |40		 |
       |304	       | 216		|363		 |242		 |
       |305	       | 40		|364		 |223		 |
       |306	       | 225		|365		 |40		 |
       |307	       | 200		|366		 |224		 |
       |310-311        | 40		|367		 |366		 |
       |312	       | 220		|370-373	 |40		 |
       |313-320        | 40		|374		 |201		 |
       |321	       | 245		|375-376	 |40		 |
       |322	       | 40		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-2 to DHN
       For the conversion of ISO 8859-2 to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |      DHN	|  ISO 8859-2	 |     DHN	 |
       |24	       | 4		|322		 |40		 |
       |177-237        | 40		|323		 |205		 |
       |240	       | 377		|324-325	 |40		 |
       |241	       | 200		|326		 |231		 |
       |242	       | 40		|327-333	 |40		 |
       |243	       | 203		|334		 |232		 |
       |244-245        | 40		|335-336	 |40		 |
       |246	       | 206		|337		 |341		 |
       |247-253        | 40		|340		 |40		 |
       |254	       | 207		|341		 |240		 |
       |255-256        | 40		|342-345	 |40		 |
       |257	       | 210		|346		 |212		 |
       |260	       | 370		|347-351	 |40		 |
       |261	       | 211		|352		 |213		 |
       |262	       | 40		|353-354	 |40		 |
       |263	       | 214		|355		 |241		 |
       |264-265        | 40		|356-360	 |40		 |
       |266	       | 217		|361		 |215		 |
       |267-273        | 40		|362		 |40		 |
       |274	       | 220		|363		 |216		 |
       |275-276        | 40		|364		 |223		 |
       |277	       | 221		|365		 |40		 |
       |300-305        | 40		|366		 |224		 |
       |306	       | 201		|367		 |366		 |
       |307-311        | 40		|370-371	 |40		 |
       |312	       | 202		|372		 |243		 |
       |313-320        | 40		|373-376	 |40		 |
       |321	       | 204		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						   iconv_8859-2(5)
All times are GMT -4. The time now is 10:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy