+ Start a Discussion
Mj12Mj12 

Data loader: Text Area problem

Good day,

 

Is there a way to handle a text area field having a new line when using a data loader?

 

i did try other alternatives such as replacing the new line using the tab. but when loaded into the salesforce,

the value displayed in one line (which is not good to looked at)  instead of having a new line.

 

Any idea is appreciated.

 

Thanks in advance,

 

markpogiako

Navatar_DbSupNavatar_DbSup

Hi,

      As i think you have to manipulate manually for new line in a file before loading the data in Org for a text area field type.

      i do not think no other way for this.

 

     Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.  

Mj12Mj12

Hi,

 

I already did that. by using tab. and it successfully uploaded into the sf. but problem is value it the displays in the screen

instead of :

"street 1

 city 1

 aaaaaa"

 

it returns "Street 1 city 1 aaaaa". which is not the original position it has.(im doing the export then update btw).

 

Thanks,

 

markpogiako

Rahul SharmaRahul Sharma

Hi Mj12,

Tab is also treated as white space, so use "Enter" key + "Alt" key to insert a new line in excelsheet.


Mj12Mj12

Hi Rahul,

 

but if i still use that new line. it will just create another row that should be not.

 

i will have this graph in the data loader if i insist the new line:.

 

_________________________________________

ID               |  Name                | Address 

------------------------------------------------------------------------

ID123        | Name1                | #1234

aaaa st

bbbb city   |ID456                   |  Name2

_________________________________________

 

 

so i cant insert the content bec. data is not placed correctly

Rahul SharmaRahul Sharma

I have completely lost with your problem.

Sorry, but can you explain what problem you are facing?