| text data to excel file [message #606767] |
Wed, 29 January 2014 03:45  |
 |
m.abdulhaq
Messages: 254
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
[Updated on: Wed, 29 January 2014 14:37] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: text data to excel file [message #606849 is a reply to message #606836] |
Thu, 30 January 2014 00:17  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
