Who's Online

We have 2 guests and 3 members online

Subscription

RSS Feeds List RSS Feeds List

Top Developers


Patryk Szczypien
Created the CurrentTimestamp function

Proud Sponsor of

Main Repository Page arrow Business Management

CSV file to Salesforce where one of the fields is split into several fields using RegExp function       >>

Try It / Edit It

DataMap Description: Here one of the fields has the following format: New York#NY#USA#Wall Str. By using RegExp function we can split this field into 4 different fields. If you have numeric format of the filed like with regards to user request (http://www.apatarforge.org/forums/viewtopic.php?t=452&start=0) you should insert the following RegExps: 1. ([\d]+)#.* 2. [\d]+#([\d]+)#.* 3. [\d]+#[\d]+#([\d]+)

Updated: about 9 years ago

Created By: Sergei (Sergei)

File Size: 40.38 Kb

Views: 26818

Downloads: 181

Tags: .CSV, RegExp, SalesForce.com, TextFile

Rating: stars/5.gifTotal Votes:1

Note: Try It/Edit DataMap requires Apatar Data Mashup installation

 
  Terms and Conditions Privacy Policy Contact Info Comments and Suggestions ETL News