Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to know how to format the data below.
From
Company Names |
---|
ABC |
DEF |
PQR |
XYZ |
To
ABC, DEF, PQR, XYZ
Please kind advise. Thank you very much!!
Hi
This expression should do the trick:
=Concat([Company Names], ',')
Hope that helps
Jonathan
Use Concat(Company Names).
Hello Jon,
Thank you for your suggestion.
I tried but keep getting error. Please see below is the codes I am trying to reformat the data. MOC_Entity is the field I would like to add a ‘,’. Can you advise where to add in the codes please?
MOC_Entity:
Load MOC_OrderID,
MOC_OrgCoy as MOC_Entity
resident MOC_Headline;
Load MOC_OrderID,
MOC_TakeCoy as MOC_Entity
resident MOC_Headline;
Thanks!
Jeremiah Lee
Product Manager for eWindow®, Global Trading Services
Platts
12 Marina Boulevard
#23-01, Marina Bay Financial Centre Tower 3
Singapore 018982
DID (65) 6530 6415 | Support (65) 6530 6530
Mobile (65) 9108 4192 | F (65) 6532 2700
Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>
www.platts.com<http://www.platts.com/>
Hello Kumar
Thank you for your suggestion.
I tried but keep getting error. Please see below is the codes I am trying to reformat the data. MOC_Entity is the field I would like to add a ‘,’. Can you advise where to add in the codes please?
MOC_Entity:
Load MOC_OrderID,
MOC_OrgCoy as MOC_Entity
resident MOC_Headline;
Load MOC_OrderID,
MOC_TakeCoy as MOC_Entity
resident MOC_Headline;
Thanks very much!
Jeremiah Lee
Product Manager for eWindow®, Global Trading Services
Platts
12 Marina Boulevard
#23-01, Marina Bay Financial Centre Tower 3
Singapore 018982
DID (65) 6530 6415 | Support (65) 6530 6530
Mobile (65) 9108 4192 | F (65) 6532 2700
Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>
www.platts.com<http://www.platts.com/>
Hi Jon,
Please see attached file, which will explain what is the result I am trying to get..Thanks!
Jeremiah Lee
Product Manager for eWindow®, Global Trading Services
Platts
12 Marina Boulevard
#23-01, Marina Bay Financial Centre Tower 3
Singapore 018982
DID (65) 6530 6415 | Support (65) 6530 6530
Mobile (65) 9108 4192 | F (65) 6532 2700
Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>
www.platts.com<http://www.platts.com/>
Attached shows the result I am trying to get…any suggestions please?
Jeremiah Lee
Product Manager for eWindow®, Global Trading Services
Platts
12 Marina Boulevard
#23-01, Marina Bay Financial Centre Tower 3
Singapore 018982
DID (65) 6530 6415 | Support (65) 6530 6530
Mobile (65) 9108 4192 | F (65) 6532 2700
Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>
www.platts.com<http://www.platts.com/>
I am getting error. Please see email I send to you for explanantion.
Please assist. I am getting errors