Task

A vendor sends a price list where the price is stored as USD 24.90 and the minimum order as min 6. The import needs separate vendor_code, name, unit_price, currency, and moq fields.

Short answer

For price, use the regular expression [0-9]+(?:[,.][0-9]+)? (finds an integer or decimal number: one or more digits plus an optional decimal part after a dot or comma). If the currency prefix is always the same, a simpler option is to remove the USD substring and keep the number.

How to do it in Eofferix

Method 1: use a regular expression in Eofferix

Create the output column unit_price_regex from unit_price_raw.
Open the column settings and check the preview.
The animation shows opening the settings of the output column.
Add a rule: condition Regular expression, value [0-9]+(?:[,.][0-9]+)? (finds an integer or decimal number: one or more digits plus an optional decimal part after a dot or comma), action Remove everything except.
The rule keeps only the numeric price part from the supplier value.

Method 2: use substring search in Eofferix

Create a second output column unit_price_text from the same source field.
Open the settings of unit_price_text.
Use this variant only when the currency prefix is stable across the supplier file.
Add a substring rule: condition contains substring with the currency prefix, action replace substring, result empty.
For Replace substring, the search text is in the condition; leave the result empty to remove it.

Before / after

Before

source data

vendor_item	description	unit_price_raw	moq_raw
VN-1001	Hudson desk lamp	USD 24.90	min 6
VN-1002	Parker lounge chair	USD 139.00	min 2

After

result

vendor_code	name	unit_price	currency	moq
VN-1001	Hudson desk lamp	24.90	USD	6
VN-1002	Parker lounge chair	139.00	USD	2

What to keep in mind

A regular expression is safer when suppliers vary currency, spaces, or decimal format.
Substring removal is faster to maintain for stable values such as USD 24.90.
Use the same number extraction for MOQ values such as min 6.

How to prepare a vendor price list for import