Who's Online

We have 1 guest and 2 members online

Subscription

RSS Feeds List RSS Feeds List

Top Developers


Patryk Szczypien
Created the CurrentTimestamp function

Proud Sponsor of

Main Repository Page

RegExp




Replacing a part of a field value (Business Productivity)
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 Field2123n&asd qwertyadfk&ndr asdfg87df&wer zxcvband 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
stars/0.gifTotal Votes:0
Updated:
about 9 years ago
Comments: 57Downloads: 109
Views: 34860
Try It/Edit It
10.84 Kb


CSV file to Salesforce where one of the fields is split into several fields using RegExp function (Business Management)
This DataMap is designed to split one complex data field into four different fields using the RegExp function (Regular Expressions).
stars/0.gifTotal Votes:0
Updated:
about 9 years ago
Comments: 140Downloads: 177
Views: 26269
Try It/Edit It
40.38 Kb

Converting phone format (Business Management)
This datamap helps to re-format a field value to the correct one as per user request (http://www.apatarforge.org/forums/viewtopic.php?t=459&start=0) by using RegExp functions.
stars/0.gifTotal Votes:0
Updated:
about 9 years ago
Comments: 158Downloads: 185
Views: 20970
Try It/Edit It
47.23 Kb

Split field year (Business Management)
You have a filed with year like 19000116. This datamap converts it to 1900-01-16 by using RegExp function. (per Marek (Apatar donator) request http://www.apatarforge.org/forums/viewtopic.php?t=462&start=0)
stars/0.gifTotal Votes:0
Updated:
about 9 years ago
Comments: 114Downloads: 54
Views: 86333
Try It/Edit It
15.83 Kb

Regexp example (Business Productivity)
This sample will help you reformat particular column strings using the RegExp function.
stars/0.gifTotal Votes:0
Updated:
about 8 years ago
Comments: 29Downloads: 84
Views: 4686
Try It/Edit It
18.44 Kb




Get response number with help of RegExp function (Business Management)
as per user request (http://www.apatarforge.org/forums/viewtopic.php?t=578&start=0)
stars/0.gifTotal Votes:0
Updated:
about 8 years ago
Comments: 131Downloads: 52
Views: 17341
Try It/Edit It
15.07 Kb


Convert cents to dollars ()
This datamap will help you to convert 6 digit value to currency format in MS Excel.
stars/0.gifTotal Votes:0
Updated:
about 8 years ago
Comments: 116Downloads: 243
Views: 21863
Try It/Edit It
14.96 Kb

Getting the string between first and last space (Business Management)
This datamap will help you learn how to get the string between first and last sapce, using Regular Expressions. (please refere to the thread http://www.apatarforge.org/forums/viewtopic.php?t=720&start=0)
stars/0.gifTotal Votes:0
Updated:
about 8 years ago
Comments: 111Downloads: 41
Views: 14743
Try It/Edit It
14.58 Kb

Remove a part of number from a particular position (Data Quality)
This datamap example will help you learn how to remove special char/part of number from a particular position. Use case is described at http://www.apatarforge.org/forums/viewtopic.php?t=780&start=0
stars/0.gifTotal Votes:0
Updated:
about 8 years ago
Comments: 127Downloads: 72
Views: 11119
Try It/Edit It
10.24 Kb

Search for Datamaps     Publish and Share a DataMap
 
  Terms and Conditions Privacy Policy Contact Info Comments and Suggestions ETL News