Forums › Cached › CSV Import
This topic contains 6 replies, has 0 voices, and was last updated by Nic 8 years, 11 months ago.
-
AuthorPosts
-
December 1, 2015 at 8:46 am #23859
NicWhat is the character to do this? Have tried <br> <br /> n r rn 
 
 
  n … just about anything I could find on the internet that was a carriage return. Nothing works.
This is a cached copy. Click here to see the original post. -
December 1, 2015 at 2:07 pm #23860
cdelacruzHello,
If the column for the Text Area field in your CSV file have a carriage return (new line feed), just change the character encoding to Unicode (UTF-8) in NetSuite.
-
December 1, 2015 at 3:19 pm #23861
NicHello,
So I tried that and it still didn't work. What exactly would I need to type in the field for it to import correctly. Thanks
-
December 1, 2015 at 4:24 pm #23862
ddennisonThis may not help you but what works for me is to type the text I want complete with all carriage returns (just hit enter) in plain old notepad first. Then copy/paste that into excel/csv file. Then (if you need) concatenate that with whatever other text you need. This will import carriage returns as you want them in text fields. At least, it works for Sales Description field for items.
For example, when I import items, I always want the description to be like this (with the carriage return):
Manufacturer Name
Long Description
I type Manufacturer Name and hit enter in notepad, then copy it all and paste to excel. Then I have another column that is this value concatenated with the actual text string. This new column is the only one that I import. This gets me the result I want without changing any text encoding.
-
December 2, 2015 at 8:06 am #23863
Nic@ddension I was afraid that was the only way. Looks like I will be hitting Alt+Enter about 1000 times. Awesome!
Also maybe this is a slightly quicker way of doing the same thing. Instead of going from notepad to excel, you can just do it directly in Excel by clicking alt+enter where you want the new lines.
-
December 2, 2015 at 2:49 pm #23864
DewI don't know if this will work in your particular scenario, but you could try a find and replace all using the Alt+010 key combination (hold down the Alt key and pressing 0,1,0 on the number pad) in the replace field. For example, if you wanted a new line after every occurrence of "xyz", you would put "xyz" in the "Find what" field and "xyz<Alt+010>" in the "Replace with" field. You get this odd flashing dot in the "Replace with" field, but it does work.
-
December 2, 2015 at 2:56 pm #23865
NicDew awesome! Thanks!
-
AuthorPosts
You must be logged in to reply to this topic.