Enumlist values in report

[FB-DW]

I have a column that is set up as an ENUMLIST and I want to list the values in a pdf report on separate lines instead of just listing them all together as a comma separated list of values. How can that be done?

[Steve]

Use SUBSTITUTE() to replace the item separator with a newline character:

<<SUBSTITUTE(CONCATENATE([enumlist-column]), " , ", "
")>>

See also:

help.appsheet.com

CONCATENATE()

Merged text from parts

help.appsheet.com

SUBSTITUTE()

Text with replacements

[FB-DW]

Thanks for the quick response.

I tried putting that in the template and it doesn’t seem to maintain the new line character when the report is created:

Template:
PPE REQUIRED: <<[PPE REQUIRED]>>
<<SUBSTITUTE(CONCATENATE([PPE REQUIRED]), " , ", “
“)>>

Report when Created:
PPE REQUIRED: Rubber Class “3” Gloves , Leather Work Gloves , Rubber Sleeves , Rubber Cover Up
(Hoses , Blankets , etc) , Hard Hat , Safety Glasses , Hearing Protection , Hand Tools , Climbers , Climbing
Belt / Safety , Harness & Lanyard
Rubber Class “3” GlovesLeather Work GlovesRubber SleevesRubber Cover Up (HosesBlanketsetc)Hard
HatSafety GlassesHearing ProtectionHand ToolsClimbersClimbing Belt / SafetyHarness & Lanyard

Desired Result:
Rubber Class “3” Gloves
Leather Work Gloves
Rubber Sleeves
Rubber Cover Up (HosesBlanketsetc)
Hard Hat
Safety Glasses
Hearing Protection
Hand Tools
Climbers
Climbing Belt / Safety
Harness & Lanyard

Any suggestions? PDF Template in Google Docs is what I’m working with.