Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sed or awk Solution
Top Forums Shell Programming and Scripting sed or awk Solution Post 302903709 by kshitij on Thursday 29th of May 2014 06:26:05 AM
Old 05-29-2014
Wrench sed or awk Solution
Hi

I am having a csv file like this
Code:
ahsh,90.82,add,32424,ahha
hhdh,98.89,hdhdh,92728,neha
hshs,you,97.7,hdhdhd,are,a 
jsjsj,wonderful,9788,79.9,aheh
ahdh,95.5,girl, 2737,jolll

I need to add width="100" to the value which is greater than 90 like decimal points but less than 100

Code:
Output file 


ahsh,width="100" 90.82,add,32424,ahha
hhdh,width="100" 98.89,hdhdh,92728,neha
hshs,you,width="100" 97.7,hdhdhd,are,a 
jsjsj,wonderful,9788,79.9,aheh
ahdh,width="100" 95.5,girl, 2737,jolll

I tried to use this sed script

Code:
sed 's/[9][0-9]\.[0-9]*/width="100" [9][0-9]\.[0-9]*/g' file

But it is adding [9][0-9]\.[0-9]* to the prior numbers
Prior numbers I need as it is as shown in output file
Please help me out how to tackle this ?

Thanks
Kshitij
Last edited by Scott; 05-29-2014 at 08:04 AM.. Reason: Code tags for code too!
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Is There a Sed Solution for This?

Hi All, I'm trying to use sed to extract data within a String, but I'm having problems with sed command: Text: STATUS OSRC_R6_0_MENT_R1H_CU M_901662 R1H_LV1_20080313 Based from the Text above, I just need to extract this data R6_0 R1H_CU LV1 Is there a solution for this in... (1 Reply)
Discussion started by: racbern
1 Replies

2. Shell Programming and Scripting

Is there a awk solution for this??

I am writing a awk script that gathers certain data from certain fields. I needed a awk solution for this, because it will later become a function in the script. I have the following data that I need output on a single line, but record spans across multilple lines and records are not... (7 Replies)
Discussion started by: timj123
7 Replies

3. UNIX for Dummies Questions & Answers

Awk/sed solution for grep,cut

Hi, From the file "example" with lines like below, I need the int value associated with ENG , i.e, 123 SUB: ENG123, GROUP 1 SUB: HIS124, GROUP 1 .. .. Normally , i do grep ENG example | cut -d ' ' -f 2 | cut -c 4-6 Is it possible to do it in simpler way using awk/sed ? ... (5 Replies)
Discussion started by: priyam
5 Replies

4. Shell Programming and Scripting

sed solution for condition checking

Hi all , Recently i came across this in FAQ's. I have a file cat rem.txt sreedhar 20 sreedhar 10 sreedhar 15 sreedhar 18 sreedhar 16 sreedhar 30 I have to replace sreedhar with "Sridhar" if the second parameter is > 18. I need to do it in "sed" only. I am wondering how this... (4 Replies)
Discussion started by: panyam
4 Replies

5. Shell Programming and Scripting

Urgent solution for simple sed

Hi Im running this command on AIX in ksh. My input file samp1 contains 1 2 123 12345 When I execute the following sed i dont get a matching pattern sed -n '/{1}/p' samp1 Can anyone help me with this simple thing (3 Replies)
Discussion started by: raghav288
3 Replies

6. Shell Programming and Scripting

Awk solution

Hello! Well, I searched and wasn't able to find a specific example of my dilemma, so hopefully someone could assist? Or maybe there was an example but I missed it? I have two files: file1 = order data file file2 = list of 65,000+ order numbers I would like to extract from 'file1' any... (5 Replies)
Discussion started by: rm -r *
5 Replies

7. Shell Programming and Scripting

AWK or SED solution

Hello. I have big file data like this(part of file): .... 18210102021010000110 47401000000 021001 5166891.16 021011 5166891.16 18210602010020000110 47401000000 020701 8995421.00 021001 8995421.00 021011 8995421.00 030801 .08 18210604011020000110 47401000000 020701 9048.00 021001... (3 Replies)
Discussion started by: maxoff
3 Replies

8. Shell Programming and Scripting

sed to check two condition need solution

Hi, I am having a file in below format server-1 Win2008:server-1-1700,1774,290104720,290104987:server-1 server-2 AIX:server-2-:server-2 server-2 I want the output like this Win2008:server-1-1700,1774,290104720,290104987:standalon-server AIX:server-2-:VIO-Sever I used the... (7 Replies)
Discussion started by: ranjancom2000
7 Replies

9. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies

LEARN ABOUT DEBIAN

fieldlines

Really Slick ScreenSavers(1)				      General Commands Manual				      Really Slick ScreenSavers(1)

NAME

       fieldlines - simulation of the electric field lines between charged particles.

SYNOPSIS

       fieldlines [--root/-r] [--maxfps/-x number] [--vsync/-y number] [--dpms/-M number] [--ions/-i number] [--stepsize/-s number] [--maxsteps/-m
       number] [--width/-w number] [--speed/-S number] [--constwidth/-c] [--no-constwidth/-C] [--electric/-e] [--no-electric/-E]

DESCRIPTION

       From Terry Walsh (http://reallyslick.com): "This is a simulation of the electric field  lines  between  charged	particles.  Physics  never
       looked so good."

       Ported to Linux by Tugrul Galatali.

OPTIONS

       --root  Draw on the root window.

       --maxfps number
	       Set maximum frame rate.

       --vsync number
	       Limit redraws to specified number of vertical refreshes.  0 - 100.  Default: 1

       --dpms number
	       Stop rendering new frames if the display is not on.  0 - 1.  Default: 1

       --ions number
	       Number of ions.	1 - 100.  Default: 4

       --stepsize number
	       Step length along lines.  1 - 100.  Default: 15

       --maxsteps number
	       Max number of steps.  1 - 1000.	Default: 100

       --width number
	       Line width.  1 - 100.  Default: 30

       --speed number
	       Speed.  1 - 100.  Default: 10

       --constwidth
	       Constant line width.  Default: False

       --electric
	       Electric.  Default: False

ENVIRONMENT

       DISPLAY to get the default host and display number.

SEE ALSO

       X(1),

COPYRIGHT

       Copyright (C) 2002 by Terry Walsh and Tugrul Galatali.

       Fieldlines  is  free software; you can redistribute it and/or modify it under the terms of the GNU General Public License version 2 as pub-
       lished by the Free Software Foundation.

       Fieldlines is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of  MERCHANTABIL-
       ITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

AUTHOR

       Terry Walsh and Tugrul Galatali <tugrul@galatali.com>

X Version 11													      Really Slick ScreenSavers(1)
All times are GMT -4. The time now is 10:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy