framework/resources/Functional/hive_functions_nonhivedata/regexp_extract.q

select columns[0], regexp_extract(case when columns[3]='' then null else columns[3] end, 'W(.*)nd', 1) from `customer_address.tbl`;