Please note that as a programmer I cannot tell the file format or details of my production files so I have re-framed my file and taken a case of departments. Kindly guide as its related to a production requirement of data containing recors of production customer NOT A HOMEWORK
I have a file containing details of different departments . Infomration of departments is in various tags
file is as below
Code:
DEPTNUM 1|
FACULTY 20|
STUDENTS 300|
COURSES 3|
DEPTNUM 2|
FACULTY 25|
STUDENTS 500|
COURSES 30|
DEPTNUM 3|
FACULTY 22|
STUDENTS 600|
COURSES 31|
AND SO ON
I want to create a new file from the above file which should contain only two fields belonging to one department
format
Code:
DEPTNUM,STUDENTS
1,50
2,500
3,600
There are multiple files containing department details of individiual college
I tried below
Code:
for file in `ls -1 pwd`
do
var1=`grep DEPTNUM $file |cut -c 9`
var2=`grep STUDENTS $file |cut -c 10-12`
done
However it did not serve my purpose and not giving expected result
Please suggest some alternative solution
Many thanks in advance
Last edited by Franklin52; 04-25-2010 at 10:17 AM..
Reason: Please indent your code and use code tags, thank you
I have a question:
Y X
Tabel a is a array multidimensional --> a(1024,20)
I load in to array a Text from 6000 row where:
in a(1,1) is present the row 1 of original text, in a(1024,1) is present then row 1024 of original test and in... (4 Replies)
I have a file like this
QUEUE: <ITEM(69)> "/NLA///ACHO_EQU_IDX"
Q_KEY: <ITEM(69)> "/NLA///ACHO_EQU_IDX"
Q_TYPE: <VSTR(32)> "GEN_VSTR_INDEX"
... (1 Reply)
Hi,
I have a file containing details of different departments . Infomration of departments is in various tags
file is as below
I want to create a new file from the above file which should contain only two fields belonging to one department
format
There are multiple files... (1 Reply)
Hi All,
i have log file sample data is
2010/10/09|04:00:00.392|15Minute|BW=0|192.168.0.1
2010/10/08|04:00:00.392|15Minute|BW=0|192.168.0.1
2010/10/07|04:00:00.392|15Minute|BW=0|192.168.0.1
2010/10/05|04:00:00.392|15Minute|BW=0|192.168.0.1
2010/10/03|04:00:00.392|15Minute|BW=0|192.168.0.1... (2 Replies)
ok im kinda stuck i have a bash script with 4 options
1. Create Script
2. Show Script
3 . Delete script
4. Exithow would i use an if statement for this? im not sure what test command i would use.
I know it would be like this (below) to display the script
if
then cat script1or for the... (10 Replies)
I have a script:
#!/bin/ksh
runmqsc CERN.PROD <<EOF
dis chs(to.*)
end
EOF
which gives me the output as:
1 : dis chs(to.*)
AMQ8417: Display Channel Status details.
CHANNEL(TO.CGPRODAPP2) CHLTYPE(CLUSRCVR)
CONNAME(10.60.16.50) CURRENT
... (5 Replies)
Hi,
I need some help taking a selection from a command and adding part of the output to an array.
I'd like to read the items into the array, have the user chose an option from the array and put the item from column 1 into a variable.
The command is:
awless -l list routetables --columns... (7 Replies)
Hi,
I would like to upgrade my AIX box 6.1 to 7.1/7.2.
Current info of my AIX 6.1 box
/ > oslevel -s
6100-09-11-1810
System Model: IBM,9117-MMD
Machine Serial Number: xxx
Processor Type: PowerPC_POWER7
Processor Implementation Mode: POWER 7
Processor Version: PV_7_Compat
Number Of... (10 Replies)
Discussion started by: Phat
10 Replies
LEARN ABOUT XFREE86
zgrep
ZGREP(1) General Commands Manual ZGREP(1)NAME
zgrep - search possibly compressed files for a regular expression
SYNOPSIS
zgrep [ grep_options ] [ -e ] pattern filename...
DESCRIPTION
Zgrep invokes grep on compressed or gzipped files. These grep options will cause zgrep to terminate with an error code:
(-[drRzZ]|--di*|--exc*|--inc*|--rec*|--nu*). All other options specified are passed directly to grep. If no file is specified, then the
standard input is decompressed if necessary and fed to grep. Otherwise the given files are uncompressed if necessary and fed to grep.
If the GREP environment variable is set, zgrep uses it as the grep program to be invoked.
EXIT CODE
2 - An option that is not supported was specified.
AUTHOR
Charles Levert (charles@comm.polymtl.ca)
SEE ALSO grep(1), gzexe(1), gzip(1), zdiff(1), zforce(1), zmore(1), znew(1)ZGREP(1)
04-25-2010
