1. What is the problem? Be very detailed.
quiero escanear un codigo que se tiene en archivo csv como puedo hacer que solo acepte esos codigos como texto correcto actualmente uso esta expresion y funciona regex (., '^(?i)(\W|^)(APPLE|ORANGE|RED|BLUE|A5|A6|A|B|9|10|) (\W|$)')
hay algo mas rapido usando el csv
2. What app or server are you using and on what device and operating system? Include version numbers.
EXCEL 2016 ODK V2022
3. What you have you tried to fix the problem?
REVISAR EJEMPLOS ELABORE UNA FORMULA EN EXCEL PARA REGEX
INVENTARIO.zip (50.2 KB)
I would like to know if it is possible that the scanned ids are only the ones that I have in the csv file something easier than this : regex (., '^(?i)(\W|^)(APPLE|ORANGE|RED|BLUE|A5|A6|A|B|9|10|) (\W|$)') so that someone who does not know how to use the code can add more products or services
I share the xls file I made for regex list of 1000 options
thanks