Hello!
I would like to understand how "applyRegularExpressions" works and ask if it is a best solution for my design.
I have a field with the following structure:
"AAA/BB/CCC/DDD/EEE/FFF/GGG/HHHH"
only the first 5 groups of letters will represent the idno of a collection, in this example:
idno= ""AAA/BB/CCC/DDD/EEE"
I was trying to use "applyRegularExpressions" as "Options" in mapping using this expression:
{“applyRegularExpressions”: [
{
“match” : “([a-zA-Z0-9]+)”,
“replaceWith”: “\\1\\/\\2\\/\\3\\/\\4\\/\\5”
}]}
But when I try to upload de mapping file it is not being imported ( when I remove the Option it works so I know that the problem is here)
I would like to know if the configuration of applyRegularExpressions is ok, and also understand if i am using this correctly. Maybe the problem is that i am trying to use Options and Refinery at the same type, but I didnt find any reference to dont be allowed to use both.
You can find attached the mapping, the problem is in mapping 3
I would really appreciate your help! Thanks in advance :)
