DUGGI
Giga Guru

1) Extract the employee name:

  • Add a new "Transform Data" action to your flow.
  • Select the "Description" field as the input data.
  • Use a regular expression to extract the employee name from the description field. For example, the regular expression Employee Name\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.: (.+) would match the employee name in the sample data you provided.
  • Map the output of the regular expression to the "Short Description" field of the incident record.

2) Extract the action date:

  • Add a new "Transform Data" action to your flow.
  • Select the "Description" field as the input data.
  • Use a regular expression to extract the action date from the description field. For example, the regular expression Date\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.\\.: (.+) would match the action date in the sample data you provided.
  • Map the output of the regular expression to a custom date field on the incident record.