Enumlist values in report

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?

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

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

See also:

2 Likes

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.