You need to sign in to do that
Don't have an account?
Mj12
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
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.
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
Hi Mj12,
Tab is also treated as white space, so use "Enter" key + "Alt" key to insert a new line in excelsheet.
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
I have completely lost with your problem.
Sorry, but can you explain what problem you are facing?