How can i segregate?

Login or Register to Ask a Question and Join Our Community

How can i segregate?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How can i segregate?

01-02-2013

Registered User

177, 2

Join Date: Apr 2011

Last Activity: 8 December 2019, 10:36 AM EST

Location: Bangalore

Posts: 177

Thanks Given: 42

Thanked 2 Times in 2 Posts

How can i segregate?

I have this file which contains

Code:


Code:

91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,3.0,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,4.9,aML,en
91886,000,MiniC2-00,1.0,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en
91886,000,MiniC2-00,1.9.12,aML,en

I want to seggregate based on the 4th column i.e. if it is 1.0, 2.0, 3.0, 4.0 & 5.0 den i need to add a column with value S30 in between 3rd and 4th i.e. as shown below

91886,000,MiniC2-00,S30,1.0,aML,en

else add a column with value S40 in between 3rd and 4th i.e. as shown below
91886,000,MiniC2-00,S40,1.9.12,aML,en

nikhil jain

View Public Profile for nikhil jain

Find all posts by nikhil jain

01-02-2013

Registered User

1,650, 478

Join Date: Mar 2012

Last Activity: 11 September 2019, 8:06 AM EDT

Posts: 1,650

Thanks Given: 58

Thanked 478 Times in 474 Posts

Try

Code:

awk -F, '{if($4 ~ /^1\.0|2\.0|3\.0|4\.0|5\.0$/){sub($3,$3",S30")}else{sub($3,$3",S40")}}1' file

OR

Code:

awk -F, '{if($4 ~ /^1\.0|2\.0|3\.0|4\.0|5\.0$/){$3=$3",S30"}else{$3=$3",S40"}}1' OFS="," file

pamu

View Public Profile for pamu

Find all posts by pamu

01-02-2013

Registered User

7,747, 559

Join Date: Feb 2007

Last Activity: 20 April 2020, 11:28 AM EDT

Location: The Netherlands

Posts: 7,747

Thanks Given: 139

Thanked 559 Times in 520 Posts

EDIT: Misread the question

Last edited by Franklin52; 01-02-2013 at 07:41 AM..

Franklin52

View Public Profile for Franklin52

Find all posts by Franklin52

01-02-2013

Registered User

177, 2

Join Date: Apr 2011

Last Activity: 8 December 2019, 10:36 AM EST

Location: Bangalore

Posts: 177

Thanks Given: 42

Thanked 2 Times in 2 Posts

i did a mistake ...

I wanted the 3rd colum to be replaced....

sorry....

required o/p

Code:


Code:

91886,000,S40,1.9.12,aML,en

dont want this one

Code:


Code:

91886,000,MiniC2-00,S40,1.9.12,aML,en

---------- Post updated at 05:06 PM ---------- Previous update was at 05:03 PM ----------

Code:

set -x
>proper_file
while read line
do
echo $line
var=`echo $line|awk -F, '{print $4}'`
model=`echo $line|awk -F, '{print $3}'`
if [ "$var" = "1.0" -o "$var" = "2.0" -o "$var" = "3.0" -o "$var" = "4.0" -o "$var" = "5.0" ]
then
sed "s/$model/S30/g" >> proper_file
else
sed "s/$model/S40/g" >> proper_file
fi
done < normal.csv
~

thanks PAMU, frank & MYSELF

Last edited by Scott; 01-02-2013 at 08:41 AM.. Reason: Code tags

nikhil jain

View Public Profile for nikhil jain

Find all posts by nikhil jain

01-02-2013

Registered User

18, 3

Join Date: Mar 2012

Last Activity: 12 May 2016, 9:50 AM EDT

Posts: 18

Thanks Given: 1

Thanked 3 Times in 3 Posts

Try this one since it is one line

Code:

 awk -F, '{if($4 ~/1\.0|2\.0|3\.0|4\.0|5\.0/){$3="S30"}else{$3="S40"}1} OFS=","' file_name

senthilkumark

View Public Profile for senthilkumark

Find all posts by senthilkumark

01-02-2013

Registered User

509, 132

Join Date: Jul 2011

Last Activity: 24 September 2019, 9:48 AM EDT

Location: Chennai, India

Posts: 509

Thanks Given: 16

Thanked 132 Times in 127 Posts

Quote:

Originally Posted by nikhil jain

i did a mistake ...

I wanted the 3rd colum to be replaced....

sorry....

required o/p

Code:


Code:

91886,000,S40,1.9.12,aML,en

dont want this one

Code:


Code:

91886,000,MiniC2-00,S40,1.9.12,aML,en

---------- Post updated at 05:06 PM ---------- Previous update was at 05:03 PM ----------

Code:

set -x
>proper_file
IFS=','
while read col1 col2 var model other
do
if [ "$var" = "1.0" -o "$var" = "2.0" -o "$var" = "3.0" -o "$var" = "4.0" -o "$var" = "5.0" ]
then
sed "s/$model/S30/g" >> proper_file
else
sed "s/$model/S40/g" >> proper_file
fi
done < normal.csv
~

thanks PAMU, frank & MYSELF Smilie

Smilie

Use shell built-in whenever possible since it will reduce processing time.

Cheers,
Ranga

---------- Post updated at 09:07 AM ---------- Previous update was at 08:55 AM ----------

Quote:

Originally Posted by senthilkumark

Try this one since it is one line

Code:

 awk -F, '{if($4 ~/1\.0|2\.0|3\.0|4\.0|5\.0/){$3="S30"}else{$3="S40"}1} OFS=","' file_name

$4 - will match even '11.0' or '1.03' something like that. So if you want to be more specific match or more accurate. You should use like below,

Code:

 awk -F, '{if($4 ~/^1\.0$|^2\.0$|^3\.0$|^4\.0$|^5\.0$/)......

Cheers,
Ranga

rangarasan

View Public Profile for rangarasan

Find all posts by rangarasan

01-03-2013

Registered User

2,759, 420

Join Date: Jun 2006

Last Activity: 13 September 2015, 8:58 PM EDT

Posts: 2,759

Thanks Given: 44

Thanked 420 Times in 408 Posts

Code:

awk '{$3=($4~/^[1-5]\.0/)?"S30":"$40"}1' FS=, OFS=, infile

Last edited by rdcwayx; 01-03-2013 at 10:17 PM..

rdcwayx

View Public Profile for rdcwayx

Find all posts by rdcwayx

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to segregate a section from big file?

Hello, I need to know all IP range (ip_prefix), associated with us-west-2 region only from this link - https://ip-ranges.amazonaws.com/ip-ranges.json (it can be opened in wordpad for better visibility) Please suggest, how would I do it. If vi, awk or sed is needed, I have downloaded it on my...

2. Shell Programming and Scripting

Need help in awk: running a loop with one column and segregate data 4 each uniq value in that field

Hi All, I have a file like this(having 2 column). Column 1: like a,b,c.... Column 2: having numbers. I want to segregate those numbers based on column 1. Example: file. a 5 b 9 b 620 a 710 b 230 a 330 b 1910

3. Shell Programming and Scripting

Segregate files based on the time they are created

Hi All, I have scenario where I need to zip huge number of DB audit log files newer than 90 days and delete anything older than that. If the files are too huge in number,zipping will take long time and causing CPU spikes. To avoid this I wanted to segregate files based on how old they are and...

4. UNIX for Advanced & Expert Users

Segregate file content using sed backreference

I have some text like EU1BTDAT:ASSGNDD filename='$SEQFILES/SUNIA.PJ008202.CARDLIB/DATECARD' EU1BTDATEST:ASSGNDD filename='$SEQFILES/SUNIA.PJ008202.CARDLIB/DATECARD' EU1CLOSEDATES:ASSGNDD filename='$SEQFILES/SUNIA.PJ008202.CARDLIB/DATECARD' EU1DATED:ASSGNDD...

5. Shell Programming and Scripting

Segregate by suffixed file names using Korn Shell

I have following files at /dir1 a.csv.20131201 b.csv.20131201 c.csv.20131201 d.csv.20131201 a.csv.20131202 b.csv.20131202 c.csv.20131202 d.csv.20131202 ....................... ....................... ....................... ....................... I need to move these files to...

6. Shell Programming and Scripting

Segregate alpha and digits

I have a variable containing values like 10d2, 7a7, a8 or d6 (i.e. <digits><alpha><digits>. Out of these leading digits may not be there. Out of this, I want three variables. The first having value Inital digits, the second one will be alpha and the third will be trailing digits. (In the previous...

7. Shell Programming and Scripting

Segregate a number from a String in the log

Hi, I have below lines in the log file. how to segregate and assign '3904' to a variable. XCMM018I Return Code: 8 Feedback: 0 :&PNUM=3904:

8. Shell Programming and Scripting

Unix script to segregate dynamic and static content of a web application

I need to deploy a JAVA application on two separate servers: 1. Web server (IBM HTTP Web Servers (IHS)) 2. Application Server (WebSphere Application Server WAS7.0) The static content will have to be deployed and handled on Web server. These would include GIFs, HTML, CSS, etc files....

9. Shell Programming and Scripting

segregate the file based on matching patterns

print 'test' SETUSER 'dbo' go create proc abc as /Some code here/ go SETUSER go print 'test1' SETUSER 'dbo' go Create Procedure xyz as /some code here/ go SETUSER go print 'test2' SETUSER 'dbo'

Login or Register to Ask a Question