Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extract data based on match against one column data from a long list data
Top Forums Shell Programming and Scripting Extract data based on match against one column data from a long list data Post 302371713 by Franklin52 on Monday 16th of November 2009 05:33:55 AM
Old 11-16-2009
Assumimg you want the content of the file after the 4th field matches the pattern:

Code:
awk '$4=="6.00E-45"{p=1}p' file

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

X11 auth data does not match fake data

We have different unix servers, let say I have server 1 and server 2. Well whenever I ssh from server 1 to server 2, I'm ok, but when I ssh from server 2 to server 1, I can connect just fine, but I get this message: X11 auth data does not match fake data X11 auth data does not match fake data... (1 Reply)
Discussion started by: samytrix
1 Replies

2. Shell Programming and Scripting

extract data from a data matrix with filter criteria

Here is what old matrix look like, IDs X1 X2 Y1 Y2 10914061 -0.364613333 -0.362922333 0.001691 -0.450094667 10855062 0.845956333 0.860396667 0.014440333 1.483899333... (7 Replies)
Discussion started by: ssshen
7 Replies

3. Shell Programming and Scripting

Extract specific data content from a long list of data

My input: Data name: ABC001 Data length: 1000 Detail info Data Direction Start_time End_time Length 1 forward 10 100 90 1 forward 15 200 185 2 reverse 50 500 450 Data name: XFG110 Data length: 100 Detail info Data Direction Start_time End_time Length 1 forward 50 100 50 ... (11 Replies)
Discussion started by: patrick87
11 Replies

4. Shell Programming and Scripting

Replace data of one column with data on other file corresponding to transaction ID matched

Hi All, I have two files one of which having some mobile numbers and corresponding value whose sample content as follows: 9058629605,8.0 9122828964,30.0 And in second file complete details of all mobile numbers and sample content as follows and delimeter used is comma(,): ... (8 Replies)
Discussion started by: poweroflinux
8 Replies

5. UNIX for Advanced & Expert Users

Convert column data to row data using shell script

Hi, I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated. Thanks. (4 Replies)
Discussion started by: sktkpl
4 Replies

6. Shell Programming and Scripting

Compare 2 files and match column data and align data from 3 column

Hello experts, Please help me in achieving this in an easier way possible. I have 2 csv files with following data: File1 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012... (5 Replies)
Discussion started by: asnandhakumar
5 Replies

7. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

8. Shell Programming and Scripting

Match and extract data using two files

Hello, Using the information in file 1, I would like to extract from file2 all rows which matchs in column 3. file 1 1233 1230 1231 1232 file2 65733.00 19775.00 1220 65733.00 19793.00 1220 65733.00 19801.00 1220 65733.00 19809.00 1231 65733.00 19817.00 ... (2 Replies)
Discussion started by: jiam912
2 Replies

9. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies

LEARN ABOUT OPENSOLARIS

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 01:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy