Import CSV file into Project with Hard Returns

[chazparks]

How do I import hard returns into MS Project? I have tried \r\n but that
shows up as actual text instead of a line return within the notes column.

 

[Rod Gill]

I assume you are importing to the Notes field? If so, it should read
everything between the double quotes denoting the string.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

How do I import hard returns into MS Project? I have tried \r\n but that
shows up as actual text instead of a line return within the notes column.

__________ Information from ESET Smart Security, version of virus
signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4668 (20091207) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[John]

How do I import hard returns into MS Project? I have tried \r\n but that
shows up as actual text instead of a line return within the notes column.

chazparks,
Adding a little to Rod's response, you may need to restructure the CSV
file to use ASCII callouts for line feeds and carriage returns. For
example, the CSV text might look something like,
"Now is the time for all good men" & chr(13) & "to come to the aid of
their party". At least, that's how it works in VBA.

Be advised however that you will not see "hard returns" in the Notes
field when it is displayed as a column in a view. Project will only
display a maximum of 255 character or up to the first line feed,
whichever occurs first. To see the entire contents of the Notes field
you will need to go to Project/Task Information/Notes tab.

John
Project MVP