i have the text in below format. I need to use regular expression to extract the text after “:” colon of each row and store in separate variable.
Ex- Billing date in str_billindate-variable
plant in str_plant_variable.
Like that individual regular expression is required for each row of prefix text as mentioned below.
Can anyone please help me regarding this.
Note - Regular expression should take text only after “:” colon to end of that line only,it should not go to next lane text or should not consider next line text.
((Billing date: 2022-01-30
Payment Term: TLN
Assignment: T2K - CO0001
Collective number: T2K
Tax Code: 0899
Employee Respons: 11110950
Description: PM PRICE ADJUSTMENT
Posting Text: Compensation for the period of July to December 2020 according to distribution agreement signed on 01.01.2014.
Block Payment: False
Invoice Sending Instructions: email@example.com; Srinath.firstname.lastname@example.org;
Any online source where we can have regular expression for entered text, is also much appreciated.
What about generating a datatable with the column separator as “:”?
Will need some cleanup, you need to be sure that there is going to be only one colon per line, and check what is the line break in your case.
Then depending on your need - you can either build a dictionary, or just loop through the DT as needed, lots of flexibility.
The website that is most compatible with UiPath is RegexStorm.net. This is the best place to test your Regex Patterns. (However the best place to learn IMO is Regex101.com but its not fully compatible with UiPath.)