function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
RobinWRobinW 

Dataloader CSV - Non-Breaking Space

Hi All,

 

Is it possible to generate a non-breaking space (hard space) for a particular field in a CSV? 

A CSV loses it's format, so I would like to know if there is a way to add such a hard space. 

 

For instance: the Account object has a field Description. On Salesforce, you can generate hard spaces in this field. 

 

How can you generate such a hard space in a CSV? Using a \n or CHAR(13) or so? And how will this look in a CSV field?

 

Kind Regards,

R

Best Answer chosen by Admin (Salesforce Developers) 
Ashish_SFDCAshish_SFDC

Hi Robin, 

 

If you are entering the value of a particular field which has spaces in it - then just make sure you are using the ,(Comma) exactly to enclose the field and that should work. 

 

Regards,

Ashish

All Answers

Ashish_SFDCAshish_SFDC

Hi Robin, 

 

If you are entering the value of a particular field which has spaces in it - then just make sure you are using the ,(Comma) exactly to enclose the field and that should work. 

 

Regards,

Ashish

This was selected as the best answer
RobinWRobinW

Hi Ashish,

 

Thanks. I was able to create the hardspaces using following way (for instance for an Account):

ID,NAME,DESCRIPTION

001b0000008jGohAAE,GeoPoint,"This is

a 

description

with hard

spaces

."

 

Seems to be working!