Certified Marketing Cloud DeveloperDemo

By Salesforce · Question Mode

QuestionQ58

Scripting 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?

  • A REPLACE and CHAR
  • B LTRIM and RTRIM
  • C REPLICATE and NCHAR
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!