Sponsored Content
Top Forums Shell Programming and Scripting Parsing Comma Separated values to UNIX variable from PLSQL Post 303018906 by Mahesh3089 on Tuesday 19th of June 2018 01:48:12 AM
Old 06-19-2018
Parsing Comma Separated values to UNIX variable from PLSQL

Hi All,

I'm trying to pass the comma separated values (string) returned from Plsql Procedure to UNIX variable.

getting the below log message
Code:
cat: -: Bad file descriptor
awk: cmd. line:1: fatal: error reading input file `-': Bad file descriptor


The output coming from plsql procedure is abc@xyz.com,def@xyz.com,ghi@xyz.com and need this string to pass to the mail to address further in the code.

Below is the code.

Code:
LOG_FILE=$FCP_REQID.txt
echo 'Logfile is :'$LOGFILE
output_var=''
sqlplus -s /nolog  <<ENDSQL|grep -v 'Connected'>$LOG_FILE
connect $FCP_LOGIN
set feedback off
set heading off
set serveroutput on
declare
mavar1 varchar2(400);
begin
pack_list_print_pkg.get_cust_mail_address($param1,$param2,mavar1);
dbms_output.put_line('CUSTMAIL-ADDRESS'||mavar1);
end ;
/
ENDSQL
cat $LOG_FILE
customer_mail_address=`awk '/CUSTMAIL-ADDRESS/ {print $2}' $LOG_FILE`

echo 'customer mail address is :'||$customer_mail_address


Last edited by rbatte1; 06-19-2018 at 03:56 AM.. Reason: Added CODE & ICODE tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting comma separated values into an array

I'm attempting to create a KSH array out of a string like this: ",,,value1,value2,," I have created the array but I only get two elements, one for value1 and one for value2. I have ended up with something like this but I don't like it: set -A JUNK xx=0 for i in $(print ",,,value1,value2,,"... (3 Replies)
Discussion started by: tmarikle
3 Replies

2. Shell Programming and Scripting

Extracting the values separated by comma

Hi, I have a variable which has a list of string separated by comma. for ex , Variable=/usr/bin,/usr/smrshbin,/tmp How can i get the values between the commas separately using shell scripts.Please help me. Thanks, Padmini. (6 Replies)
Discussion started by: padmisri
6 Replies

3. Shell Programming and Scripting

Parsing Comma separated Arguments

Hi unix guru's I want to execute a shell script like ksh printdetails.ksh Andy,Bob,Daisy,Johnson like passing all the four names in the as the arguments and these arguments are varies between 1 to 10. How to pass these names to the shell script variable. and also i want to know the count... (4 Replies)
Discussion started by: Reddy482
4 Replies

4. Shell Programming and Scripting

parsing comma separated file

Hi, I have a file with th elist of patches separated by comma, like below: patch1, patch 2, patch 3................ t\The number of patches is not known as it changes every time. I need assistance in writing a routine such as it will take patch1 as first variable and performs the... (4 Replies)
Discussion started by: avikaljain
4 Replies

5. Shell Programming and Scripting

Parsing and filtering multiline text into comma separated line

I have a log file that contains several reports with following format. <Start of delimiter> Report1 header Report1 header continue Report1 header continue Record1 header Record1 header continue Record1 header continue field1 field2 field3 field4 ------... (1 Reply)
Discussion started by: yoda9691
1 Replies

6. Shell Programming and Scripting

To agregate Comma separated values

Hi pls help me to get the code: i have a file in which content is : 2.01304E+11 2.01304E+11 ori 2 01:00 2.01304E+11 2.01304E+11 ori 2 01:02 2.01304E+11 2.01304E+11 ori 3 01:02 2.01304E+11 2.01304E+11 ori 3 ... (7 Replies)
Discussion started by: Aditya.Gurgaon
7 Replies

7. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies

8. Shell Programming and Scripting

Needs help in parsing comma separated values

hello experts, i am retrieving values in variables jobKey and jobName within my shell script. these values are returned to me within braces and i am using following command to remove those braces: jobKeys=`echo $jobKeys | sed 's:^.\(.*\).$:\1:'` jobNames=`echo $jobNames | sed... (1 Reply)
Discussion started by: avikaljain
1 Replies

9. Shell Programming and Scripting

Comma separated values to individual lines

My OS : RHEL 6.7 I have a text file with comma separated values like below $ cat testString.txt 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', . . . . I want these values to appear like below 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', .... (4 Replies)
Discussion started by: kraljic
4 Replies

10. Shell Programming and Scripting

Assign comma separated values to a variable

Hi All, I wrote a database command that queries our application and outputs a whole bunch of values to a text file. I need to assign the output to two values. Here is a sample of the output: valueOne, checkOne valueTwo, checkTwo valueThree, checkThree I would like... (9 Replies)
Discussion started by: jeffs42885
9 Replies
MINCINFO(1)							 MINC User's Guide						       MINCINFO(1)

NAME
mincinfo - print out specified information about a minc file SYNOPSIS
mincinfo [<options>] <file> [<file> ...] DESCRIPTION
mincinfo will print out either a general description of a minc file (type, sign and range of data, plus a brief description of dimensions and their order), or specific information about dimensions, variables or attributes in the file. This program can be very useful for build- ing shell scripts that access minc files. All information given by mincinfo is presented as read from the file with no transformation. This means that start and step values, for example, are not in the world coordinate system. To display the start values for a file in world coordinates, use voxeltoworld. OPTIONS
Note that options can be specified in abbreviated form (as long as they are unique) and can be given anywhere on the command line. Dimen- sions, variables and attributes are all specified by name. Attributes are specified by variable:attribute where variable can be omitted to specify global attributes. More than one option can be specified, in which case the return value from each option is printed on a separate line (-image_info prints on many lines) in the order of the options on the command line. -image_info Print out the default general information about the file. This information includes the type, sign and range of the pixel data, the order of the dimensions, and a list of dimensions giving name, length, start and step for each one. -dimnames Print out a space-separated list of the dimensions in the file. -varnames Print out a space-separated list of the variables in the file. -dimlength dimension Print the length of the specified dimension. -vartype variable Print the type of the variable. -vardims variable Print a space-separated list of the dimensions that subscript the variable (in C order). -varatts variable Print a space-separated list of the attribute names for the specified variable. -varvalues variable Print a newline-separated list of the values of the specified variable. -atttype variable:attribute Print out the type of the specified attribute. -attvalue variable:attribute Print out a space-separated list of the values of the specified attribute. -error_string string Specifies a string to print out if an error occurs. This will cause the program to exit with normal status. The default is to print an appropriate error message and exit with an error status. -help Print summary of command-line options and abort. -version Print the program's version number and exit. EXAMPLES
Print out standard information about a minc file. mincinfo file.mnc Print out contents of global history attribute. mincinfo file.mnc -attvalue :history Print out step value for x dimension, setting the default value to 1. mincinfo file.mnc -attvalue xspace:step -error 1 Print out the step values for x, y and z, setting the default value to 1. mincinfo file.mnc -error 1 -attvalue xspace:step -attvalue yspace:step -attvalue zspace:step Print out the names of the dimensions subscripting the image variable. mincinfo file.mnc -vardims image AUTHOR
Peter Neelin COPYRIGHTS
Copyright (C) 1993 by Peter Neelin SEE ALSO
voxeltoworld(1) $Date: 2004-05-20 21:52:08 $ MINCINFO(1)
All times are GMT -4. The time now is 11:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy