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
curl_global_init_mem
curl_global_init_mem(3) libcurl Manual curl_global_init_mem(3)
NAME
curl_global_init_mem - Global libcurl initialisation with memory callbacks
SYNOPSIS
#include <curl/curl.h>
CURLcode curl_global_init_mem(long flags,
curl_malloc_callback m,
curl_free_callback f,
curl_realloc_callback r,
curl_strdup_callback s,
curl_calloc_callback c );
DESCRIPTION
This function works exactly as curl_global_init(3) with one addition: it allows the application to set callbacks to replace the otherwise
used internal memory functions.
This man page only adds documentation for the callbacks, see the curl_global_init(3) man page for all the rest. When you use this function,
all callback arguments must be set to valid function pointers.
The prototypes for the given callbacks should match these:
void *malloc_callback(size_t size);
To replace malloc()
void free_callback(void *ptr);
To replace free()
void *realloc_callback(void *ptr, size_t size);
To replace realloc()
char *strdup_callback(const char *str);
To replace strdup()
void *calloc_callback(size_t nmemb, size_t size);
To replace calloc()
CAUTION
Manipulating these gives considerable powers to the application to severly screw things up for libcurl. Take care!
SEE ALSO
curl_global_init(3), curl_global_cleanup(3),
libcurl 7.12.0 10 May 2004 curl_global_init_mem(3)