If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Remove carriage returns in memo fields
I have imported some data from Excel where the Alt+ Enter has been used to
line space information in a cell. This comes over as | type character. Any suggestion please as to how I can relace these characters with a carriage return in the imported memo field. Thanks |
#2
|
|||
|
|||
Remove carriage returns in memo fields
judith wrote:
I have imported some data from Excel where the Alt+ Enter has been used to line space information in a cell. This comes over as | type character. Any suggestion please as to how I can relace these characters with a carriage return in the imported memo field. Run an UPDATE query like this: UPDATE [yourTable] SET [yourMemoField] = Replace([yourMemoField], Chr(10), Chr(13) & Chr(10)) imho Excel only uses the Lf character: Chr(10) is Lf Chr(13) & Chr(10) is CrLf be sure, that you have a backup copy of your table/database before trying it. mfG -- stefan -- |
Thread Tools | |
Display Modes | |
|
|