11-11-2008
Adding a footer to a flat file
I wanted to know if there is a way to add a footer to a flat file that is being extracted by a sql query. so if the query extracts 1000 rows, in the flat file it appends the last line as 1000.
Is there a way to do so?
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I need to chope the header and footer record from an input file and make a new output file, please let me know how i can do it in unix.thanks. (4 Replies)
Discussion started by: coolbudy
4 Replies
2. Shell Programming and Scripting
I have one large file, after every 200 line i have to split the file and the add header and footer to each small file?
It is possible to add different header and footer to each file? (1 Reply)
Discussion started by: ashish4422
1 Replies
3. Solaris
I am running Solaris 10 and have been asked to create a footer for all emails that go from the server. I have been looking around but no dice. I am not sure how complicated or easy it is to do it.
Our system generates emails every night and then sends them out to different people on the list. We... (0 Replies)
Discussion started by: Sucio
0 Replies
4. Shell Programming and Scripting
Hi,
I have more than 30,000 records in a flat file. I want to remove footer from the file by searching a string pattern for the footer.
Example.... let the flat file test.dat contains below records.
record1
record2
record3
..
..
..
record31000
Total records 31000
I want to remove the... (6 Replies)
Discussion started by: gani_85
6 Replies
5. Shell Programming and Scripting
I am having report file with header and footer . The details in between header and footer are separated by a pipe charater. I want to sort the file by considering multiple columns in between header and footer.
pls help (4 Replies)
Discussion started by: suryanarayana
4 Replies
6. Shell Programming and Scripting
This is my file(Target.txt)
name|age|locaction
abc|23|del
xyz|24|mum
jkl|25|kol
The file should be like this
1|03252012
1|name|age|location
2|abc|23|del
2|xyz|24|mum
2|jkl|25|kol
2|kkk|26|hyd
3|4
Column 1 is row indicator
for row 1 and 2, column indicator is 1,for data rows... (1 Reply)
Discussion started by: itsranjan
1 Replies
7. Shell Programming and Scripting
Hi,
I need a ksh script for the below requirement:
i have a Delimited flat file with 200 records delimiter is '|~|'
i need a script to insert space at the end if the record is ending with delimiter '|~|'
if it didnt end with delimiter it should not append space.
Example: ram|~|2|~| ... (16 Replies)
Discussion started by: srikanth_sagi
16 Replies
8. Shell Programming and Scripting
Hi Every one,
what is the coomand to remove header or footer from a file.
Please help me by providing command/syntax to remove header/footer from unix.
Thanks in advance for all your support. (5 Replies)
Discussion started by: sridhardwh
5 Replies
9. Shell Programming and Scripting
currently I've a file
Insert into CD_CARD_TYPE
(CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE)
Values
('024', '024', 2, sysdate);
Insert into CD_CARD_TYPE
(CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE)
Values
('032', '032', 2, sysdate);
........
is it... (3 Replies)
Discussion started by: jediwannabe
3 Replies
10. UNIX for Dummies Questions & Answers
Is there any command to eliminate Header and footer from EBCDIC file (4 Replies)
Discussion started by: abhilashnair
4 Replies
LEARN ABOUT DEBIAN
numm.one-bit-instrument
one-bit-instrument(7) Numm Tutorials one-bit-instrument(7)
NAME
one bit instrument - how to make a gnarly synth with numm-run
SYNOPSIS
numm-run FILE
DESCRIPTION
In this tutorial we will learn how to live-code a one-bit synthesizer controlled by mouse position. It is intended as a gentle introduc-
tion to development with numm-run.
To get started, create a text file with the following method stubs:
def audio_out(a):
pass
def video_out(a):
pass
Save the file as onebit.py, and then launch it with numm-run:
numm-run onebit.py
You should see a blank window appear. We will now make some sound and light by changing the value of a in the audio_out and video_out
functions:
def audio_out(a):
a[::100] = 2**15
def video_out(a):
a.flat[::100] = 255
Save the file, and you should see and hear the sketch update. This is using numpy's array-indexing to turn every hundredth audio sample
and pixel-color on. The audio sample rate is by default 44100Hz, so it produces a series of clicks that will be perceived as a 441Hz tone.
We can turn this into an instrument by connecting mouse motion to frequency:
period = 100
def audio_out(a):
a[::period] = 2**15
def video_out(a):
a.flat[::period] = 255
def mouse_in(type,px,py,button):
global period
period = px*1000
Finally, let's use the keyboard to record and jump to notes. The first time you press a key, it records the period, and subsequant depres-
sions play the saved period:
period = 100
record = {}
def audio_out(a):
a[::period] = 2**15
def video_out(a):
a.flat[::period] = 255
def mouse_in(type,px,py,button):
global period
period = px*1000
def keyboard_in(type,key):
global period
if record.has_key(key):
period = record[key]
elif record.has_key(key):
record[] = period
SEE ALSO
numm-run(1), numm.getting-started(7), numm.spectral-analysis(7)
numm February 2012 one-bit-instrument(7)