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.

Removing delimiter from end of record when exporting data

Posted By BirdDog over 5 years ago

I have a VI job that exports data from the AP_VendorRemit file to a pipe delimited file. The last field in a record has a pipe after it and then the carriage return. The people who we are exporting the data for told us they do not want the pipe after the last field. Is there a way to configure the export job in VI to exclude the delimiter after the last field of a record?

I tried a comma delimited file and the same thing happened.

0 BShockley over 5 years ago

Not sure if V/I can do this, but it should be pretty easy in Crystal Reports. In Crystal Reports, you can use the "On Last Record" function to control was prints or does not print on the last record.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 5 years ago in reply to BShockley

When I need exact control of output I use a Crystal Report and create a formula to calculate a long string value (manually inserting all the required delimiters), then export as text (not delimited).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 SamW over 5 years ago

I ran into this and here's what I was told to enter in the Perform Maint of the Export Job:
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Removing delimiter from end of record when exporting data

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING