Notepad++ is an excellent tool for text processing of different kinds.brbrLet's assume you have a CSV-file on this form:brtable class="codeTable"tbodytrtdcode"FIELD 1 HEADER","FIELD 2 HEADER","FIELD 3 HEADER"br"row 1 field 1","row 1 field 2","row 1 field 3"br"row 2 field 1","row 2 field 2","row 2 field 3"br"row 3 field 1","row 3 field 2","row 3 field 3"/code/td/tr/tbody/tablebrAnd you want it on this form:brtable class="codeTable"tbodytrtdcodeFIELD 1 HEADER;FIELD 2 HEADER;FIELD 3 HEADERbrrow 1 field 1;row 1 field 2;row 1 field 3brrow 2 field 1;row 2 field 2;row 2 field 3brrow 3 field 1;row 3 field 2;row 3 field 3/code/td/tr/tbody/tablebrWhen extracting object data using the Sales Data Loader you get a CSV file that is comma separated as the first example above. Each line ends with a new line or more exactly with the characters CRLF (rn). Possible line breaks within a column is used with the characterbrLF (n). brbrIf you want to load this file into for exampel MySQL later on, you specify what each line ends with and this way line breaks will be preserved within the columns.brbrKeeping this in mind you can do the following replacements to get the results wished for.brbrb1./b Remove first apostrophebrbrb2./b Press Ctrl-F and search for any semi-colons. If any are found replace them with something appropriate.brbrb3./b Press Ctrl-H (replace dialogue box) and find "," and replace with ;brbrNow the file will look like this:brtable class="codeTable"tbodytrtdcodeFIELD 1 HEADER;FIELD 2 HEADER;FIELD 3 HEADER"br"row 1 field 1;row 1 field 2;row 1 field 3"br"row 2 field 1;row 2 field 2;row 2 field 3"br"row 3 field 1;row 3 field 2;row 3 field 3"/code/td/tr/tbody/tablebrNow if you show all characters (Menu - View - Show all characters) you will see the newline characters.brbrimg src="http://www.wohill.com/images/notepad_showallcharacters.jpg" alt="" border="0"brbr4. Replace end-of-line characters apostrophes and beginning-of-line apostrophesbr dd4.1 Press Ctrl-Hbr 4.2 Choose Extended Search mode (at the bottom of this dialogue box)br 4.3 Find "rn" and replace with rn/ddbr 5. Remove last apostrophebr /br /img src='http://www.wohill.com/images/wo_section_dev1a.jpg' /
pa href="http://feedads.g.doubleclick.net/~a/2yNkYuFQjw7XlhCORfo5PuP0Ba4/0/da"img src="http://feedads.g.doubleclick.net/~a/2yNkYuFQjw7XlhCORfo5PuP0Ba4/0/di" border="0" ismap="true"/img/abr/
a href="http://feedads.g.doubleclick.net/~a/2yNkYuFQjw7XlhCORfo5PuP0Ba4/1/da"img src="http://feedads.g.doubleclick.net/~a/2yNkYuFQjw7XlhCORfo5PuP0Ba4/1/di" border="0" ismap="true"/img/a/p
Using Visualforce pages as content source on buttons in Salesforce
Wed, Oct 5th 2011 4:11p Niklas Waller When you want to create a button for an object you can override a standard or create a custom one. On the page for this you choose ‘Visualforce Page’ as content source. One thing you’ll discover is that there are no choices if there are also no Visualforce pages with a standard controller to the... Read more [read] Keywords:
43
Make Setup the default landing page in Salesforce Winter ’12 Release
Wed, Sep 28th 2011 4:11p Niklas Waller Today I attended the webinar Winter ’12 release preview to learn about what’s coming in Salesforce winter ’12 release. It was quite a few interesting things that I’m looking forward to trying out. A very small but wished-for adjustment is to being able to make Setup the default landing page when logging into Salesforce. Go to... Read more [read] Keywords:
42
Problems with Salesforce sandbox integration with BigMachines after Winter ’12 release
Wed, Sep 21st 2011 5:11p Niklas Waller We use Salesforce together with BigMachines as our CRM-system and product configurator. This means very briefly that when our business are creating agreements they enter BigMachines from a Salesforce opportunity. This procedure stopped working as it used to after this weekend’s upgrade to the Winter ’12 release of Salesforce sandboxes. We get several errors. One of... Read more [read] Keywords: integration
58
The ModSecurity module on Apache web server for BigMachines version 11
Wed, Sep 14th 2011 4:13p Niklas Waller The ModSecurity module on the Apache server (BigMachines web server) is mandated for all upgrades starting with BigMachines version 11. After upgrading to version 11 we suddenly got “The webpage can not be found” on several places. This turned out to be because the ModSecurity don’t permit double pipes (||) which we were using as... Read more [read] Keywords: server
38
Did you know you can change the Google search page background?
Wed, Sep 7th 2011 6:10p Niklas Waller I haven’t noticed this until know. At the bottom right of the window you can click ‘Change background image’. Select an image from a public gallery, your computer or your Picasa web photos. When pressing ‘Select’ this image will be your background image on the Google search page. Share and Enjoy: [read] Keywords: google
61
Calling a web service by pressing a button
Wed, Aug 31st 2011 5:10p Niklas Waller If you want to run some code when pressing a button in Salesforce you could do it in the button itself, for example like this: {!REQUIRESCRIPT("/soap/ajax/22.0/connection.js")} {!REQUIRESCRIPT("/soap/ajax/22.0/apex.js" )} var connection = sforce.connection; var callOff = new sforce.SObject("Opportunity"); callOff.AccountId = "{!Opportunity.AccountId__c}"; callOff.Main_Opp__c = "{!Opportunity.Id}"; callOff.RecordTypeId = "01460000000JngT" callOff.Name = "Opp Name"; callOff.StageName [read] Keywords: ajax
60
Setting field value on a page layout with read-only attribute
Thu, Aug 25th 2011 7:10a Niklas Waller You have a page layout with a field that has the read-only attribute on the page layout but that is available in the field level security. This means a user cannot modify the field when looking at the record through the page layout. If you need to set this value when opening a record, either... Read more [read] Keywords: security
30
Backup your Google+ data
Wed, Aug 17th 2011 4:10p Niklas Waller Now you can backup your Google+ data. That is your +1′s, profile, contact and circles, buzz’s, picasa web albums and your stream. This has been made possible thanks to Google’s Data Liberation Front. Google Takeout is a data liberation platform that makes escaping from Google products easy (if you’d want to escape). Or you could just... Read more [read] Keywords: google
profile
36
Creating a Google+ pic or a I’ve moved to Google+ pic
Wed, Aug 10th 2011 4:14p Niklas Waller If you’re a Google+ fan you might want to tweek your profile photo a bit. An easy to use service for creating a Google+ pic of yourself is +me by Turhan Aydin. Either modify the one for Google+ Or add a “I’ve Moved to Google+’ pic for your Facebook profile: I am sure you have better... Read more [read] Keywords: facebook
google
profile
