oracle United States
  • 13 years ago

    Hi All,

    I just have a small query for you guys.

    am reading a flat file from the FTP. And, am extracting the first 4 characters from the flat file.

    am using select SUBSTR(door.csv, 1,4)

    Do I have to write the directory name also, say the path or just the file name will do.


    Thanks a Million !!


Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Some people, when confronted with a problem, think "I know, I’ll use regular expressions." Now they have two problems.” - Jamie Zawinski