05-21-2009
Maybe I didn't make it clear. The thing is that each column means answer in questionaire. Each column begins with number of question. There are some questions that could have more than one answer, than there are more columns. I'm intrested in question 1 (column 1) and question 33 (which column number is changing) that is why I would like to print the columns that begin with '33='
10 More Discussions You Might Find Interesting
1. Web Development
Hi,
If i give a number say "1234" the output of mysql query should be:
one thousand and twenty four
How to write mysql query for this?
With regards
Vanitha (5 Replies)
Discussion started by: vanitham
5 Replies
2. Shell Programming and Scripting
Hi all,
Please some help over here. I have a Sales.txt file containing info in blocks for
every sold product in the pattern showed below (only for 2 products).
NEW BLOCK
SALE DATA
PRODUCT SERIAL
79833269999 146701011945004
.Some other data
.Some... (17 Replies)
Discussion started by: cgkmal
17 Replies
3. Shell Programming and Scripting
Hi,
I have to write a shell script that converts numbers in to words
below is what i wrote.My script is not running.
-----------------------------------
echo -n "Enter number : "
read n
len= echo $n | wc -c
echo " number in words : "
for ( i=1; i<len; i++ )
do
num=echo $n... (5 Replies)
Discussion started by: bab123
5 Replies
4. Shell Programming and Scripting
Hi all.
Am using the below command to get the database size for past two days..
grep total * |awk '{print $9/1024}'
560.746
1260.336
Now i want to see only the size in GB's which means i need to avoid the words from (.dot) and the output should come like below:
560
1260 (3 Replies)
Discussion started by: suri.tyson
3 Replies
5. UNIX for Dummies Questions & Answers
Hello Everyone, (1 Reply)
Discussion started by: thankful123
1 Replies
6. Shell Programming and Scripting
pls help
Input:
file1
word1
text1
word2
text2
word3
text3
file2
word1
text11
word3
text13
can u pls help in getting the same
output:
file1 text1 text2 text3 (1 Reply)
Discussion started by: bha148
1 Replies
7. Shell Programming and Scripting
Hi,
Sorry in advance for propably a silly question, but I am a bit lost.
On some of the linux job flow I have the following check:
if ($file != 1500) then
echo ERROR
It works ok, all times $file is not equal to 1500 I have the error message.
I try to do something similar... (7 Replies)
Discussion started by: essemario
7 Replies
8. UNIX for Dummies Questions & Answers
Hi. I have a file containing words and numbers associated with them as follows -
c 2
b 5
c 5
b 6
a 10
b 16
c 18
a 19
b 21
c 27
a 28
b 33
a 76
a 115
c 199
c 251
a 567
a 1909 (4 Replies)
Discussion started by: maq
4 Replies
9. Shell Programming and Scripting
Hi All,
I tried to solve this but the result gives me all zeros for one file. I failed to do for all 500 files.
I have some 500 files with the extension .dat I have another set of files; 500 in number with extension .dic I created these .dic files by using sort -u from the actual .dat files.... (2 Replies)
Discussion started by: shoaibjameel123
2 Replies
10. Shell Programming and Scripting
Hi All,
I have a file which looks like this:
abc 1
abc 2
abc 3
abc 4
abc 5
bcd 1
bcd 3
bcd 3
bcd 5
cde 7
This file is just a miniature version of what I really have. Original file is some 1 million lines long.
I have tried to come up with the code for what I wish to accomplish... (1 Reply)
Discussion started by: shoaibjameel123
1 Replies
PSC(1) General Commands Manual PSC(1)
NAME
psc - prepare sc files
SYNOPSIS
psc [-fLkrSPv] [-s cell] [-R n] [-C n] [-n n] [-d c]
DESCRIPTION
Psc is used to prepare data for input to the spreadsheet calculator sc(1). It accepts normal ascii data on standard input. Standard out-
put is a sc file. With no options, psc starts the spreadsheet in cell A0. Strings are right justified. All data on a line is entered on
the same row; new input lines cause the output row number to increment by one. The default delimiters are tab and space. The column for-
mats are set to one larger than the number of columns required to hold the largest value in the column.
OPTIONS
-f Omit column width calculations. This option is for preparing data to be merged with an existing spreadsheet. If the option is not
specified, the column widths calculated for the data read by psc will override those already set in the existing spreadsheet.
-L Left justify strings.
-k Keep all delimiters. This option causes the output cell to change on each new delimiter encountered in the input stream. The
default action is to condense multiple delimiters to one, so that the cell only changes once per input data item.
-r Output the data by row first then column. For input consisting of a single column, this option will result in output of one row
with multiple columns instead of a single column spreadsheet.
-s cell
Start the top left corner of the spreadsheet in cell. For example, -s B33 will arrange the output data so that the spreadsheet
starts in column B, row 33.
-R n Increment by n on each new output row.
-C n Increment by n on each new output column.
-n n Output n rows before advancing to the next column. This option is used when the input is arranged in a single column and the
spreadsheet is to have multiple columns, each of which is to be length n.
-d c Use the single character c as the delimiter between input fields.
-P Plain numbers only. A field is a number only when there is no imbedded [-+eE].
-S All numbers are strings.
-v Print the version of psc
SEE ALSO
sc(1)
AUTHOR
Robert Bond
PSC 7.16 19 September 2002 PSC(1)