Skip to main content
Nintex Community Menu Bar
  • 10000+ Topics
  • 73,334 Replies
10000+ Topics
Regex - Extract data

Hi, I'm looking for a regex expression pattern for the following data. I need first column and last column information from the table. e.g. Annual Leave 12.5 Uncertified Sick Leave 6.0 48 mths Sick Leave Full Pay 148.5 48 mths Sick Leave Half Pay 195.0 Is it possible? Thanks.                                  Quota as     Taken as                         Type                            of today     of today       Booked    Remaining--------------------------- ------------ ------------ ------------ ------------Annual Leave                   17.5 days     5.0 days     0.0 days    12.5 daysUncertified Sick Leave          7.0 days     1.0 days                  6.0 days48 mths Sick Leave Full Pay   195.5 days    47.0 days                148.5 days48 mths Sick Leave Half Pay   195.0 days     0.0 days                195.0 days