Certified Marketing Cloud Developer

By Salesforce · Question Mode

QuestionQ58

VerifiedScripting and Automation

A developer wants to create a query that compiles data from an HTML form so it can be exported as CSV. However, the source data extension can contain line breaks in the Comments field, making the resulting CSV difficult to read and sort.

Which SQL functions can be used to replace every line break with a single space?

Explanation

REPLACE substitutes all instances of a specified string or character with a replacement value, and CHAR returns the character corresponding to a numeric code. Together, they can replace newline characters such as CHAR(10) with a single space.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!