frank

frank

  • NA
  • 7
  • 0

parse text files using field data defined in xml

Mar 24 2013 12:09 PM

tried to google this but no idea how to define the search.

Looking to do a POC for parsing various file formats (mostly delimited and fixed length) where the variable names, data types etc are all defined in an xml file.

The idea is to re-use this code in various programs rather than a proprietary ETL tool or SSIS.  1 is limited in it's ability, 1 is limited in its ability to be maintainable with lengthy programs that contain many conditional calculations.

Any ideas on information or thoughts on how to word what I'm looking for in a search engine?

Thanks in advance.