[Nic]

What is the character to do this? Have tried

n r rn &#13 &#x0000A &#10 &nbspn … 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.

[cdelacruz]

Hello,

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.

[Nic]

Hello,

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

[ddennison]

This 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.

[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.

[Dew]

I 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” in the “Replace with” field. You get this odd flashing dot in the “Replace with” field, but it does work.

[Nic]

Dew awesome! Thanks!

[Author]

Posts