Skip to main content
  • EN

I need to output an SQL script created with SQL Creator in a custom text file. The file is essentially a csv file but with '|' as the seperator, the header row prefixed with a 'H|' the rows of data prefixed with 'B|' and a footer containing F|<file_id>|<datetime_stamp>|<number_of_rows>

creating a csv file using '|' is easy enough but I haven't found a way to do the prefixes or footer. I was looking at using XML Templater but not sure if I'm barking up the wrong tree.

 

Any guidance would be greatly appreciated.

I would be tempted to use a Creator and AttributeCreators, along with a StatisticsCalculator or Aggregator to get the Feature count and send them all to a text writer.

 

 

 

Another thought. Create a CSV file without footer line using the FeatureWrite (Format: CSV), then create and append footer line to the file aftterward.

Reply


Community Stats

31,800
Posts
120,794
Replies
39,417
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.