G Guest Feb 21, 2005 #1 I have a text file exported from Access. I need to create that file as one long string with no carriage or line returns.
I have a text file exported from Access. I need to create that file as one long string with no carriage or line returns.
F fredg Feb 22, 2005 #2 I have a text file exported from Access. I need to create that file as one long string with no carriage or line returns. Click to expand... If you have a version of Access that supports the Replace function, you can use: NewField:Replace([OldField],chr(13) & chr(10),"") Note:This replaces the return with nothing so you may get text running together, "This is line oneThis is line two" If you want at least a space between the last and first word, use " " as the replace with argument.
I have a text file exported from Access. I need to create that file as one long string with no carriage or line returns. Click to expand... If you have a version of Access that supports the Replace function, you can use: NewField:Replace([OldField],chr(13) & chr(10),"") Note:This replaces the return with nothing so you may get text running together, "This is line oneThis is line two" If you want at least a space between the last and first word, use " " as the replace with argument.
