Whitespace driving me nuts

[dunxd]

How are newlines, tabs etc represented in Access 2002?

I need to replace some HTML in a SQL Server table with new lines, but I cannot for the life of me find this in the help.

It is driving me nuts.

I can't find it in the help file anywhere? --
Dunx

 

[SQLSister]

I assume you are typing data in a field in Enterprise Manager? Try control-enter to go to the next line. Type it twice to get a blank line and then a line to type more stuff on.

IF you are asking how to do it in code, look at the CHAR function in boooks on line.

 

[dunxd]

I am trying to replace </p><p> in an existing table (of over 800 records) with two newlines.

</p> and <p> are separated by an undetermined number of spaces.

Can I do this with an UPDATE query using replace and CHAR(10)? --
Dunx

 

[fluteplr]

Char(13) is more likely to do what you want.

 

[dunxd]

I think I need to get rid of Char(13)+Char(10), as the data was all created by a windows machine.

In the end I had to do most of the removal of whitespace manually, or just gave up on it. I just couldn't find any regular expression type stuff in MS's documentation that would allow me to get rid of any cases where there was more than 1 space in a row.

If anyone knows how to do this in SQL Server (or using Access 2002 as a front end), I would be most grateful if you shared it.

Cheers. --
Dunx