Separating "PN - Description" into different columns

Hi @dtaranto ,

You can do this in excel as below 

Hope this helps!!

Regards,

Mithun K V

Thank you for the response. However, the problem is many of our part numbers (and descriptions) contain the character “-”. I believe all our part numbers containing a “-” would be cut short using this approach. 

@dtaranto When I tried to export from a page with Part Number and Description in the same field, they where already separated when exported to excel. Which version are you on?

They are not separated before the export (see screenshot below). Component part number and component part description are merged into one column called “Component Part”. I am using IFS Apps 10 (Aurena). Thanks

@dtaranto In IFS Cloud the Component Part Number and Component Part Description are displayed in the same field, but when exported to Excel they are separated into part number and description. See below:

Not for me… Is this configurable somewhere? I would like the export to look like yours. Thanks

I think it’s an enhancement that was made in IFS Cloud that might not be available in Apps 10.

@dtaranto In IFS Cloud the Component Part Number and Component Part Description are displayed in the same field, but when exported to Excel they are separated into part number and description. See below:

 

Can you please let me know the cloud version in which, there is dedicated column for component and its description.

@Björn Hultgren Can you please let me know the cloud version in which there is dedicated column for component and its description.

@Haru unfortunately I’m not aware in exactly which IFS Cloud version this feature became available.