11-02-2010
Quote:
Originally Posted by
mady135
If I am commenting out the previous line, the next date getting formatted like this. That means, every second date record fetch is getting formatted with an unwanted space.
Please provide me a solltion.
Just an observation: the additional blank char is at position 80, which is the default line width for many programs. Maybe it is just a "line break in disguise" and you could get rid of it by adjusting the "size" of the "virtual paper" you are printing to.
I am not sure which SQL client you are using, in Oracles SQLPLUS this is done with "SET LINESIZE <n>" (line width) and "SET PAGESIZE <n>" (number of lines before page break), IIRC.
I hope this helps.
bakunin
This User Gave Thanks to bakunin For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a shell scripting. This will take 7 digit number in each line and add 7 digit number with next subsequent lines ( normal addition ).
Eg:
0000001
0000220
0001235
0000022
0000023
...........
.........
........
Like this i am having around 1500000 records. After adding... (23 Replies)
Discussion started by: thambi
23 Replies
2. Shell Programming and Scripting
How to remove any space around a specific charachter from a string using sed.
for exmple :
the string is like following
str1='"name", "roll", "addr","job", "pay",'
I need to remove all the spaces aronnd the commas. (8 Replies)
Discussion started by: mady135
8 Replies
3. Shell Programming and Scripting
Hello,
I am developing a platform Independant tool that should work for all major unix flavors outlined in this forum(Solaris,Linux, AIX, HPUX, SCO,BSD)
Therefore, in order to cover all types of user community, I have deliberately posted the same message on every forum. Please do not think... (9 Replies)
Discussion started by: darsh123
9 Replies
4. Shell Programming and Scripting
Hi All,
I have written a grep command to grep the files containing Windows directories.
I need to output this to a csv.
So here is the code.
OUTPUT_FILE="Sample-format.txt"
ACT_OUTPUT_FILE="Sample-format.csv"
grep -wHrnI --exclude=*.log ':\{1,2\}*\{1,2\}*'... (0 Replies)
Discussion started by: flamingo_l
0 Replies
5. Shell Programming and Scripting
Hello everyone, I'm in need of some assistance. I'm currently enrolled in an introductory UNIX shell programming course and, well halfway through the semester, we are receiving our first actual assignment. I've somewhat realized now that I've fallen behind, and I'm working to get caught up, but for... (1 Reply)
Discussion started by: MrMagoo22
1 Replies
6. Windows & DOS: Issues & Discussions
Oracle Linux 5.6 x-86-64 (Red Hat derivitive)
I have several shell scripts that capture output to a log file, then use that log file as the source of an email. For a very simplified example:
echo Today is `date` >> $logfile
/bin/mail -s "$subject" "$sendto" < $logfile
(yes, $subject... (6 Replies)
Discussion started by: edstevens
6 Replies
7. Shell Programming and Scripting
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Discussion started by: G.K.K
7 Replies
8. Solaris
Hi,
I am using log4j syslog appender to redirect the application logs to the solaris syslog.
However, I am facing issue in formatting. It is not able to interpret new line characters and is printing \n as it is.
Ex: Following is getting written into the syslog file.
"\n \n File =... (4 Replies)
Discussion started by: Pra
4 Replies
9. Shell Programming and Scripting
When i execute the below shell script with 2 different Input files, for one of the data files (datafile1) my email message body in the outlook messes up and every thing comes up in one line. May i please know what i am doing wrong here or how to fix this? The only difference in data files is one is... (1 Reply)
Discussion started by: Ariean
1 Replies
10. Shell Programming and Scripting
Hi, I am new to UNIX and need your help in formatting the below input command to the desire output
Input:
CREATE UNIQUE INDEX XPKTABLE1
(
COL1,
COL2
) ON TABLE_NM;
Output:
COMMENT ON TABLE DB_NM.TABLE_NM AS 'PK=,COL1,COL2; ';
In... (14 Replies)
Discussion started by: varun2327
14 Replies
is a text formatter. Its input consists of the text to be out-
put, intermixed with formatting commands. A formatting command
is a line containing the control character followed by a two
character command name, and possibly one or more arguments. The
control character is initially . (dot). The formatted output is
produced on standard output. The formatting commands are listed
below, with being a number, being a character, and being a title.
A + before n means it may be signed, indicating a positive or
negative change from the current value. Initial values for where
relevant, are given in parentheses.
.ad Adjust right margin.
.ar Arabic page numbers.
.br Line break. Subsequent text will begin on a new line.
.bl n Insert n blank lines.
.bp +n Begin new page and number it n. No n means +1.
.cc c Control character is set to c.
.ce n Center the next n input lines.
.de zz Define a macro called zz. A line with .. ends definition.
.ds Double space the output. Same as .ls 2.
.ef t Even page footer title is set to t.
.eh t Even page header title is set to t.
.fi Begin filling output lines as full as possible.
.fo t Footer titles (even and odd) are set to t.
.hc c The character c (e.g., %) tells roff where hyphens are permitted.
.he t Header titles (even and odd) are set to t.
.hx Header titles are suppressed.
.hy n Hyphenation is done if n is 1, suppressed if it is 0. Default is 1.
.ig Ignore input lines until a line beginning with .. is found.
.in n Indent n spaces from the left margin; force line break.
.ix n Same as .in but continue filling output on current line.
.li n Literal text on next n lines. Copy to output unmodified.
.ll +n Line length (including indent) is set to n (65).
.ls +n Line spacing: n (1) is 1 for single spacing, 2 for double, etc.
.m1 n Insert n (2) blank lines between top of page and header.
.m2 n Insert n (2) blank lines between header and start of text.
.m3 n Insert n (1) blank lines between end of text and footer.
.m4 n Insert n (3) blank lines between footer and end of page.
.na No adjustment of the right margin.
.ne n Need n lines. If fewer are left, go to next page.
.nn +n The next n output lines are not numbered.
.n1 Number output lines in left margin starting at 1.
.n2 n Number output lines starting at n. If 0, stop numbering.
.ni +n Indent line numbers by n (0) spaces.
.nf No more filling of lines.
.nx f Switch input to file f.
.of t Odd page footer title is set to t.
.oh t Odd page header title is set to t.
.pa +n Page adjust by n (1). Same as .bp
.pl +n Paper length is n (66) lines.
.po +n Page offset. Each line is started with n (0) spaces.
.ro Page numbers are printed in Roman numerals.
.sk n Skip n pages (i.e., make them blank), starting with next one.
.sp n Insert n blank lines, except at top of page.
.ss Single spacing. Equivalent to .ls 1.
.ta Set tab stops, e.g., .ta 9 17 25 33 41 49 57 65 73 (default).
.tc c Tabs are expanded into c. Default is space.
.ti n Indent next line n spaces; then go back to previous indent.
.tr ab Translate a into b on output.
.ul n Underline the letters and numbers in the next n lines.