06-03-2002
try this
hi
u can get ur file to unix server by ftp..
then open ur flat data file in vi editor n then replace all commas by some other char like ( | pipe) or something else whichever oracle sql loader recognises..
the comma replace command in vi editor is
press Esc then
:%s/,/|/g (then enter) which shall replace all the occurences of commas by ur selected character (pipe in the above eg.)
I hope this will possibly solve ur problem
bye
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Discussion started by: handynas
5 Replies
2. Shell Programming and Scripting
Hi Guys,
I am trying to reading in comma seperated values in awk. I can set the delimiter to be a comma, but the tricky part is that commas that appear within quotes are not to be considered as delimiters. Could someone please help.
Regards,
Laud (1 Reply)
Discussion started by: Laud12345
1 Replies
3. Shell Programming and Scripting
Hi,
I have a comma seperated list of values:
export list="red,blue,white,yellow"
Given a value in a variable "look", i want to check whether the value is available in the above list. But the result should be based on exact string match and not part of the string.
I am using following... (9 Replies)
Discussion started by: brap45
9 Replies
4. Shell Programming and Scripting
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies
5. Shell Programming and Scripting
Hi,
I want to remove empty/blank lines from comma seperated and space seperated files
Thanks all for help (11 Replies)
Discussion started by: pinnacle
11 Replies
6. Shell Programming and Scripting
Hi,
I have data like this.
1,2,3,4
Output required:
1
2
3
4
I am trying to use tr function but getting error.
Help is appreciated. (6 Replies)
Discussion started by: pinnacle
6 Replies
7. Shell Programming and Scripting
i want to run update query for oracle which is in up.sql taking values from a.csv.
I have implemented shell script to do it.
extn="perl"
ls -1 | while read file
do
echo "$file,$extn" > a.csv
done
up.sql contains
update file_list set filename=$1 where extn=$2;
The code to update is... (2 Replies)
Discussion started by: millan
2 Replies
8. UNIX for Dummies Questions & Answers
Hi have a comma separated file which has numeric and string columns. String columns are quoted and can have comma in between the quotes. How to identify the columns with FS =","
sample records"prabhat,kumar",19,2000,"bangalore,India"
In awk it should be$1 = prabhat,kumar
$2=19
$3=2000... (9 Replies)
Discussion started by: prabhat.diwaker
9 Replies
9. Shell Programming and Scripting
Hi All,
I am new to shell scripting i am trying to convert the listner.log to csv which can be inturn converted to excel for easy reading.
i used this command
awk '/SID=/ && /HOST=/ && /PORT=/ && /USER=/ {
i=match($0,"SID="); i=i+RLENGTH; h0=substr($0,i);
i=match(h0,")");... (6 Replies)
Discussion started by: skoshekay
6 Replies
10. Shell Programming and Scripting
Experts.
I have created a oracle table as below.
create table xml_tab
(
File_No number ,
File_content Varchar2(2000),
file_type xmltype
);
Daily we are receiving many XML files as below.
here is our sample xml file.
File1 : (7 Replies)
Discussion started by: vasuvv
7 Replies
LEARN ABOUT DEBIAN
cgiwrap_init_emu
cgiwrap_init_emu(3) cgi/cgiwrap.h cgiwrap_init_emu(3)
NAME
cgiwrap_init_emu - initialize cgiwrap for emulated use
SYNOPSIS
#include <cgi/cgiwrap.h>
void cgiwrap_init_emu (void *data, READ_FUNC read_cb,
WRITEF_FUNC writef_cb, WRITE_FUNC write_cb, GETENV_FUNC getenv_cb,
PUTENV_FUNC putenv_cb, ITERENV_FUNC iterenv_cb);
ARGUMENTS
data - user data to be passed to the specified callbacks
read_cb - a cb to replace fread(stdin)
writef_cb - a cb to repalce fprintf(stdout)
write_cb - a cb to replace fwrite(stdout)
getenv_cb - a cb to replace getenv
putenv_cb - a cb to replace putenv
iterenv_cb - a cb to replace the default environment iteration
function (which just wraps walking the envp array)
DESCRIPTION
cgiwrap_init_emu sets up the cgiwrap subsystem for use in an emulated environment where you are providing routines to use in place of the
standard routines, ie when used to interface with a server or scripting language. See cgi/cgiwrap.h for the exact definitions of the call-
back functions.
RETURN VALUE
None
SEE ALSO
cgiwrap_iterenv(3), cgiwrap_putenv(3), cgiwrap_init_emu(3), cgiwrap_writef(3), cgiwrap_init_std(3), cgiwrap_writevf(3), cgiwrap_read(3),
cgiwrap_write(3), cgiwrap_getenv
ClearSilver 12 July 2007 cgiwrap_init_emu(3)