I'm working on setting up an import using WP All Import, the idea is to update/add/remove posts within a custom post type which contain ACF fields.
The CSV we are importing contains a column called "Feed ID" which holds data like Apple12343, Banana98799, Carrot2198379, Onion1287361 and so on.
What I want to achieve is to populate an ACF select box value that has options like 'Fruit' and 'Vegetable', depending on the Feed ID value, using XPath. So essentially I need some sort of function that will take the first part of the feed ID (letters only), then assign the select box value based on that. Is this doable?