2 posts / 0 new
Last post
Formatting Billing address from a text field in Salesforce
I have a field in salesforce which holds the Billing address in Text type field. Basically I need this be formatted whne I send it to quickbooks . For example : Needs to be as below #65, Soundarya parramount 54,Malleshwaram Banglore India Not like Below, #65, Soundarya parramount54,Malleshwaram Banglore India Need to seperate based on next line character
Total votes: 75

Quickbooks Maintains the address fields different from Salesforce.

In order to Split the address from Salesforce Text area field based on the new line character, we have to make use of Java script.

In DBSync, you can either write the Java script in the mappings or make use of Functions where you can develop or write user defined functions.

I am providing an example of a Java script that can be written in the maps.

In Order to get the first line, You can implement the below script

{return VALUE("<Salesforce Field API Name>").split("\n")[0];}

This will split the text area data and return only the first line.

For the second line, use the below script

{String ST = VALUE("<Salesforce Field API Name>");int L1E = ST.indexOf("\n");int L2E = ((L1E>-1)?(ST.indexOf("\n",L1E+1)):(-1));int SL = ST.length(); if (SL>L1E & L2E>L1E) { String L2x = ST.substring(L1E+1,L2E); String L2 = L2x.substring(0,((L2x.length()>41)?(41):(L2x.length()))); return L2; }else if (SL>L1E & L1E>-1) { String L2x = ST.substring(L1E+1,SL); String L2 = L2x.substring(0,((L2x.length()>41)?(41):(L2x.length()))); return L2; }else { String L2 = ""; return L2; }}

And for the third line, use the below script

{String ST = VALUE("<Salesforce Field API Name>");int L1E = ST.indexOf("\n");int L2E = ((L1E>-1)?(ST.indexOf("\n",L1E+1)):(-1));int L3E = ((L2E>-1)?(ST.indexOf("\n",L2E+1)):(-1));int SL = ST.length(); if (SL>L2E & L3E>L2E) { String L3x = ST.substring(L2E+1,L3E); String L3 = L3x.substring(0,((L3x.length()>41)?(41):(L3x.length()))); return L3; }else if (SL>L2E & L2E>-1) { String L3x = ST.substring(L2E+1,SL); String L3 = L3x.substring(0,((L3x.length()>41)?(41):(L3x.length()))); return L3; }else { String L3 = ""; return L3; }}

Total votes: 72