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
Total Votes:0
Privacy Policy