Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Exam Marketing Cloud Developer Topic 2 Question 87 Discussion

Actual exam question for Salesforce's Marketing Cloud Developer exam
Question #: 87
Topic #: 2
[All Marketing Cloud Developer Questions]

A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may contain line breaks within the Comments field, which makes it difficult to read and sort the resulting CSV.

Which SQL functions could be used to change each line break to a single space?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Daron at Jan 26, 2025, 08:52 PM

Limited Time Offer

25%

Off

Get Premium Marketing Cloud Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Julene
2 months ago
Hmm, REPLACE() and CHAR() sounds like the right combo to me. It's probably the most efficient way to handle those pesky line breaks in the Comments field.
upvoted 0 times
Magnolia
8 days ago
Yes, REPLACE() and CHAR() are commonly used functions for handling text manipulation in SQL queries.
upvoted 0 times
...
Sheron
9 days ago
Yes, those functions will make the data more readable and organized in the CSV file. Good call on using them.
upvoted 0 times
...
Chanel
13 days ago
Definitely, REPLACE() and CHAR() are commonly used for this type of data manipulation. It's a smart choice.
upvoted 0 times
...
Van
14 days ago
I think those functions are the best choice for this situation. It will make the CSV data much easier to work with.
upvoted 0 times
...
Micheal
17 days ago
I think that combination would work well to replace the line breaks with a single space in the CSV export.
upvoted 0 times
...
Laura
23 days ago
I agree, using REPLACE() and CHAR() would definitely help clean up those line breaks in the Comments field.
upvoted 0 times
...
Bev
1 months ago
I agree, using REPLACE() and CHAR() would definitely help clean up the line breaks in the Comments field.
upvoted 0 times
...
...
Kip
2 months ago
Ha! LTRIM and RTRJM? That's a good one. I'm pretty sure the answer is REPLACE() and CHAR().
upvoted 0 times
Brittni
28 days ago
Definitely, those functions will help clean up the line breaks in the Comments field.
upvoted 0 times
...
Truman
2 months ago
I agree, REPLACE() and CHAR() are the way to go.
upvoted 0 times
...
...
Tamar
2 months ago
I'm not sure about CHAR(), but REPLACE() definitely seems like the way to go. It's a simple and straightforward solution.
upvoted 0 times
...
Weldon
2 months ago
The REPLACE() function looks like the obvious choice here. It can replace the line breaks with a single space character.
upvoted 0 times
...
Reena
2 months ago
I'm not sure, but I think C) LTRIM and RTRIM could also be used to remove line breaks in the CSV.
upvoted 0 times
...
Jerlene
2 months ago
I agree with Dyan, using REPLACE and CHAR makes sense to handle line breaks in the Comments field.
upvoted 0 times
...
Dyan
3 months ago
I think A) REPLACE and CHAR could be used to change line breaks to spaces.
upvoted 0 times
...

Save Cancel