Hi @BALAJI K R ,
You can use JavaScript in the field mapping script. Here's a sample script that demonstrates how to achieve this:
(function transformEntry(source) {
// Convert date to system format
var originalDate = source.u_original_date; // Replace 'u_original_date' with the actual source field name
var systemDate = new GlideDateTime(originalDate);
var systemDateFormat = systemDate.getDisplayValue(); // Adjust date format as per your requirement
// Parse and fetch country
var originalCountry = source.u_original_country; // Replace 'u_original_country' with the actual source field name
var country = originalCountry.split('-')[1].trim(); // Assuming country name is after the hyphen and trim any leading or trailing spaces
// Set values in target fields
source.u_system_date = systemDateFormat; // Replace 'u_system_date' with the actual target field name for system date
source.u_country = country; // Replace 'u_country' with the actual target field name for country
})(source);
Ensure to replace 'u_original_date' and 'u_original_country' with the actual names of the fields containing the original date and country respectively. Similarly, replace 'u_system_date' and 'u_country' with the names of the target fields where you want to store the converted date and extracted country respectively.
This script assumes that the date field is of type GlideDateTime in the ServiceNow instance. Adjust the date format according to your requirements. Additionally, ensure that the country names are consistently formatted in the source field for proper parsing.
Thanks,
Ratnakar
