Home » RDBMS Server » Server Utilities » text data to excel file (Oracle 10g)
text data to excel file [message #606767] Wed, 29 January 2014 03:45 Go to next message
m.abdulhaq
Messages: 125
Registered: April 2013
Location: Ajman
Senior Member
Dear Experts ,

i used to see and wonder that most of VB and C# developers have a tool or routine by which they can read bulk of text files and import its content into excel file , can i do the same using oracle , i know there is one way of doing it using sqlloader but its tedious process and i can read one file at a time. What i want is i will put 10 text files in one folder and if i specify the path , the system will read its content and generate for me and excel file . for example the contents of the text file is given below.




--content of text file 


ST
** 2003.nc1
  5010      -1281057
  1
  2003
  2003
  A36
  1
  H244*175*7*11
  I
    9000.00
     244.00
     175.00
      11.00
       7.00
      13.00
     43.600
      1.152
      0.000
      0.000
      0.000
      0.000




AK
  v       0.00s      0.00       0.00       0.00       0.00       0.00       0.00
       9000.00       0.00       0.00       0.00       0.00       0.00       0.00
       9000.00     203.43     -29.99       0.00       0.00       0.00       0.00
       8975.00     222.00       0.00       0.00       0.00       0.00       0.00
       9000.00     222.00       0.00       0.00       0.00       0.00       0.00
       9000.00     235.00       0.00       0.00       0.00       0.00       0.00
       8991.00     244.00       0.00       0.00       0.00       0.00       0.00
          0.00     244.00       0.00       0.00       0.00       0.00       0.00
          0.00     222.00       0.00       0.00       0.00       0.00       0.00
         25.00     222.00     -29.99       0.00       0.00       0.00       0.00
          0.00     203.43       0.00       0.00       0.00       0.00       0.00
          0.00       0.00       0.00       0.00       0.00       0.00       0.00
AK
  o       0.00s      0.00       0.00       0.00       0.00       0.00       0.00
          0.00     175.00       0.00       0.00       0.00       0.00       0.00
       9000.00     175.00       0.00       0.00       0.00      45.00       2.00
       9000.00       0.00       0.00       0.00       0.00       0.00       0.00
          0.00       0.00       0.00       0.00       0.00       0.00       0.00
AK
  u       0.00s      0.00       0.00       0.00       0.00       0.00       0.00
       9000.00       0.00       0.00       0.00       0.00       0.00       0.00
       9000.00     175.00       0.00       0.00       0.00       0.00       0.00
          0.00     175.00       0.00       0.00       0.00       0.00       0.00
          0.00       0.00       0.00       0.00       0.00       0.00       0.00
SI
  o 8000.00s   87.50    0.00 004  5010      -1281057-2003
BO
  u      35.00s     35.00      23.00
  u      35.00s    140.00      23.00
  u     105.00s     35.00      23.00
  u     105.00s    140.00      23.00
  u    8895.00s     35.00      23.00
  u    8895.00s    140.00      23.00
  u    8965.00s     35.00      23.00
  u    8965.00s    140.00      23.00
BO
  v      35.00o     87.00      23.00
  v      35.00o    157.00      23.00
  v     105.00o     87.00      23.00
  v     105.00o    157.00      23.00
  v    8895.00o     87.00      23.00
  v    8895.00o    157.00      23.00
  v    8965.00o     87.00      23.00
  v    8965.00o    157.00      23.00
EN

[mod-edit: bb added ending code tag]

the contents of the excel file is given as image.

first line starts from head7
./fa/11647/0/./fa/11647/0/

[Updated on: Wed, 29 January 2014 14:37] by Moderator

Report message to a moderator

Re: text data to excel file [message #606828 is a reply to message #606767] Wed, 29 January 2014 15:05 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
post is OFF Topic since neither source of data nor destination of the data has anything to do with Oracle database.
Re: text data to excel file [message #606836 is a reply to message #606828] Wed, 29 January 2014 21:53 Go to previous messageGo to next message
m.abdulhaq
Messages: 125
Registered: April 2013
Location: Ajman
Senior Member
thanks blackswan , but where i can get my answer for this type of query
Re: text data to excel file [message #606849 is a reply to message #606836] Thu, 30 January 2014 00:17 Go to previous message
Littlefoot
Messages: 19651
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It appears that you work (and know) Oracle only (and don't know anything about other programming languages); is that correct? Because, you are trying to solve a problem (which is OK) using a wrong tool (which is wrong).

You have bunch of text files and want to convert them into Excel files, right? So, what does Oracle have to do with it? Besides, you mentioned SQL*Loader as an appropriate tool. How come? It is used to load data, nothing more than that. As you are familiar with Oracle PL/SQL, you can then read information stored into that table and create Excel output.

Anyway: to cut a long story short: if my very first sentence is correct, then there's two of us - I don't know much about anything but Oracle so I can't assist (sorry about that). I just think that THIS job shouldn't involve Oracle. What it should involve? You mentioned Visual Basic and C# so - try to ask people who use them.
Previous Topic: Batch job running slow
Next Topic: EXPDP Error - ORA-39127,ORA-00942,ORA-06512
Goto Forum:
  


Current Time: Thu Oct 02 04:39:07 CDT 2014

Total time taken to generate the page: 0.10281 seconds