Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: format of output is weird
Top Forums Shell Programming and Scripting format of output is weird Post 302343835 by cesarNZ on Thursday 13th of August 2009 07:08:35 PM
Old 08-13-2009
format of output is weird
hi all,
have a ksh script which connects to a database and runs a sql and dumps it to a '.csv' file. The problem is the result is in multiple rows with long spaces in between when it should be just a single line and this screws up the format in the '.csv' file.

script is :

Code:
#!/bin/ksh
export SQLPLUS=/appl/oracle/product/9.2.0.4.64/client/bin/sqlplus;
export mydate=`/usr/bin/date +%d%m%Y_%H_%M`;

$SQLPLUS -s $1/$2@$3<<EOF

set head off
set feedback off
set lines 300
set pages 300

spool out_$mydate.csv

 SELECT 'name ', ',',
        'Number', ',',
        'Name', ',',
        'name', ',',
        'Product', ',',
        'Product ID', ',',
        'Product Name', ',',
        'Date'
 from dual;

SELECT  (users.FIRST_NAME || ' ' || users.LAST_NAME) || ',',
              users.TNUMBER || ',',
              cam.CAMPAIGN_NAME || ',',
              team.TEAM_TITLE || ',',
              pSales.PRODUCT_TYPE_ID || ',',
              pSales.PRODUCT_ID || ',',
              product.PRODUCT_NAME || ',',
              pSales.UPDATED_DT
FROM tables names
WHERE ...... ;
spool off
EOF


this script is meant to write out the heading i.e the first select and then put data under those headers but since the data has long spaces in it, the format is messed up.

This is what gets written out to the '.csv' file :


name , Number , Name , name, Product , Product ID , Product Name , Date

sys admin, t12345,
my plan 08,
Administrators, 3, 1005,

myproduct, 12-AUG-09


when i was expecting to see :


name , Number , Name , name, Product , Product ID , Product Name , Date

sysAdmin, t12345,my plan 08, Administrators, 3, 1005, myproduct, 12-AUG-09


so all data would be a single row in the 'csv' file rather then multiple rows in different columns with large spaces.

any suggestions ???

thanks.
 

10 More Discussions You Might Find Interesting

1. AIX

Weird bootlist output

just setup a new system today - 9117 570, using HMC for console but not partitioned. I installed this system twice. the first time it started off as 5300-00, then updated to ML03. before the update, I believe I mirrored the rootvg, and then altered the bootlist, at that point, the display was... (4 Replies)
Discussion started by: davew1099
4 Replies

2. Shell Programming and Scripting

weird echo output?

#!/bin/bash INPUT=$1 if then INPUT=0$1 TRACKNUMBER=$INPUT fi TRACKNUMBER=$INPUT echo "Track Number:" $TRACKNUMBER if then echo "File Does Not Exist!: split-track"${TRACKNUMBER}".wav" exit 0 fi CUEFILE="$2" (6 Replies)
Discussion started by: TinCanFury
6 Replies

3. UNIX for Dummies Questions & Answers

weird 'ls' output

Hi, Anyone knows why I can't display the contents of my directory and how to fix this? http://i50.tinypic.com/4smfth.jpg Thanks in advance for any advise. Deanne Double post. Continued here. (0 Replies)
Discussion started by: Deanne
0 Replies

4. Shell Programming and Scripting

In bash getting weird output from function ?

My script- result="" times() { echo "inside the times function" result=8 echo "Inside function $result" return $result } result=$(times) echo "the value is "$? echo "the value of result $result" when I run I get this, why the value still remain 0. $ ./func the value is 0 the value... (5 Replies)
Discussion started by: boy18nj
5 Replies

5. Shell Programming and Scripting

Find files older than X with a weird file format

I have an issue with a korn shell script that I am writing. The script parses through a configuration file which lists a heap of path/directories for some files which need to be FTP'd. Now the script needs to check whether there are any files which have not been processed and are X minutes old. ... (2 Replies)
Discussion started by: MickAAA
2 Replies

6. Shell Programming and Scripting

Traceroute script weird output

This script is giving weird output #!/bin/bash NETPATH=(`/bin/traceroute -n 4.2.2.2 | awk '{print $2}'`) for i in "${NETPATH}" do echo $i done The output: to 11.11.11.1 1.1.1.1 99.111.208.2 traceroute_test.sh traceroute_test.sh (7 Replies)
Discussion started by: thumbs
7 Replies

7. Shell Programming and Scripting

Weird tail output over ssh

Hello; Am trying to correct the formatting of tail output over ssh. Using the following code: echo "" > $FILE for BOX in $SERVERS do echo "Processing on $BOX" |tee -a $FILE echo "===============================" >> $FILE sudo ssh $BOX 'TERMINAL="vt100" /usr/bin/sh -s' <... (2 Replies)
Discussion started by: delphys
2 Replies

8. HP-UX

[Solved] Weird 'ls -l' output

Hello folks, I've found an HP-UX server with a rare 'ls -l' output. Please see the attached file. Anybody knows how can I change the output to not have this extra tabulations? Thanks in advance! (10 Replies)
Discussion started by: carpannav
10 Replies

9. UNIX for Advanced & Expert Users

Weird output from ps command

Hi Guys, I am regular Solaris user. I came across a weird problem that puzzled me. Hope you guys can help. I found that process's state(command & arguments) in two different variants of ps command is different. Can anyone explain how is this possible? bash-3.2$ ps -eLo pid,s,comm,args |... (2 Replies)
Discussion started by: brij123
2 Replies

10. Shell Programming and Scripting

Grep two files: -F flag gives weird output

Hi Members, I'm confused with grep -F option. Goal is to get all the lines from file2 that have exact gene name from gene list (file one). File one has list of genes: File two has lot more information pertinent to genes in file one: I use three following commands: 1) grep -wf gene... (9 Replies)
Discussion started by: genome
9 Replies

LEARN ABOUT DEBIAN

owx

OWX(1)							      General Commands Manual							    OWX(1)

NAME

       owx - utility to program Wouxun dual-band handheld radios

SYNOPSIS

       owx-check [ -v | -h ] [ -f ] [ -p <port> ] [ -t <timeout> ]
       owx-get [ -v | -h ] [ -f ] [ -p <port> ] [ -t <timeout> ] -o <path>
       owx-put [ -v | -h ] [ -f ] [ -p <port> ] [ -t <timeout> ] -i <path> -r <path>
       owx-export [ -v | -h ] -i <bin path> -o <csv path>
       owx-import [ -v | -h ] -i <csv path> -o <bin path>

DESCRIPTION

       This manual page documents briefly the owx commands.

       owx  is	a set of commands that will allow you to fetch and update configuration on your Wouxun handheld radio. It is made of multiple com-
       mands.

COMMON OPTIONS

       These options are common to all commands.

       -h     Show summary of options.

       -v     Show version of program.

       -c <command>
	      Invoke owx-<command>. Makes sense only if called directly as owx.

OPTIONS FOR check, get AND put
       -f     Force operation even if your radio identifies different from a KG669V.  Use this option with extreme caution - it is  very  possible
	      that your radio will be rendered unusable after you use this. It was NEVER tested with any radio different from mentoined above.

       -p <port>
	      Use port <port>, defaults to /dev/ttyUSB0. Of course you must have appropriate read and write permissions for this device.

       -t <timeout>
	      Specify  the receive timeout for communication with radio. If you disable it (by setting to 0) and the communication fails, the pro-
	      gram will hang forever. You probably don't need to change the default value (5 seconds).

USAGE

       owx-check
	      This program just checks for the connection and identification string. It can be used to check that your cable and port works.

       owx-get
	      This program downloads memory map from radio to binary file.

	      Options:

	      -o <path>: binary file to write to

       owx-put

	      This program uploads memory map from binary file to radio.

	      Options:

	      -i <path>: binary file to read from
	      -r <path>: reference file

	      Option -r is not mandatory, but recommended. You can specify original, unchanged file (exactly as downloaded using owx-get) and this
	      will  speed  up  memory  uploading, as owx will compare input file to this reference file and upload only changed memory pages. When
	      using this option, be sure that nothing has changed in the radio (even the currently selected memory  channel)  between  downloading
	      reference  file and using it for upload. This is important as some variables that cross the page boundaries (if there are any in the
	      memory map) could be corrupted by this.

	      Example:

	      owx-get -o file.bin
	      cp file.bin backup.bin
	      owx-export -i file.bin -o wouxun.csv
	      oocalc wouxun.csv
	      owx-import -i wouxun.csv -o file.bin
	      owx-put -i file.bin -r backup.bin

	      Please do yourself a favour and double-check that you upload the correct file. If you try to upload  incorrect  or  corrupted  file,
	      your radio will power down and fail to power up. owx will refuse to upload any file with incorrect size, but this is the only safety
	      check.

       owx-export

	      This program exports channel data from binary file to CSV file. This file can be later edited using your favourite spreadsheet  edi-
	      tor or even text editor.

	      Options:

	      -i <path>: binary file to read from
	      -o <path>: csv file to write to

       owx-import

	      This program reads the specified, possibly edited by you CSV file, and patches existing binary file with this updated data. The file
	      is now prepared to be uploaded with owx-put.

	      Options:

	      -i <path>: csv file to read from

	      -o <path>: binary file to write to (must already exist)

SEE ALSO

       chirp(1), the README file.

AUTHOR

       owx was written by SP5GOF (Adam Wysocki).

       This manual page was written by Antoine Beaupre <anarcat@debian.org>, for the Debian project (and may be used by others).

								 October 26, 2011							    OWX(1)
All times are GMT -4. The time now is 11:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy