Who's Online

We have 142 guests online

Subscription

RSS Feeds List RSS Feeds List

Top Developers


Patryk Szczypien
Created the CurrentTimestamp function

Proud Sponsor of

Main Repository Page arrow Business Productivity

Replacing a part of a field value       >>

Try It / Edit It

DataMap Description:

You can use this datamap when you need to replace a definite part of one fields value with the value of another field. For example, you have records like:

Field1     Field2
123n&asd     qwerty
adfk&ndr     asdfg
87df&wer     zxcvb

and you need to replace eveything you have before & in Field1 with the valuesfrom Field2. The resulting records will be qwerty&asd, asdfg&ndr, and zxcvb&wer.

If needed you can replace part of Field1 value with a PART of Field2 value by mapping RegExp function to Field2 and entering a proper regular expression to it. Some examples of regular expressions can be found at http://www.apatarforge.org/forums/viewtopic.php?p=877#877



Updated: about 2 years ago

Created By: Ludmila Radzevich (Ludmila)

File Size: 10.84 Kb

Views: 1548

Downloads: 65

Tags: Custom Table, RegExp

Rating: stars/0.gifTotal Votes:0

Note: Try It/Edit DataMap requires Apatar Data Mashup installation

Be the first to comment! Please sign in or register.


Add Comment:

Name (required)
Comment (required)
Verification code:
 
 
  Terms and Conditions Privacy Policy Contact Info Comments and Suggestions ETL News