HomeForum
Welcome, Guest
ETL-Forum
Forum
Data Warehousing and Data integration

How to replace parts of string
(1 viewing) (1) Guest
Data Warehousing and Data integration
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: How to replace parts of string

How to replace parts of string 9 months, 1 week ago #3640

  • Tom
  • OFFLINE
  • Fresh Boarder
  • Posts: 3
  • Karma: 0
Hi,

I have the following issue.
In my source table I have a text field with content like '123.+.45.678.999'.
I have to replace the '123' and '678' with two other (fixed) values like 'AAA' and 'CC' so the result becomes 'AAA.+.45.CC.999'.

The problem is that the length of the strings aren't fixed so I cannot simply use the 'substring' function.

Hope someone has done this before and can help me!

Tomas
Reply Quote

Re: How to replace parts of string 9 months, 1 week ago #3641

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
This can be easily achieved by using combination of Splitter and Joiner

Have a look at attached screenshots

Peter
Attachments:
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Data Warehousing and Data integration
Powered by Kunena
Time to create page: 0.14 seconds

Testimonials

Advanced ETL Processor's ability to validate and tranform data without actually loading it into the datawarehouse has saved us a lot of time. We were able to see how data will look like, once it is transformed and which records would fail during data validation.

Antony Clark,
RBS 

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