How to display a list without symbols (like '[{"value":) in email body

301 views
Skip to first unread message

nas-adora...@lafarge.com

unread,
May 19, 2015, 12:26:54 AM5/19/15
to suppor...@runmyprocess.com
Hi team,

I managed to retrieve list of customers from spreadsheet and send an email with the list of customers in email message content. but the list was displays like this:

[{"value":"NISSIN BUILDERS SB"},{"value":"PANAGLOBE SB"},{"value":"YIAN HER TRADING SB"}]

How can i just display the value only like this:

NISSIN BUILDERS SB,PANAGLOBE SB,YIAN HER TRADING SB
--
=================================================
Safety Our Way of Life
Keselamatan Amalan Hidup Kita
=================================================
Disclaimer:

By communicating with Lafarge Malaysia, you are deemed to have consented to
processing of your personal data as set out in the Lafarge Malaysia Privacy
Notice which can be viewed here
<http://www.lafarge.com.my/wps/portal/my/0_9-LegalMentions#editoEncartVide0000000000026567>
.

This email and any files transmitted with it are confidential and intended
only for the use of the person to whom it is addressed. If you are not the
intended recipient you are notified that disclosing, copying, distributing
or taking any action in reliance on the contents of this information is
strictly prohibited. Please notify the sender immediately by email if you
have received this email by mistake and delete this email from your system.
Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of the company.
Finally, the recipient should check this email and any files for the
presence of viruses. The company accepts no liability for any damage caused
by any virus transmitted by this email.

Pankaj Kumar

unread,
May 19, 2015, 3:07:36 AM5/19/15
to suppor...@runmyprocess.com, Nas-Adora Mohd-Dan
Hi Nas,

From the spreadsheet you are getting array, kindly use the below freemarker script to for making the "," seperated string, This string you can in mail.

here "seq" is the identifier (name) of the array.

<#assign resultStr = "" >
<#list seq as x>
  resultStr = resultStr + x.value +", "
</#list>
${resultStr}

Thank you,
Pankaj Kumar
Fujitsu RunMyProcess Support


--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/0f240f45-d118-4050-9f2a-da8ec1e2ab0b%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

Nas-Adora Mohd-Dan

unread,
May 19, 2015, 4:13:36 AM5/19/15
to Pankaj Kumar, suppor...@runmyprocess.com
Tqvm Pankaj

It's works.

Thanks and regards,

NAS ADORA BINTI MOHD DAN
MYIS Department | IT APPLICATION SPECIALIST
LAFARGE MALAYSIA | 2, Jalan Kilang, Petaling Jaya
Office:  (603) 7962 3569 I Fax : (603) 77851453



=================================================
                                     Safety Our Way of Life
                            Keselamatan Amalan Hidup Kita
=================================================
Disclaimer:

By communicating with Lafarge Malaysia, you are deemed to have consented to processing of your personal data as set out in the Lafarge Malaysia Privacy Notice which can be viewed here.

This email and any files transmitted with it are confidential and intended only for the use of the person to whom it is addressed. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Please notify the sender immediately by email if you have received this email by mistake and delete this email from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Finally, the recipient should check this email and any files for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
By communicating with Lafarge Malaysia, you are deemed to have consented to processing of your personal data as set out in the Lafarge Malaysia Privacy Notice which can be viewed here.
Reply all
Reply to author
Forward
0 new messages