Queury to change carriage returns

[KenshiroUK]

Query to change carriage returns and breaks to <p> and </p>

Hi all I'm struggling to get this work but I currently I have a database with description. This contains carriage returns so it looks like

Product A

Description A

Description B

Description C

however ebay file exchange will not accept this file. So what I wish to do is add an <p> and </p> tag in a simple select query to it looks like this:

<p>Product A</p> <p>Description A</p> <p>Description B</p> <p>Description C</p>

Is this possible?

 

[pr2-eugin]

Just air coded..

SELECT "<p>" &  Replace(fieldName, vbCrLf, "</p> <p>") & "</p>" As NewEditedField 
FROM tableName;

 

[KenshiroUK]

Just air coded..

SELECT "<p>" &  Replace(fieldName, vbCrLf, "</p> <p>") & "</p>" As NewEditedField 
FROM tableName;

could you translate that into the form of query for example Expr1(example)

 

[pr2-eugin]

I just gave you the Query.. Copy it changing the field name and table name to the ones you got and paste it to your SQL view of the Query..

 

[KenshiroUK]

I have just tried that and its asking for vbCrLf in a dialogue box.

I just gave you the Query.. Copy it changing the field name and table name to the ones you got and paste it to your SQL view of the Query..

 

[pr2-eugin]

Okay try the following Query..

SELECT "<p>" &  Replace(Replace([COLOR=Blue][B]FieldName[/B][/COLOR],[COLOR=Red][B] Chr(10)[/B][/COLOR], ""), [COLOR=Red][B]Chr(13)[/B][/COLOR], "</p> <p>") & "</p>" As NewEditedField 
FROM [COLOR=Blue][B]tableName[/B][/COLOR];