HomeForum
Welcome, Guest
ETL-Forum
Forum
Advanced ETL Processor

Take out return characters in an Excel field from a file that I am loading into an Oracle table
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Take out return characters in an Excel field from a file that I am loading into an Oracle table

Take out return characters in an Excel field from a file that I am loading into an Oracle table 11 months, 1 week ago #2957

  • Andrew
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Karma: 0
Hi

I need to take out return characters in an Excel field from a file that I am loading into an Oracle table.

In the transformation package, can I use a Replace function and replace char(13) with a space?

Kind regards,
Andrew
Reply Quote

Re: Take out return characters in an Excel field from a file that I am loading into an Oracle table 11 months, 1 week ago #2958

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Use calculation transformation

There are some examples in the documentation

Mike
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Advanced ETL Processor
Powered by Kunena
Time to create page: 0.15 seconds

Testimonials

"I needed to integrate and automate disparate systems running different database platforms that speak different languages, even different flavors of SQL. Visual Importer products have become that common link for me."

Gene Kovacs,
Director of Technical Business Operations,
A2B

User Login

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



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top