Reformating Data Assistance

[#1]

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!!

[jonathandienst]

Hi

This expression should do the trick:

=Concat([Company Names], ',')

Hope that helps

Jonathan

[#3]

Use Concat(Company Names).

[#4]

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/>

[#5]

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/>

[#6]

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/>

[#7]

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/>

[#8]

I am getting error. Please see email I send to you for explanantion.

[#9]

Please assist. I am getting errors