list

[redoakhg]

Hi - I have a database column named description that contains data that looks like: - Peel and Stick Darkening Vinyl Tempory Shade- No Pull Cord Danger- Easily Adjusts to Any Window (18~ x 36~)- EZ 1 Piece Installation

I want to create a bulleted list using the hyphen (-) as the delimiter.

So the resulting display would look like:
- Peel and Stick Darkening Vinyl Tempory Shade
- No Pull Cord Danger
- Easily Adjusts to Any Window (18~ x 36~)
- EZ 1 Piece Installation

Any suggestions?

Thanks!

 

[r937]

<ul>
<CFLOOP index="bullet" list="description" delimiters="-">
<CFOUTPUT><li>#bullet#</li></CFOUTPUT>
</CFLOOP>
</ul>

ain't CF wonderful

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[redoakhg]

Thanks! One additional question if you don't mind. I need to replace a bunch of characters. This works with the except it also removes all of the spaces.
#rereplace(description, '[^\w]', '', 'all')#.

I'm not sure what to do.

Right now it looks like:
Petking100DisposablePoochPouchesConvenientandDisposableSealsinOdorsatHomeorAway

And I need:
Petking 100 Disposable Pooch Pouches Convenient and Disposable Seals in Odors at Home or Away

 

[redoakhg]

Disregard I got it. Thanks again.

 

[LarrySteele]

redoakhq - might be nice to post your solution for others who find this post looking for an answer to the same question.