Who's Online

Subscription

RSS Feeds List RSS Feeds List

Top Developers


Patryk Szczypien
Created the CurrentTimestamp function

Proud Sponsor of

Membership


SourceForge.net Logo
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 1 year ago

Created By: Ludmila Radzevich (Ludmila)

File Size: 10.84 Kb

Views: 883

Downloads: 54

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