|
| 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
 Total Votes:0 | Updated:
about 2 years ago | Downloads: 61
Comments: 0
Views: 1232 | 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).
Total Votes:0 | Updated:
about 2 years ago | Downloads: 72
Comments: 0
Views: 1446 | 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.
Total Votes:0 | Updated:
about 2 years ago | Downloads: 85
Comments: 0
Views: 1281 | 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)
Total Votes:0 | Updated:
about 2 years ago | Downloads: 26
Comments: 1
Views: 37938 | Try It/Edit It
15.83 Kb |
| | Regexp example (Business Productivity)
This sample will help you reformat particular column strings using the RegExp function.
Total Votes:0 | Updated:
about 1 year ago | Downloads: 58
Comments: 0
Views: 1082 | 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)
Total Votes:0 | Updated:
about 1 year ago | Downloads: 21
Comments: 0
Views: 647 | 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.
Total Votes:0 | Updated:
about 1 year ago | Downloads: 124
Comments: 1
Views: 1402 | 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)
Total Votes:0 | Updated:
about 9 month ago | Downloads: 5
Comments: 0
Views: 440 | 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
Total Votes:0 | Updated:
about 5 month ago | Downloads: 46
Comments: 1
Views: 924 | Try It/Edit It
10.24 Kb |
Privacy Policy