Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Perl Script for reading table format data from file.
Top Forums Shell Programming and Scripting Perl Script for reading table format data from file. Post 302576437 by durden_tyler on Friday 25th of November 2011 12:08:15 AM
Old 11-25-2011
Quote:
Originally Posted by asak
...
i need a perl script which reads the file, content is given below. and output in new file.
Code:
 TARGET DRIVE         IO1          IO2         IO3        IO4        IO5
    ------------    ---------   ---------   ---------   ---------   ---------
    0a.1.8          266            236         179        607        337
    0a.1.7          232            202         147        504        262
    0a.1.13         257            231         175        611        319
    0a.1.12         256            227         168        603        323

i need output in new file in following format.
Code:
TARGETDRIVE : 0a.1.8 0a.1.7 ......
IO1 =	266 232 257 256
IO2 =   236 202 231 227
IO3 = 179 147 175 168
:
:
so on

...
Code:
$
$
$ cat f23
TARGET DRIVE          IO1         IO2         IO3         IO4         IO5
------------    ---------   ---------   ---------   ---------   ---------
     0a.1.8           266         236         179         607         337
     0a.1.7           232         202         147         504         262
     0a.1.13          257         231         175         611         319
     0a.1.12          256         227         168         603         323
$
$
$
$ perl -lane 'if ($. == 1) {
                push @{$x[0]}, "$F[0]$F[1] :";
                for ($i=2; $i<=$#F; $i++) {push @{$x[$i-1]}, "$F[$i] ="}
              } elsif (!/-/) {
                for ($i=0; $i<=$#F; $i++) {push @{$x[$i]}, $F[$i]}
              }
              END {
                for ($i=0; $i<=$#x; $i++) {print "@{$x[$i]}"}
              }
             ' f23
TARGETDRIVE : 0a.1.8 0a.1.7 0a.1.13 0a.1.12
IO1 = 266 232 257 256
IO2 = 236 202 231 227
IO3 = 179 147 175 168
IO4 = 607 504 611 603
IO5 = 337 262 319 323
$
$
$

tyler_durden
This User Gave Thanks to durden_tyler For This Post:
asak
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script not reading Data from oracle table properly

Hi, I have a case where i am connecting to the oracle DB and reading a column value.... Script is in production...it was running fine,,,but suddenly now some times its started giving pain.... Script runs dailly....but sometimes its reading data from Oracle DB and sometimes its not rading the... (2 Replies)
Discussion started by: Sagarddd
2 Replies

2. Shell Programming and Scripting

write a perl script or kornshell reading a two files and outputting to comma format

Hello Can someone help me to write a perl script or kornshell reading a two files and outputting to comma format. Here is the two files listofdisks.txt id, diskname, diskgroup, diskisze(GB), FC 1, CN34, GRP1, 30, FC_CN34 2, CN67, GRP5, 19, 4, VD1, GRP4, 23, FC_VD1 6, CF_D1, ... (0 Replies)
Discussion started by: deiow
0 Replies

3. Shell Programming and Scripting

PERL: reading 2 column data into Hash file

I am trying to read in a 2 column data file into Perl Hash array index. Here is my code. #!/usr/bin/perl -w use strict; use warnings; my $file = "file_a"; my @line = (); my $index = 0; my %ind_file = (); open(FILE, $file) or die($!); while(<FILE>) { chomp($_); if ($_ eq '') { ... (1 Reply)
Discussion started by: subhap
1 Replies

4. Shell Programming and Scripting

Perl: Reading data from other file

Hi, I am writting some perl scripts for daily backup process. In which I want to pass some data/referance from another txt file. Text file contains only one column and multiple rows. I want to pass this data to variables of another perl script. e.g. Refdoc.txt file contains data as: perl1... (3 Replies)
Discussion started by: n.dba
3 Replies

5. Shell Programming and Scripting

how to print out data from mysql table in perl script

I'm having trouble with this code. if i do .\read.pl -u user it prints out 2010-12-20 12:00:00 host1 <cmd>a 2010-12-20 12:00:01 host1 <cmd> <execute> 2010-12-20 12:00:02 host1 <cmd>b 2010-12-20 12:00:03 host1 <cmd>c however, if i enter .\read.pl -h host1 it should... (3 Replies)
Discussion started by: kpddong
3 Replies

6. Shell Programming and Scripting

Help with perl script to output data in table format...

Hello, I need help with a perl script that will process a text file and match virtual server name to profile(s). the rest will be ignored. Virtual server name follows the word "virtual" in the begging of the line. There could be multiple profiles assigned to one virtual server. For example, ... (3 Replies)
Discussion started by: besogon
3 Replies

7. Shell Programming and Scripting

Represent the data in table format as in mail content

hi all, I want to Represent the data in table format in mail content sample data should be like this...but i m trying to send this table to mail using unix command...hw do i do????even i echoed the table contents ...doesnt work.... help me <table style="background-color:lightblue;">... (8 Replies)
Discussion started by: navsan
8 Replies

8. Shell Programming and Scripting

Input data of a file from perl into HTML table

Hi , I need an help in perl scripting. I have an perl script written and i have an for loop in that ,where as it writes some data to a file and it has details like below. cat out.txt This is the first line this is the second line. .....Now, this file needs to be send in mail in HTML... (2 Replies)
Discussion started by: scott_cog
2 Replies

9. Shell Programming and Scripting

Perl -- Script to re-format data

Hi, I have a file with data in the following format BOX -1.000000 -1.000000 0.000000 30.00000 14.00000 0.1000000 0.000000 0.000000 0.000000 0.000000 0.000000 CYLINDER 3.595000 2.995000 0.000000 0.5100000 2.000000 Z 0.000000 0.000000 0.000000 I want to convert these files... (1 Reply)
Discussion started by: lost.identity
1 Replies

10. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

LEARN ABOUT SUNOS

iconv_8859-1

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

NAME

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

DESCRIPTION

       The following code set conversions are supported:

       +--------------------------------------------------------------------+
       |		  Code Set Conversions Supported		    |
       +--------------+--------+--------------+--------+--------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |   Target Output    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-1    |8859    |ISO 646       |646     | 7 bit ASCII	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-1    |8859    |ISO 646de     |646de   | German 	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-1    |8859    |ISO 646da     |646da   | Danish 	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-1    |8859    |ISO 646en     |646en   | English ASCII	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-1    |8859    |ISO 646es     |646es   | Spanish	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-1    |8859    |ISO 646fr     |646fr   | French 	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-1    |8859    |ISO 646it     |646it   | Italian	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-1    |8859    |ISO 646sv     |646sv   | Swedish	    |
       +--------------+--------+--------------+--------+--------------------+

CONVERSIONS

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

   ISO 8859-1 to ISO 646 (7-bit ASCII)
       For the conversion of ISO 8859-1 to ISO 646, all characters not in the following table are mapped unchanged.

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

   ISO 8859-1 to ISO 646de (GERMAN)
       For the conversion of ISO 8859-1 to ISO 646de, all characters not in the following tables are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-1   |   ISO 646de	|  ISO 8859-1	 |  ISO 646de	 |
       |247	       | 100		|337		 |176		 |
       |304	       | 133		|344		 |173		 |
       |326	       | 134		|366		 |174		 |
       |334	       | 135		|374		 |175		 |
       +---------------+----------------+----------------+---------------+

       Converted to Underscore '_' (137)
       ---------------------------------
       100 133 134 135 173 174 175 176
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242 243 244 245 246
       250 251 252 253 254 255 256 257
       260 261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303	   305 306 307
       310 311 312 313 314 315 316 317
       320 321 322 323 324 325	   327
       330 331 332 333	   335 336 337
       340 341 342 343	   345 346 347
       350 351 352 353 354 355 356 357
       360 361 362 363 364 365	   367
       370 371 372 373	   375 376 377

   ISO 8859-1 to ISO 646da (DANISH)
       For the conversion of ISO 8859-1 to ISO 646da, all characters not in the following tables are mapped unchanged.

       +-----------------------------------------------------------------+
       |		     Conversions Performed			 |
       +---------------+----------------+----------------+---------------+
       |  ISO 8859-1   |   ISO 646da	|  ISO 8859-1	 |     ISO	 |
       +---------------+----------------+----------------+---------------+
       |646da	       |		|		 |		 |
       +---------------+----------------+----------------+---------------+
       |305	       | 135		|345		 |175		 |
       +---------------+----------------+----------------+---------------+
       |306	       | 133		|346		 |173		 |
       +---------------+----------------+----------------+---------------+
       |330	       | 134		|370		 |174		 |
       +---------------+----------------+----------------+---------------+

       Converted to Underscore '_' (137)
       ---------------------------------
       133 134 135 173 174 175
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242 243 244 245 246 247
       250 251 252 253 254 255 256 257
       260 261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303 304	   307
       310 311 312 313 314 315 316 317
       320 321 322 323 324 325 326 327
	   331 332 333 334 335 336 337
       340 341 342 343 344	   347
       350 351 352 353 354 355 356 357
       360 361 362 363 364 365 366 367
       371 372 373 374	       376 377

   ISO 8859-1 to ISO 646en (ENGLISH ASCII)
       For the conversion of ISO 8859-1 to ISO 646en, all characters not in the following tables are mapped unchanged.

       +-----------------------------------------------------------+
       |		  Conversions Performed 		   |
       +-----------------------------+-----------------------------+
       |	ISO 8859-1	     |	       ISO 646en	   |
       +-----------------------------+-----------------------------+
       |243			     |043			   |
       +-----------------------------+-----------------------------+

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

   ISO 8859-1 to ISO 646fr (FRENCH)
       For the conversion of ISO 8859-1 to ISO 646fr, all characters not in the following tables are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-1   |   ISO 646fr	|  ISO 8859-1	 |  ISO 646fr	 |
       |243	       | 043		|347		 |134		 |
       |247	       | 135		|350		 |175		 |
       |250	       | 176		|351		 |173		 |
       |260	       | 133		|371		 |174		 |
       |340	       | 100		|		 |		 |
       +---------------+----------------+----------------+---------------+

       Converted to Underscore '_' (137)
       ---------------------------------
       043
       100 133 134 135 173 174 175 176
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242     244 245 246
	   251 252 253 254 255 256 257
	   261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303 304 305 306 307
       310 311 312 313 314 315 316 317
       320 321 322 323 324 325 326 327
       330 331 332 333 334 335 336 337
	   341 342 343 344 345 346
	       352 353 354 355 356 357
       360 361 362 363 364 365 366 367
       370     372 373 374 375 376 377

   ISO 8859-1 to ISO 646it (ITALIAN)
       For the conversion of ISO 8859-1 to ISO 646it, all characters not in the following tables are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-1   |   ISO 646it	|  ISO 8859-1	 |  ISO 646it	 |
       |243	       | 043		|350		 |175		 |
       |247	       | 100		|351		 |135		 |
       |260	       | 133		|354		 |176		 |
       |340	       | 173		|362		 |174		 |
       |347	       | 134		|371		 |140		 |
       +---------------+----------------+----------------+---------------+

       Converted to Underscore '_' (137)
       ---------------------------------
       043
       100 133 134 135 173 174 175 176
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242     244 245 246
       250 251 252 253 254 255 256 257
	   261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303 304 305 306 307
       310 311 312 313 314 315 316 317
       320 321 322 323 324 325 326 327
       330 331 332 333 334 335 336 337
	   341 342 343 344 345 346
	       352 353 354 355 356 357
       360 361 362 363 364 365 366 367
       370     372 373 374 375 376 377

   ISO 8859-1 to ISO 646es (SPANISH)
       For the conversion of ISO 8859-1 to ISO 646es, all characters not in the following tables are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-1   |   ISO 646es	|  ISO 8859-1	 |  ISO 646es	 |
       |241	       | 133		|321		 |134		 |
       |247	       | 100		|347		 |175		 |
       |260	       | 173		|361		 |174		 |
       |277	       | 135		|		 |		 |
       +---------------+----------------+----------------+---------------+

       Converted to Underscore '_' (137)
       ---------------------------------
       100 133 134 135 173 174 175
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240     242 243 244 245 246
       250 251 252 253 254 255 256 257
	   261 262 263 264 265 266 267
       270 271 272 273 274 275 276
       300 301 302 303 304 305 306 307
       310 311 312 313 314 315 316 317
       320     322 323 324 325 326 327
       330 331 332 333 334 335 336 337
       340 341 342 343 344 345 346
       350 351 352 353 354 355 356 357
       360     362 363 364 365 366 367
       370 371 372 373 374 375 376 377

   ISO 8859-1 to ISO 646sv (SWEDISH)
       For the conversion of ISO 8859-1 to ISO 646sv, all characters not in the following tables are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-1   |   ISO 646sv	|  ISO 8859-1	 |  ISO 646sv	 |
       |304	       | 133		|344		 |173		 |
       |305	       | 135		|345		 |175		 |
       |311	       | 100		|351		 |140		 |
       |326	       | 134		|366		 |174		 |
       |334	       | 136		|374		 |176		 |
       +---------------+----------------+----------------+---------------+

       Converted to Underscore '_' (137)
       ---------------------------------
       100 133 134 135 136 140
       173 174 175 176
       200 201 202 203 204 205 206 207
       210 211 212 213 214 215 216 217
       220 221 222 223 224 225 226 227
       230 231 232 233 234 235 236 237
       240 241 242 243 244 245 246 247
       250 251 252 253 254 255 256 257
       260 261 262 263 264 265 266 267
       270 271 272 273 274 275 276 277
       300 301 302 303	       306 307
       310     312 313 314 315 316 317
       320 321 322 323 324 325	   327
       330 331 332 333	   335 336 337
       340 341 342 343	       346 347
       350     352 353 354 355 356 357
       360 361 362 363 364 365	   367
       370 371 372 373	   375 376 377

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							    28 Apr 1997 						   iconv_8859-1(5)
All times are GMT -4. The time now is 06:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy