Extract PO Box out of address field

Hi Ralph

Please use this way
https://docs.algolplus.com/algol_order_export/fields/

Hi
That is to combine two fields into one, but I would like to split one field into two.
How can I do that?
Many thanks in advance.
Ralph

Hello
Please provide sample addresses.

Hi

In the field with meta tag ‘_billing_address_1’ my customers fill in their street + PO Box.
In the export file, I would like to separate these two variables.

e.g.: Baker Street 1

-> _shipping_address_1 : Baker Street 1
[This is the Woocommerce field]

-> _custom_street : Baker Street
-> _custom_po : 1
[These are the two fields I would like to create in the export file]

Is there any way to do so in the plugin?

Thanks!
Ralph

hi Ralph

please, follow to https://docs.algolplus.com/algol_order_export/fields/
add keys _custom_street and _custom_po
use PHP code

add_filter( "woe_fetch_order", function($row, $order ){
$address =  trim($order->get_shipping_address_1(). " ".$order->get_shipping_address_2());
if(preg_match("#^(.+)\s(\d\S*)$#",$address,$m)){
  $row["_custom_street"] = $m[1];
  $row["_custom_po"] = $m[2];
}
return $row;
},10,2);

Wow, great! Many thanks!

you’re welcome