What can this tool do?

  • This tool allows you to create output based on a template. You specify what you want to output by using a template for the Header, Repeating Detail, and Footer. The Header is displayed once. The Repeating Detail is displayed once for each record of CSV data. The Footer is displayed once at the end.

What are my options?

  • You can manually create your template.
  • Or let us create your template via the Template Writer .
  • Here are a few of the templates we can create for you: CSV Columns to Rows
  • CSV to C Array
  • CSV to LDIF
  • CSV to HTML Description List - DL/DD/DT tags
  • CSV TO JIRA Table
  • CSV to List (Unordered) - UL/LI tags
  • CSV to LUA Array Table and Dictionary
  • CSV to Python Dictionary
  • CSV to RUBY Language
  • CSV to URL Query String
  • CSV to VbScript Array

What else?

  • Refer to Template Help as a reference Guide.

Step 1: Select your input


Step 2: Choose input options (optional)


Input Options
Limit # of lines: Skip # of Lines
Field Separator:

Step 3: Choose output options (optional)


Filter CSV Template - Query CSV by entering expression
Enter an expression that returns true(keep row) or false(discard), i.e. f3==4, f2>='A' && f2<='B'
Global Options on each field:
with Separator:

Step 4: Use our Sample Templates on Your Data (optional)


Let us write your template for you! Use these below with your data.
Template Writer Pre-built Templates

Step 5: Create a Template


Enter Template Here
Heading Template - text at beginning of output
For generating heading and field template below, use {h} for each heading field, and {f} for each field.
Heading : Before Each Between After
Field : Before Each Between After
Regular Usage - use {h1} {h2} ... {f1} {f2} ....
Heading:
Each Record Template - text for each line in CSV
{f1};{f3.toDollar()};{f2.toUpperCase().toCsv()}
Between Each Record Template - text between each line in CSV
Footer Template - text at end of output

Step 6: Generate Output from Template



Result Data:
Sort CSV  
 Field #TypeDirection
First By
Then By
Then By




You can Save the complete data and settings, and then later Load them from your saved file.