HomeForum
Welcome, Guest

splitting file name
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: splitting file name

splitting file name 1 year, 2 months ago #1999

  • Bill
  • OFFLINE
  • Junior Boarder
  • Posts: 20
  • Karma: 0
Hello

I am using reader parameters to get source file name.

How can I split it further
eg. into drive file name and extension?

Biil

Re: splitting file name 1 year, 2 months ago #2000

  • admin
  • NOW ONLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Several possible options.

You can use use calculation object to get file name information
Have a look at pdf documentation
There are number of functions available

or you can use splitter

to get file extension set delimiter to dot
to get drive set delimiter to colon

to get file name use ensure no prefix function and set prefix to directory name

Peter
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

"This [Visual Importer ETL] is such a great help. As expected, it has paid for itself within one week!"

Phill Stive,
Oracle DBA, OU,
Newcaste

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top