I want to extract the information from the string below and insert the data into a data table.
I try to create the regex pattern, but because of the occurrence of the words Product Id, Quantity, Item is more than one so my regex will not work.
Can anyone help me how can I extract the information from the string using regex ?
String:
-----------------------------------------------------------------------------
Product ID : TXSKJI1123321
Quantity : 19
Item : Jeans
-----------------------------------------------------------------------------
NEXT ACTIONS
Increase stock for TXSKJI1123321 up to 100 units
-----------------------------------------------------------------------------
Product ID : AKSP2790173332
Quantity : 7
Item : Shirts
-----------------------------------------------------------------------------
NEXT ACTIONS
Increase stock for AKSP2790173332 up to 50 units
-----------------------------------------------------------------------------
Product ID: AKSP27901733789
Quantity : 2
Item : Vest
-----------------------------------------------------------------------------
NEXT ACTIONS
Increase stock for AKSP27901733789 up to 15 units
Data table should look like this:
Regex that I use but failed:
(?<=Product ID\s\S)(.|\n)*(?=Quantity )