Hi folks,
Some time ago, I asked for a way that I can use a SQL/HTML etc to become a entire script for some propus as make a string that represent a SQL request or a HTML to be loaded and create a final file.
Well, I made it with some simple ideas… I used a file reader and groupt nodes to make a single row!
For this context, here the flow:
From “File Reader”, I select an html file, set for delimiter as ‘pipe’, as for the other setup options (quotes and escape).
I select short data rows because can represent some possible sittuations that can make some mistakes.
As the print below, You can see the result as preview.
From ‘Groupby’, I just make a concatened with the expression ‘\n\r’ as a term to make it as “regular expression” for newline and return carrier.
At the end for this process, I just rename the column with a new name for my propous.
Result: A single cell with all lines for the script!
I hope that trick can help you!
Thanks,
Denis Iongbloed