Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

ASCII Delimiters for VI Exports

Posted By Tim Turner over 6 years ago

Greetings: I am attempting to export some data with TAB delimited fields. I have my job File Type setup for Delimiter and I have the Use ASCII Delim. box checked and for my delimiter I have attempted to use the ASCII code for horizontal tabs of 9 but that does not work the max field length for the delimiter option is three characters so I also tried 09 and 009 but to no success when I make the change and attempt to run the job I get an error dialog box with the following message. So with that said what options can I put in for the Delimiter when I have the "Use ASCII Deim." set?

Error 0 in VI_ExportJobCompile.pvc,

Line 31 while generating export program

0 Tim Turner over 6 years ago

After digging in the help files it seems that I am doing what is correct by putting in the ASCII numerical value however I am getting the error. Here is the document from the help file.

ASCII Value

Select this check box to enter the numeric ASCII value in the Delimiter field. Clear this check box to enter the actual character.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tim Turner over 6 years ago

I found the issue. It was a corrupt VI job. Setting the "ASCII delimiter" box a and putting in 9 to the delimiter fields works on a new VI job.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

ASCII Delimiters for VI Exports

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING