Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Decimal numbers and letters in the same collums: round numbers
Top Forums UNIX for Beginners Questions & Answers Decimal numbers and letters in the same collums: round numbers Post 302988524 by RavinderSingh13 on Tuesday 27th of December 2016 01:31:43 PM
Old 12-27-2016
Hello echo manolis,

Could you please try following and let me know if this helps you.
Code:
awk -F, 'function check(var){var=var~/[[:digit:]]/?"%0.2f":(var~/[[:alpha:]]/?"%s":"");return var} {gsub(/[[:space:]]+,[[:space:]]+/,",",$0);a=check($2);b=check($4);printf(a "," b"\n",$2,$4)}' OFS=","   Input_file

Output will be as follows.
Code:
0.25,0.11
0.59,10.25
nd,8.46
10.46,n3d5
-12.46,-8.55

EDIT: Adding a non-one liner form of solution too successfully now.
Code:
awk -F, 'function check(var){
                                var=var~/[[:digit:]]/?"%0.2f":(var~/[[:alpha:]]/?"%s":"");
                                return var
                            }
                            {
                                gsub(/[[:space:]]+,[[:space:]]+/,",",$0);
                                a=check($2);
                                b=check($4);
                                printf(a "," b"\n",$2,$4)
                            }
        '    Input_file

Thanks,
R. Singh
Last edited by RavinderSingh13; 12-28-2016 at 02:16 PM.. Reason: Adding a non-one liner form of solution too successfully now.
 

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

decimal numbers

Hi friends How can I use "for loop" for decimal numbers? ex: 0.1 < x < 0.6 I used this commands but does'nt work. LIMIT=0.6 for ((x=0.1; x<=LIMIT; x++)) do - - - done Many thanks (1 Reply)
Discussion started by: snow
1 Replies

4. Shell Programming and Scripting

Regarding decimal numbers

Hello... I am new to unix and I am wondering if in a C-shell script , Are we supposed to use only whole numbers........ for example..if a program needs to calculate the average of some numbers........ @ avg = (($1 +$2 + $3)/3)) is returning a whole number.........How can a decimal be... (7 Replies)
Discussion started by: ravindra22
7 Replies

5. 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

6. Shell Programming and Scripting

reducing values in columns with both numbers and letters

Hi, I columns with both number and letters however i need the number 4 trimmed off the lines that have 3 numbers in them so it just because the 2 preceding numbers only For example V25QG2-K18QG-V25CG2 L26HG-L17HA-L26CG I434QD1-L19HB2-I434CD1 I434QD1-A31QB-I434CD1 ... (7 Replies)
Discussion started by: olifu02
7 Replies

7. 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

8. 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

9. 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

10. 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

LEARN ABOUT SUSE

xfs_estimate

xfs_estimate(8) 					      System Manager's Manual						   xfs_estimate(8)

NAME

       xfs_estimate - estimate the space that an XFS filesystem will take

SYNOPSIS

       xfs_estimate [ -h? ] [ -b blocksize ] [ -i logsize ]
		    [ -e logsize ] [ -v ] directory ...

DESCRIPTION

       For  each directory argument, xfs_estimate estimates the space that directory would take if it were copied to an XFS filesystem.  xfs_esti-
       mate does not cross mount points.  The following definitions are used:
	      KB = *1024
	      MB = *1024*1024
	      GB = *1024*1024*1024

       The xfs_estimate options are:

       -b blocksize
	      Use blocksize instead of the default blocksize of 4096 bytes.  The modifier k can be used after the number to  indicate  multiplica-
	      tion by 1024.  For example,

		   xfs_estimate -b 64k /

	      requests an estimate of the space required by the directory / on an XFS filesystem using a blocksize of 64K (65536) bytes.

       -v     Display more information, formatted.

       -h     Display usage message.

       -?     Display usage message.

       -i, -e logsize
	      Use  logsize instead of the default log size of 1000 blocks.  -i refers to an internal log, while -e refers to an external log.  The
	      modifiers k or m can be used after the number to indicate multiplication by 1024 or 1048576, respectively.

	      For example,

		   xfs_estimate -i 1m /

	      requests an estimate of the space required by the directory / on an XFS filesystem using an internal log of 1 megabyte.

EXAMPLES

       % xfs_estimate -e 10m /var/tmp
       /var/tmp will take about 4.2 megabytes
	       with the external log using 2560 blocks or about 10.0 megabytes

       % xfs_estimate -v -e 10m /var/tmp
       directory		     bsize   blocks    megabytes    logsize
       /var/tmp 		      4096	792	   4.0MB   10485760

       % xfs_estimate -v /var/tmp
       directory		     bsize   blocks    megabytes    logsize
       /var/tmp 		      4096     3352	  14.0MB   10485760

       % xfs_estimate /var/tmp
       /var/tmp will take about 14.0 megabytes

																   xfs_estimate(8)
All times are GMT -4. The time now is 02:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy