Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2023 01:30 PM
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.