Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 2 years ago. Improve this question i want to call a shell scripts which has sed command in it to format the xyz.csv generated by this shell. SED gets unrecognised in

Unable to use SED command [closed]

i want to call a shell scripts which has sed command in it to format the xyz.csv generated by this shell. SED gets unrecognised in this code

Answer

You can’t use sed inside sqlplus. So add this command after the EOF marker. Ans also use the variable for input filename

#!/bin/bash
FILE="xyz.csv"
sqlplus -s ---sqlconnection-- <<EOF
set pagesize 50000
set linesize 32767
set head on
set underline off
set trimspool on
set colsep '|'
set feedback off
set trims on
set trim on
set wrap off
set newpage none
set trimout on
COLUMN a FORMAT A20
COLUMN b FORMAT A20
COLUMN C FORMAT A20
COLUMN d
COLUMN e FORMAT
SPOOL $FILE
select * from xyz;
SPOOL OFF
SET TERMOUT on
EXIT
EOF
sed 's/ *| */|/g' $FILE >> output.csv

JavaScript
​x
 
#!/bin/bashFILE="xyz.csv"sqlplus -s ---sqlconnection-- <<EOFset pagesize 50000set linesize 32767set head onset underline offset trimspool onset colsep '|'set feedback offset trims onset trim onset wrap offset newpage noneset trimout onCOLUMN a FORMAT A20COLUMN b FORMAT A20COLUMN C FORMAT A20COLUMN dCOLUMN e FORMATSPOOL $FILEselect * from xyz;SPOOL OFFSET TERMOUT onEXITEOFsed 's/ *| */|/g' $FILE >> output.csv​

Advertisement

Answer