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 302371693 by thegeek on Monday 16th of November 2009 05:01:54 AM
Old 11-16-2009
Code:
sed -rn '/([^ \t]* ){3}6.00E-45/,$p' t1

t1 is the file name.
 

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 SUNOS

iconv_852

iconv_852(5)						Standards, Environments, and Macros					      iconv_852(5)

NAME

       iconv_852 - code set conversion tables for MS 852 (MS-DOS Latin 2)

DESCRIPTION

       The following code set conversions are supported:

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

CONVERSIONS

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

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

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

   MS 852 to MS 1250
       For the conversion of MS 852 to MS 1250, all characters not in the following table are mapped unchanged.

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

   MS 852 to Mazovia
       For the conversion of MS 852 to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |    MS 852     |    Mazovia	|    MS 852	 |   Mazovia	 |
       |205	       | 40		|246-247	 |40		 |
       |206	       | 215		|250		 |220		 |
       |210	       | 222		|251		 |221		 |
       |212-213        | 40		|253		 |246		 |
       |215	       | 240		|254-270	 |40		 |
       |217	       | 225		|275		 |241		 |
       |220-226        | 40		|276		 |247		 |
       |227	       | 230		|306-336	 |40		 |
       |230	       | 236		|340		 |243		 |
       |233-234        | 40		|342		 |40		 |
       |235	       | 234		|343		 |245		 |
       |236-243        | 40		|344		 |244		 |
       |244	       | 217		|345-375	 |40		 |
       |245	       | 206		|		 |		 |
       +---------------+----------------+----------------+---------------+

   MS 852 to DHN
       For the conversion of MS 852 to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |    MS 852     |      DHN	|    MS 852	 |     DHN	 |
       |200-205        | 40		|244		 |200		 |
       |206	       | 212		|245		 |211		 |
       |207	       | 40		|246-247	 |40		 |
       |210	       | 214		|250		 |202		 |
       |211-214        | 40		|251		 |213		 |
       |215	       | 207		|253		 |220		 |
       |216	       | 40		|254-270	 |40		 |
       |217	       | 201		|275		 |210		 |
       |220-226        | 40		|276		 |221		 |
       |227	       | 206		|306-336	 |40		 |
       |230	       | 217		|340		 |205		 |
       |233-234        | 40		|342		 |40		 |
       |235	       | 203		|343		 |204		 |
       |236-237        | 40		|344		 |215		 |
       |242	       | 216		|345-375	 |40		 |
       |252	       | 254		|		 |		 |
       +---------------+----------------+----------------+---------------+

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_852(5)
All times are GMT -4. The time now is 10:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy