Extract table data using regex

[hellyars]

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

[gabrielvilella]

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

[danilang · Accepted solution]

Hi @hellyars 

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

[hellyars]

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