Home > Downloads & Services > RRR|Col2Del

RRR|Col2Del

updated 2007-09-27 11:39:16

Converts a fixed column text file to a file suitable for ARImport


Download RRR|Col2Del

usage: rrrCol2Del delimiter

This tool converts a fixed column text file to a file with a delimiter
suitable for ARImport.

A typical input file (person.col) may look like this:
Givenname Surname
Misi Mladoniczky
Louise Andersson

Run the following command from a command line or bat-file:
type person.col | rrrCol2Del ";" >person.asc

This would yeald an output file (person.col) with the following format:
Givenname;Surname
Misi;Mladoniczky
Louise;Andersson

Please note the following:
- This does not work if there is space in the column titles
- Make sure that the rightmost label has enough space added to the right
to accomodate for any data later in the file