I am trying to capture request type from ticket description. And depending on the request data will be stored in excel file.
For Example :
Hi, one of my team member ABC PQR (123456) is promoted to senior developer and his salary is increased to $19000 per annum effective from 9th October 2021. Please update the details in portal.
I want to capture :-
- Process Name: Designation Change and Salary Change
2.Employee Name: ABC
3.Employee ID: 123456
5.Effective Date: 9th October 2021
Here Date can be in any format like
10/9/2021 or 09/10/2021 or 9/10/21 or 9-10-21 etc.
Similarly for Employee Name and ID sometimes there will be only Employee name not Employee ID. or sometimes only ID will be there in different format
Ex. ABC PQR (123456) or ABC PQR or ABC PQR 123456 or AA1234 or ABC PQR ( A1234 ) etc.
Like wise for Amount there will be any symbol or no symbol.
ex. 2000$ Or 2000 Rs. or 40000 etc.
How can we extract those details and fill it in excel.