| |
|
|
| |
|
Who's Online
We have 2 guests online
|
Main Repository Page
Other Categories
Replacing part of a field value  >> Try It / Edit It  RSS| 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 month ago
Created By: Ludmila Radzevich (Ludmila)
File Size: 10.84 Kb
Views: 229
Downloads: 16
Tags: RegExp, regular expression, replace
Rating:  Total Votes:0
| |
Note: Try It/Edit DataMap requires Apatar Data Mashup installation Be the first to comment! Please sign in or register.Add Comment:
|
|
|
|
|
|
Privacy Policy