Extract table data using regex

Hi,

Trying to import table data from a poor quality scan of an old PDF. Computer Vision failed. Trying the old fashion way of cut and paste.

My data is trapped in one column. .YXZP file with real sample data attached.

My regex works on Regex101. It does not work in Alteryx.

(^.*)(Diesel|No Fuel|Electrict|Gas)\s(km|Hr|Annual)\s(.*?)\s(.*?)\s(.*?)\s(.*?)\s(.*?)\s(.*?)\s

Regex

Help

Accepted answers

Your input strings don't have a trailing space so change your regex to this

(^.*)(Diesel|No Fuel|Electrict|Gas)\s(km|Hr|Annual)\s(.*?)\s(.*?)\s(.*?)\s(.*?)\s(.*?)\s(.*)

Dan

Not sure why it's not working, but I encourage you to combine it with the text to columns tool.

Your input strings don't have a trailing space so change your regex to this

(^.*)(Diesel|No Fuel|Electrict|Gas)\s(km|Hr|Annual)\s(.*?)\s(.*?)\s(.*?)\s(.*?)\s(.*?)\s(.*)

Dan

1) LOL 2) %!#@$%!%! I got lazy and hit copy paste one too many times. LOL