HomeForum
Welcome, Guest
ETL-Forum
Forum
Visual Importer

Insert special character
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Insert special character

Insert special character 1 year, 2 months ago #1967

  • Manuel
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
Hello

Any recommendations on how to insert a special character like line feed into a row of an Oracle Table?

Thanks
Manuel
Reply Quote

Re: Insert special character 1 year, 2 months ago #1968

  • admin
  • NOW ONLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
use Chr() function to add special character

This is an example but AETL but it should work with VI as well

begin
Result:=[F001]+Chr(13)+[F002]
end;

Pit
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Visual Importer
Powered by Kunena
Time to create page: 0.15 seconds

Testimonials

"The DBSL Integration solution eliminated our data access bottle neck that previously impeded company growth. We are now able to provide solutions to long standing problems areas such as automated order processing and business reporting limitations. Additionally the solution allows for new opportunities to simply hook-on to our existing data sources. From development through testing the DBSL support  team continues to be helpful, resourceful and responsive to our company needs."

John Kil,
IT Manager

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