01-15-2007
while loop DATA
I have a datafile contain:
1;n;b;c
2;n;b;c
3;n;b;c
4;n;b;c
5;n;b;c
6;n;b;c
7;n;b;c
8;n;b;c
9;n;b;c
10;n;b;c
My program code:
cnt=1
IFS=";"
while read a b c d; do
echo $a $b $c $d
done<datafile
My result:
1 n b c
2 n b c
3 n b c
4 n b c
5 n b c
6 n b c
7 n b c
8 n b c
9 n b c
10 n b c
My wanted-result
1 n b c list[1] row[1]
2 n b c list[1] row[2]
3 n b c list[1] row[3]
4 n b c list[1] row[4]
5 n b c list[1] row[5]
6 n b c list[2] row[1]
7 n b c list[2] row[2]
8 n b c list[2] row[3]
9 n b c list[2] row[4]
10 n b c list[2] row[5]
How can I modify my code to give me such data output? Thanks!
Row 1 to 5 is in list 1
Row 6 to 10 is in list 2
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have a problem with my loops. I have a file called users.dat, it has all the users in it. Then I extracted a list of users sending out number of mails with date from Netscape logs. The extracted list (mailuse.dat) has 3 fields: username, number of mails, date. (One user can show up several... (2 Replies)
Discussion started by: nitin
2 Replies
2. Shell Programming and Scripting
Hi All,
I am having trouble through, I am reading the input from tab delimited file containing several records,
e.g.
line1 field1 field2 field3 so on..
line2 field1 field2 field3 so on..
..
..
on the basis of certain fields for each record in input file, I have to retrieve... (1 Reply)
Discussion started by: Sonu4lov
1 Replies
3. Shell Programming and Scripting
Hi,
I have 5 files basically;namely file1.txt situated each at folder A to E respectively.
I would like to extract out third column from each of these file1.txt from folder A to folder E. Also, I wanted to extract the first and second column which are common. In other words, e.g
... (6 Replies)
Discussion started by: ahjiefreak
6 Replies
4. Shell Programming and Scripting
Hi all
I have two file that contain different data.I want to get each file data line by line in one loop.i try with cat but cat works ok against one file
File a
23
34
45
File b
abc
xyz
cgh
now i want like this in a loop.Below is just example.i am doing some thing smiler.can any... (3 Replies)
Discussion started by: aliahsan81
3 Replies
5. Shell Programming and Scripting
Hi, I have a file with the following data
-0.00000 0.00000 0.00000 F F F
0.00000 0.00000 0.80000 F F F
0.50000 0.50000 0.60000 F F F
0.50000 0.50000 0.20000 F F F
-0.00000 0.00000 0.40000 F F F
I would like to change the last 3 lines from F F F to T T T. I tried looping each line but don't... (5 Replies)
Discussion started by: princessotes
5 Replies
6. Shell Programming and Scripting
The script is following :
for each_rec in <file_name>
do
count=`cut -c -2 ${each_rec} | grep "45"`
echo ${count}
if ] then
amount=`cut -c 24-35 ${each_rec}`
echo ${amount}
else
echo "failed"
fi
done
And the file looks like below :
... (4 Replies)
Discussion started by: mady135
4 Replies
7. Shell Programming and Scripting
so this is what i want to do. i have data that looks like this:
DATA:
Array: A
Interface Type: SAS
Unused Space: 0 MB
Status: Failed
Logical Drive: 2
Size: 279.4 GB
Fault Tolerance: RAID 1
Heads: 255
Sectors Per Track: 32... (2 Replies)
Discussion started by: SkySmart
2 Replies
8. Shell Programming and Scripting
I need to graph data that's in a file. however, i only know of a way to graph data as it comes (meaning, as it is spat out by whatever process or job). i dont know how to graph data in a file.
im using rrdtool to graph data. and i was wondering if anyone know of a way to pass a file (the... (3 Replies)
Discussion started by: SkySmart
3 Replies
9. Shell Programming and Scripting
Good midday and hello to everyone! =)
If I describe some things wrong please be aware, that english is not my native language!! :D
I'm a bit stuck with a script I need to finish. Due to data protection I need to hide some paths but that should be no problem.
My script connects to a db2... (1 Reply)
Discussion started by: dsondermann
1 Replies
10. Shell Programming and Scripting
Change IP to multiple servers based on a database file. Source ip file is not incremental.
# Source host
#cat hosts
server1
server2
server3
server4
server5
server6
# SOURCE file
#cat ip
Host IP Netmask GW
server1 192.0.0.1 ... (2 Replies)
Discussion started by: invinzin21
2 Replies
LEARN ABOUT DEBIAN
rt-setup-database-4
rt-setup-database(8) Request Tracker Reference rt-setup-database(8)
NAME
rt-setup-database - Set-up the database for Request Tracker
SYNOPSIS
rt-setup-database --action ...
OPTIONS
action
Several actions can be combined using comma separated list.
init
Initialize the database. This is combination of multiple actions listed below. Create DB, schema, setup acl, insert core data and
initial data.
upgrade
Apply all needed schema/acl/content updates (will ask for version to upgrade from)
create
Create the database.
drop
Drop the database. This will ERASE ALL YOUR DATA.
schema
Initialize only the database schema
To use a local or supplementary datafile, specify it using the '--datadir' option below.
acl Initialize only the database ACLs
To use a local or supplementary datafile, specify it using the '--datadir' option below.
coredata
Insert data into RT's database. This data is required for normal functioning of any RT instance.
insert
Insert data into RT's database. By default, will use RT's installation data. To use a local or supplementary datafile, specify it
using the '--datafile' option below.
datafile
file path of the data you want to action on
e.g. "--datafile /path/to/datafile"
datadir
Used to specify a path to find the local database schema and acls to be installed.
e.g. "--datadir /path/to/"
dba dba's username
dba-password
dba's password
prompt-for-dba-password
Ask for the database administrator's password interactively
skip-create
for 'init': skip creating the database and the user account, so we don't need administrator privileges
root-password-file
for 'init' and 'insert': rather than using the default administrative password for RT's "root" user, use the password in this file.
perl v5.14.2 2013-05-22 rt-setup-database(8)