Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: SED inside while loop
Top Forums UNIX for Dummies Questions & Answers SED inside while loop Post 302369969 by paoie on Tuesday 10th of November 2009 05:01:58 AM
Old 11-10-2009
SED inside while loop
Hi,


im having problem creating a loop using my code: aside from the fact that the 1st variable (VAR) does not increment, it loops more than the expected output.

for sample purposes, test csv contains 3 lines.

Code:
 
#get number of lines in the file
 lines=$( wc -l < test.csv )
 
  VAR=1
  VAR2=1
 while [ $VAR -le $lines+1 ]
 do
 while [ $VAR2 -le $lines+1 ]
 do
      sed "s/,,/,one"$VAR"too"$VAR2",/" test.csv > test1.csv 
      VAR2=$(( $VAR2 + 1 ))
  done
 
  VAR=$(( $VAR + 1 ))
 
 done

Output of the code is like this, this is caused by the sed command, its like the script executes first the sed command then the loop:

Code:
 
a,b,c,d,e,one1too1,f
a,b,c,d,e,one1too1,f
a,b,c,d,e,one1too1,f
a,b,c,d,e,one1too2,f
a,b,c,d,e,one1too2,f
a,b,c,d,e,one1too2,f
a,b,c,d,e,one1too3,f
a,b,c,d,e,one1too3,f
a,b,c,d,e,one1too3,f
a,b,c,d,e,one1too4,f
a,b,c,d,e,one1too4,f
a,b,c,d,e,one1too4,f

But the output should be:

Code:
a,b,c,d,e,one1too1,f
a,b,c,d,e,one1too2,f
a,b,c,d,e,one1too3,f
a,b,c,d,e,one1too4,f

i hope i explained and posted this question appropriately...

Hope someone could help..really appreaciate it.. thanks!
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

remsh inside of while loop

I have a space delimited file containing: hostname OracleSID connectstring I want to loop through the file and execute remsh to check the database processes. cat $filename | while read HOST SID CONNECT do { result=`remsh $HOST "ps -ef | grep pmon_${SID}$| grep -v grep"` if ........ (1 Reply)
Discussion started by: joettacm
1 Replies

2. Shell Programming and Scripting

variable inside variable inside loop headache

Hi Gurus I have a file called /tmp/CMDB which looks like this serial: 0623AN1208 hostname: server1 model: x4100 assetID: 1234 I am writing a for loop that will go through this file line by line creating a variable of itself. Using the first iteration of the loop (i.e. the first line) as... (6 Replies)
Discussion started by: hcclnoodles
6 Replies

3. Shell Programming and Scripting

Using variables created sequentially in a loop while still inside of the loop [bash]

I'm trying to understand if it's possible to create a set of variables that are numbered based on another variable (using eval) in a loop, and then call on it before the loop ends. As an example I've written a script called question (The fist command is to show what is the contents of the... (2 Replies)
Discussion started by: DeCoTwc
2 Replies

4. Shell Programming and Scripting

Using 'su' inside a loop

Hi, I am using su within a for loop. As you might expect, it prompts for password during each loop execution. Here is my piece of code: for i in $LIST do if then DATABASE=`echo $i | awk -F "|" '{ print $1 }'` USER_ID=`echo $i | awk -F "|" '{ print $2 }'` su - apstage -c... (1 Reply)
Discussion started by: sugan
1 Replies

5. Shell Programming and Scripting

Need help using sed inside the loop.

Hi, i have written a script. it collects data based on the sql queries executed by it. i have multiple output files. after the output file is made i need to do some cosmetic changes in the files and then store them. i am unable to use sed conditions inside the loop. see below code for... (3 Replies)
Discussion started by: dazdseg
3 Replies

6. Shell Programming and Scripting

BASH loop inside a loop question

Hi all Sorry for the basic question, but i am writing a shell script to get around a slightly flaky binary that ships with one of our servers. This particular utility randomly generates the correct information and could work first time or may work on the 12th or 100th attempt etc !.... (4 Replies)
Discussion started by: rethink
4 Replies

7. Shell Programming and Scripting

sed inside sed for replacing string

My need is : Want to change docBase="/something/something/something" to docBase="/only/this/path/for/all/files" I have some (about 250 files)xml files. In FileOne it contains <Context path="/PPP" displayName="PPP" docBase="/home/me/documents" reloadable="true" crossContext="true">... (1 Reply)
Discussion started by: linuxadmin
1 Replies

8. Shell Programming and Scripting

help using EOF inside a for loop

I'm having problems with this example: #!/bin/bash for i in server1 server2 server3 do ssh $i <<EOF >> logfile.txt dat1=`date '+%m/%d/%y'` hst=`hostname` df -Ph | awk -v OFS=',' -v dat="$dat1,$hst" ' {print dat,$1,$6,$3,$4 } ' exit EOF done I'm... (1 Reply)
Discussion started by: kuliksco
1 Replies

9. Shell Programming and Scripting

If inside If loop

Hi All, Below is the very simple code snippet but it si giving me syntax error #!/bin/bash #To ensure If JMS directory exists or not ServerName=$(hostname) #To ensure If JMS directory exists or not echo $ServerName if ; then echo "Inside First If" if ; then echo 'JMS... (4 Replies)
Discussion started by: sharsour
4 Replies

10. UNIX for Dummies Questions & Answers

Write a while loop inside for loop?

I'm taking a unix class and need to countdown to 0 from whatever number the user inputs. I know how to do this with a while or until loop but using the for loop is throwing me off.... I know I can use an if-then statement in my for loop but can I include a while loop in my for loop? (3 Replies)
Discussion started by: xxhieixx
3 Replies

LEARN ABOUT DEBIAN

cvm-sql

cvm-sql(7)						 Miscellaneous Information Manual						cvm-sql(7)

NAME

       cvm-sql - CVM SQL Framework

QUERY SUBSTITUTION

       $VAR  and  ${VAR} are replaced with the quoted value of the environment variable named VAR.  Use the second form when VAR contains anything
       other than alpha-numeric or underscore (_) characters.  Do not include quotes in the query.  The variables account and domain  contain  the
       account and domain names given by the CVM client.  $$ is replaced with a single dollar sign.

QUERY RESULTS

       The query must produce the following fields exactly in order.  All required fields must not be null or empty.

       1.     Password, encrypted with crypt(3) (required)

       2.     Actual account name (required)

       3.     User ID (integer) (required)

       4.     Group ID (integer) (required)

       5.     Directory (required)

       6.     Real name (optional)

       7.     Login shell (optional)

       8.     Group name (optional)

       9.     Domain name (optional)

       10.    System account name (optional)

       11.    System account directory (optional)

       12.    Mailbox path (optional)

DEFAULT QUERY

       SELECT  password, username, userid, groupid, directory, realname, shell, groupname, domain, sys_username, sys_directory FROM accounts WHERE
       username=$account AND domain=$domain

SEE ALSO

       cvm-mysql(8), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8),  cvm-test-
       client(8)

	http://untroubled.org/cvm/cvm.html

																	cvm-sql(7)
All times are GMT -4. The time now is 04:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy