chr(13) + chr(10) question

Amien90
Amien90 used Ask the Experts™
on
i have a question about these chars .. i have an access table that contains a field (TEXT) with alot of data that contains a chr(13)+chr(10) for each row.
With a split  function i can get this out ..
the question i have .. how can i fill a cell with chr(13) chr(10) from lets say xls or csv?

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
Amien90 said:
>>the question i have .. how can i fill a cell with chr(13) chr(10) from lets say xls or csv?

1) Excel uses ANSI 10 to signify a line break within a cell

2) CSV files do *not* have "cells".  They are simply comma-delimited text files.  As such, ANSI 13 & ANSI 10
will signify a line break, which will mess things up considerably

Just what is it that you are trying to do here?
Commented:
From  my experience with CSV and Excel - make sure each variable in the CSV record is enclosed in double quotes "myfirstfield","mysecond
field
with
several lines","myThird Field"

Excel will import this into a single record without any problem

If you really don't want word wrap in the cell - use

 replace(replace(mysecondfield,chr(10),' '),chr(13),' ')

Commented:
I too am not clear on the question.  
Sounds like you have an Access table (an address  perhaps?) which stored more than one line of text in the field.  Is your question how do you enter the data with the appropriate "line feeds" chr(13) when accessing the "Access" table via Excel?

Commented:
Is this still an issue - Do you still require help?

Author

Commented:
its ok ..thanks all

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial