Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: reducing values in columns with both numbers and letters
Top Forums Shell Programming and Scripting reducing values in columns with both numbers and letters Post 302597458 by olifu02 on Friday 10th of February 2012 11:11:28 AM
Old 02-10-2012
im sorry i may have mislead you guys

i need

Code:
A431QB-A31HA-A431CB              1.429      3.936     17.212

to

Code:
A31QB-A31HA-A31CB              1.429      3.936     17.212

but the first two answers in the thread would delete the .429 as well which i dont want.

Thanks all
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Letters, Numbers or Alphanumerical

How do I check if a variable consisted of letters, numbers or both letters and numbers? For example, I have a variable $X and I want to print "1" if it contains only letters, "2" if it contains only numbers and "3" if it contains both (2 Replies)
Discussion started by: sleepster
2 Replies

2. UNIX for Dummies Questions & Answers

Help! scrolling numbers and letters

Hello all I am a unix newbie.... I have a sun netra t1 and it is freaking out I am connected to it through a console port, and it is just spitting out a ton on numbers and letters like below its just keeps going and going. I have tried rebooting it and I cannot get it back to any kind of a... (1 Reply)
Discussion started by: intraining11
1 Replies

3. Shell Programming and Scripting

sed command, look for numbers following letters

If I have a set of strings, C21 F231 H42 1C10 1F113 and I want to isolate the ints following the char, what would the sed string be to find numbers after letters? If I do, *, I will get numbers after letters, but I am looking to do something like, sed 's/*/\t*/g' this will give me... (14 Replies)
Discussion started by: LMHmedchem
14 Replies

4. UNIX for Dummies Questions & Answers

Selective Replacements: Using sed or awk to replace letters with numbers in a very specific way

Hello all. I am a beginner UNIX user who is using UNIX to work on a bioinformatics project for my university. I have a bit of a complicated issue in trying to use sed (or awk) to "find and replace" bases (letters) in a genetics data spreadsheet (converted to a text file, can be either... (3 Replies)
Discussion started by: Mince
3 Replies

5. Shell Programming and Scripting

awk : match only the pattern string , not letters or numbers after that.

Hi Experts, I am finding difficulty to get exact match: file OPERATING_SYSTEM=HP-UX LOOPBACK_ADDRESS=127.0.0.1 INTERFACE_NAME="lan3" IP_ADDRESS="10.53.52.241" SUBNET_MASK="255.255.255.192" BROADCAST_ADDRESS="" INTERFACE_STATE="" DHCP_ENABLE=0 INTERFACE_NAME="lan3:1"... (6 Replies)
Discussion started by: rveri
6 Replies

6. Shell Programming and Scripting

Sorting mixed numbers and letters

Hello, I have a file such as this: chr1 chr2 chr1 chr2 chr3 chr10 chr4 chr5 chrz chr1AI want to sort it, I use this command: sort -k1 -th -n testfilebut I get this output, how can I fix this? chr1 chr1 chr10 chr1A chr2 chr2 (3 Replies)
Discussion started by: Homa
3 Replies

7. UNIX for Dummies Questions & Answers

sed - extract a group of Letters/numbers

I have a file with hundreds of lines in it. I wanted to extract anything that matches the following: KR followed by 4 digits: example KR1201 cat list | sed "s///g" Is the closest I've come, and obviously it is not what I want. This would remove all of the items that I want and leave me... (2 Replies)
Discussion started by: newbie2010
2 Replies

8. Shell Programming and Scripting

Reducing the decimal points of numbers (3d coordinates) in a file; how to input data to e.g. Python

I have a file full of coordinates of the form: 37.68899917602539 58.07500076293945 57.79100036621094 The numbers don't always have the same number of decimal points. I need to reduce the decimal points of all the numbers (there are 128 rows of 3 numbers) to 2. I have tried to do this... (2 Replies)
Discussion started by: crunchgargoyle
2 Replies

9. Shell Programming and Scripting

[FUN] Numbers to Roman letters/num

Heyas Just a little fun script (code block) i'd like to share for fun. #/bin/bash # roman.sh # # Function # num2roman() { # NUM # Returns NUM in roman letters # input=$1 # input num output="" # Clear output string len=${#input} # Initial length to count down ... (9 Replies)
Discussion started by: sea
9 Replies

10. UNIX for Beginners Questions & Answers

Decimal numbers and letters in the same collums: round numbers

Hi! I found and then adapt the code for my pipeline... awk -F"," -vOFS="," '{printf "%0.2f %0.f\n",$2,$4}' xxx > yyy I add -F"," -vOFS="," (for input and output as csv file) and I change the columns and the number of decimal... It works but I have also some problems... here my columns ... (7 Replies)
Discussion started by: echo manolis
7 Replies

LEARN ABOUT SUNOS

iconv_dhn

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

NAME

       iconv_dhn - code set conversion tables for DHN (Dom Handlowy Nauki)

DESCRIPTION

       The following code set conversions are supported:

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

CONVERSIONS

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

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

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |  ISO 8859-2	|     DHN	 |  ISO 8859-2	 |
       |24-177	       | 40		|222		 |40		 |
       |200	       | 241		|223		 |364		 |
       |201	       | 306		|224		 |366		 |
       |202	       | 312		|225-230	 |40		 |
       |203	       | 243		|231		 |326		 |
       |204	       | 321		|232		 |334		 |
       |205	       | 323		|233-237	 |40		 |
       |206	       | 246		|240		 |341		 |
       |207	       | 254		|241		 |355		 |
       |210	       | 257		|242		 |363		 |
       |211	       | 261		|243		 |372		 |
       |212	       | 346		|244-340	 |40		 |
       |213	       | 352		|341		 |337		 |
       |214	       | 263		|342-365	 |40		 |
       |215	       | 361		|366		 |367		 |
       |216	       | 363		|367		 |40		 |
       |217	       | 266		|370		 |260		 |
       |220	       | 274		|371-376	 |40		 |
       |221	       | 277		|		 |		 |
       +---------------+----------------+----------------+---------------+

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

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |    MS 1250	|     DHN	 |   MS 1250	 |
       |200	       | 245		|233-237	 |40		 |
       |201	       | 306		|240		 |341		 |
       |202	       | 312		|241		 |355		 |
       |203	       | 243		|242		 |363		 |
       |204	       | 321		|243		 |372		 |
       |205	       | 323		|244-251	 |40		 |
       |206	       | 214		|252		 |254		 |
       |207	       | 217		|253-255	 |40		 |
       |210	       | 257		|256		 |253		 |
       |211	       | 271		|257		 |273		 |
       |212	       | 346		|260-340	 |40		 |
       |213	       | 352		|341		 |337		 |
       |214	       | 263		|342-345	 |40		 |
       |215	       | 361		|346		 |265		 |
       |216	       | 363		|347-360	 |40		 |
       |217	       | 234		|361		 |261		 |
       |220	       | 237		|362-365	 |40		 |
       |221	       | 277		|366		 |367		 |
       |222	       | 40		|367		 |40		 |
       |223	       | 364		|370		 |260		 |
       |224	       | 366		|371		 |40		 |
       |225-230        | 40		|372		 |267		 |
       |231	       | 326		|373-376	 |40		 |
       |232	       | 334		|		 |		 |
       +---------------+----------------+----------------+---------------+

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

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |    MS 852	|     DHN	 |    MS 852	 |
       |200	       | 244		|212		 |206		 |
       |201	       | 217		|213		 |251		 |
       |202	       | 250		|214		 |210		 |
       |203	       | 235		|215		 |344		 |
       |204	       | 343		|216		 |242		 |
       |205	       | 340		|217		 |230		 |
       |206	       | 227		|220		 |253		 |
       |207	       | 215		|221		 |276		 |
       |210	       | 275		|222-375	 |40		 |
       |211	       | 245		|		 |		 |
       +---------------+----------------+----------------+---------------+

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

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |    Mazovia	|     DHN	 |   Mazovia	 |
       |200	       | 217		|212		 |215		 |
       |201	       | 225		|213		 |221		 |
       |202	       | 220		|214		 |222		 |
       |203	       | 234		|215		 |244		 |
       |204	       | 245		|216		 |242		 |
       |205	       | 243		|217		 |236		 |
       |206	       | 230		|220		 |246		 |
       |207	       | 240		|221		 |247		 |
       |210	       | 241		|222-247	 |40		 |
       |211	       | 206		|		 |		 |
       +---------------+----------------+----------------+---------------+

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