Search Results

Hi Yoda,

Thanks. But the output actually looks like:
CS123|0||5897|QXCYN87876
As it displays, there is a missing data field |0| :- CS123|0|0|
Also, if the text field contains say QXCYN87876...

Hello All,

I have a pipe delimited file and below is a sample data how it looks:
CS123 | | || 5897 | QXCYN87876
As stated above, the delimited files contains sometimes only spaces as data ...

Thanks for the advise. Yeahh..It seems I really cant run both the inserts and the function in the same file and expect my script to catch the ref cursor returned by the function. Actually I was...

Apologies if this is the incorrect forum.There is an issue in the function call I am facing while calling the same from a unix shell scripts.
Basically, I want the ref cursor to return values to a...

The total data created was around 1.2 million

For scenario wherein the file has around 20 million records and size is around 3 GB, the split kept on running for more than 10 minutes and hence I had to close the session as this benchmark was...

Thanks. The command works fine. Just one thing.It takes really huge time to split a file say for size 3 GB. Is there a workaround for this? And just a small correction - Changed n=20000000 to...

I have a huge file (around 4-5 GB containing 20 million rows) which has text like:

<EOFD>11<EOFD>22<EORD>2<EOFD>2222<EOFD>3333<EORD>3<EOFD>44<EOFD>55<EORD>66<EOFD>888<EOFD>9999<EORD>

Actually...

Thanks Corona688...but the code isn't working. I can still see some spaces between fileds in the file. Below is the reference sample:

457<EOFD>Mar 1 2007 12:00:00:000AM<EOFD>Mar 31 2007...

Yeahh..it works..but just one thing..the whitespace between system and <EORD> remains: "system <EORD>". Actually except the first line, <EORD> defines start of a new row in the file so basically its...

Thanks Corona688..Just to confirm, my files are like below:
1. Each field delimited by <EOFD>
2. The marker for a new row is <EORD> . I think since <EORD> marks the end of a line, can you suggest...

Thanks Corona688..Is there any workaround for this? I am currently trying to split the files into smaller chunks and try it. But that requires an effort as my file is delimited file and I have to...

I am trying to remove whitespaces from a file containing sample data as:
457 <EOFD> Mar 1 2007 12:00:00:000AM <EOFD> Mar 31 2007 12:00:00:000AM <EOFD> system <EORD> 458 <EOFD> Mar 1 2007...