Exporting Address state and country

-- HikaShop version -- : 4.0.0

Hello,
I'm using CSVI Improved to setup a custom export of customer orders as I need to rename the field titles and merge some fields together to make the order processing smoother and quicker once the CSV is generated.

However when I export the shipping_address_state and the shipping_address_country fields it is exporting as so:

state_Cambridgeshire_4062

country_United_Kingdom_222

I do not need the additional text either side of the underscores and only need the text in between the underscores.

How can I remove this additional text stored in the HikaShop database tables?

Thanks

Lee

Hi,

In case it will help i would like to note that CSVI component has brilliant plugin where you can find and replace fields. Please check my screenshot attached. We do replace country by it's ID or whatever we need so you could do same for each state or country.

kyratn,
Thanks for your reply. I did find the Find / Replace plugin and I'm able to setup an action to remove the 'state_' and 'country_' prefix to each of the fields. This works well, however it is the text after the state/country which begins with the _underscore and then has a series of numbers.

Because my client ships to countries around the world I would need to create possibly hundreds of actions to cover every state within each country, for instance just for the United Kingdom there are 48 counties alone. Multiply this for countries around the world and the number of actions would be huge!

Is there no find / replace action I can use so that any text that appears after the underscore is removed, I tried using _* but that then replaced everything as it applies to the entire text!

I'm not a PHP / MySql guru but would setting up nine actions that would use _1* to _9* as the find / replace option work?

Thanks

Lee

OK so I found the solution on my own, by setting the Find / Replace to use Regular Expression and then setting entering this into the search box:

/\_[0-9]*/

With an empty replace box, the underscore and number after the county / state / country are successfully removed.

Combine this with another rule to remove both state_ and country_ from the beginning and now the exported data is 'cleaned' and the correct data is exported.

Lee