I want to split a field into two different fields for comparission,
my data is in the format:
address= 5555 xxxxx yyy Apt Z
desired result :
house number= 5555
street address = xxxx yyy
I have tried to use the split command but does not help me with what I want
@jaleelahmed94, please try the following rex command:
<YourBaseSearch> | table address | rex field=address "address=\s(?<house_number>\d+)\s(?<street_address>.*)"
You can test the Regular Expression inside double quotes on regex101.com with your sample data.