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.

VI Job How can I import a job with forced return?

Posted By Futureguard 5 months ago

I am importing new item descriptions and it includes a character return (alt enter). If I enter it in the file, it causes the entry to error out when imported. Is there another way I can import it or will we have to go in and manually enter the hard return?

Thanks

Parents

0 zip 5 months ago

First, in the .xls do a 'Find/Replace' of carriage returns with a pipe, i.e. for the 'find' value do Ctrl-J (which should give a blinking period) and replace with | (pipe). Then in your import on the item desc field, use a Calc with something like this: SUB(Temp001$,"|",$0d$). This basically takes the item desc in the VI temp field and replaces all pipes with a carriage return.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 zip 5 months ago

First, in the .xls do a 'Find/Replace' of carriage returns with a pipe, i.e. for the 'find' value do Ctrl-J (which should give a blinking period) and replace with | (pipe). Then in your import on the item desc field, use a Calc with something like this: SUB(Temp001$,"|",$0d$). This basically takes the item desc in the VI temp field and replaces all pipes with a carriage return.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Kevin M 5 months ago in reply to zip

Beware of using the pipe "|" character like that. It can really mess up the VI job. Here are my notes on the technique.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

VI Job How can I import a job with forced return?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING