DSXchange

Check with your UNIX system administrator. There may have been a file size limit set on your user id.

Try:

stringField=substring(string,
starting_position, length)

Where stringField is the output column and string is the input column.

Try using the following format when converting from a string to a date:
%mm/%dd/%2000yy

This will translate any yy on the input to 20yy.

When translating back to a string (for output), use the following format:
%yyyy%mm%dd

For Parsing Excel from Perl, take a look at the following URL:

http://www.opensourcetutorials.com/tuto ... page1.html

You will probably need to install the Perl Modules referenced in the article.