I learned this trick from @ludekvolejnik – a master of regular expressions
So far I have shown that in Blending Bull you can parse variables from a text. Then you can use these variables in output file generation. See an example where I processed data from an XML file to CSV for import to Mergado. By a regular expression in the “Find text in a data source” field, I got two variables.
The regular expression was:
Then I entered the following into the “Replace for text” field:
I marked the variables as
\g<X> where X was the number of order in input text.
The described procedure works reliably if both the variables are listed in all items. I, however, came across a situation when it was not clear. And @ludekvolejnik showed me the following:
This corresponds to
(.*?) but it has one interesting feature. You will write it into the output as:
which means the individual variables can be named!
Example how to generate CSV file form XML feed
Replace for text:
I consider naming variables better than order. The notation looks difficult. I will save this website among the bookmarks in the browser. And once I need the notation, I will copy it from this example