Solved

Custom Field - Can we add carriage return characters to a multi-line custom field?

  • 28 June 2022
  • 3 replies
  • 186 views

Userlevel 3
Badge +10

I am trying to display a full address in a multi-line custom field. The custom field settings are:

  • read-only
  • text (unformatted) with multi-line enabled
  • The implementation type is a Select Statement to grab and concat the information.  I am using CHR(13) for the carriage return in the select statement.

The format expected to be displayed in the custom field is:

Address 1
City, State, Zip Code
Country

 

The custom field displays in the information in one line and it seems that the carriage return did not work. However, when I copy and paste the information into notepad, the carriage return is here.

Is there a way for a custom field to read a break line or carriage return for multi-line records and, if so, how?

icon

Best answer by sutekh137 28 June 2022, 23:18

View original

3 replies

Userlevel 6
Badge +12

I am guessing you need to play around with CHR(10) and maybe even a combination of CHR(13) and CHR(10).

When I pull an Address from Customer_Info_Address and show symbols in Notepad++, it looks like this:

 

 

That’s a carriage return and line feed, so I think you need CHR(13) || CHR(10). Give that a try…

Good luck!

Joe Kaufman

Userlevel 3
Badge +10

@sutekh137 Thank you so much! This solved my issue. 😀

Userlevel 6
Badge +12

@jamie.malangyaon 

Glad that worked!

 

JoeK

Reply