wallyday[dot]com

The situation: Read a product description from a product database.

The problem: The block of text for the product description in the comma delimited file is not formatted, and in fact looks stripped of whatever formatting it had previously. Chunks of text squished together like “changes.Special” (no space after the period), and “Disc BrakeHeadset” (obviously missing a space between Brake and Headset).

I surmised that the missing spaces were previously line breaks (\n or <br>). If a scan/replace function had been used and the line break characters replaced with a null value, it would fit the puzzle perfectly.