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
Nitesh ChaureNitesh Chaure 

I am trying to import csv file which contain the values seperated by comma(One cell contain record value which also have comma ie. [bannan,apple,orange]).

I am trying to import csv file which contain the values seperated by comma(One cell contain record value which also have comma ie.  [bannan,apple,orange]). and some cell contain more characters, so that record automatically broken into multiple lines. While importing file, so many records got created.
So guys please provide me solution to resolve the two problems.

Thanks you in advance..
Shruti SShruti S
In CSV files whenever it encounters a comma it considers the same as a new column. Hence just enclose those values in "double quotes". 
Eg:  
Id      Fruit       Variety
-------------------------------------------------
1       Apple       "Fuji,Green Apple,Red Apple"
_________________________________________________
NagendraNagendra (Salesforce Developers) 
Hi Nitesh,

May I suggest you please check with the below Salesforce help document which has a detailed explanation on how to import a CSV file. Note: if the values are separated by a comma then you may enclose the list of values separated by a comma within the double quotes.

Hope this helps.

Please mark this as solved if it's resolved.

Thanks,
Nagendra