Modify the data in CSV file when exporting the data using Export Definition

[Pallavi Thumma]

Hi All,

We have configured an Export set to export the data from metric instance table to MID-server and then to the remote Server (SFX Server). In metric instance table we have an ID field which is a Document ID type field which will refer to the HR Talent management case (HRC...). While exporting data in CSV file the ID field is displaying as "HR Talent Management case: HRC*****" but we have a requirement where need to extract the case number from the ID field by truncating the HR Talent Management case: value from ID field as per the attached image. Could anyone suggest if there is any work around for this issue?

Thanks in Advance!!

[Tony Chatfield1]

Hi, I would look at creating the file via a scheduled job so that you can script\create the csv you require,

and then trigger an export of the file (possibly as part of the scheduled job).

[Pallavi Thumma]

Hi @Tony Chatfield1 

Thank you for providing your response.

We have created the CSV file using Export definition Module and scheduling it using the scheduled job. In scheduled job we have used post-export script to make changes to the name of column header, but we are unable to find a way to make changes for the column data. If possible, could you please provide the script by which we can be able to achieve the functionality.

Thank you!!

Regards,

Pallavi T

[Tony Chatfield1]

Without details of your code it is not possible to provide clear instructions as to how it should be updated\modified.

If you have managed to update the header then it sounds like all you need to do is either use replaceAll('stringToReplace', '') for the string\payload, or if it's an array loop through each element and use replace('stringToReplace', ')

JavaScript String Methods (w3schools.com)