Sage 100

Is it possible to put a CR/LF in a VI Export job? CHR(13)+CHR(10) isn't working as a Temp Calculated field.

Never mind - why do I always find the answer right after I post? $0D0A$

Dang it, still having an issue. I am trying to create an export that will have multiple lines per record. The temp field $0D0A$ is being delimited itself with commas. Anyway around this? I have a "", at the start of the 2nd and 3rd lines that I don't want.

Is it an possible to remove the commas with ""Convert Delimiter in Data to Space"" option?

I need them everywhere else (pouty face)

:(

this worked in v2015

I'm exporting, not importing...

ah, my bad.

well...from v2015's help, looks like temp fields can't be exported. ""Select Calculated to assign a column name field or temporary field using a valid expression entered in the Calculation field. The expression may contain other temporary fields. Use this operation to assign a value to a temporary field when the field should not be exported but is used in calculation or conditional expressions for other fields.

Oh, they're exporting - but it's putting """" around the CR/LF

Beth the way it has to work is on the Perform Logic Job Completion event, you need to kick off either Perform Logic (providex) or a script that will take the exported file and insert the CRLF (a.k.a. vbCRLF) at the end of each line. Probably you want it to strip the ending comma as well which was happening to me (see attached). In attached script, I made a copy of the V/I exported file from an A/P Vendor export and purpose was just to remove trailing comma at end of each line but you can also add vbCRLF after the WriteLine command. I'm sure Mr Speck 2 can take over from here :)

found another way to do it. realized that if you leave the temp field type as ""assign"", you can still do a calculation and have the result exported. are you wanting clean/blank line breaks after the last column or between columns?

I am trying to create 3 lines of export from every 1 record I read in Sage. I am getting the CR/LF to work, BUT it is putting a "" at the end of the one line and "", at the start of the next and I need to get rid of those.

OK, @AlnoorCassim and @DavidSpeckII - I may have enough to go on, and at least I have enough to keep me busy at 2 AM when I might be getting bored.

My suggestion would be to expound on Alnoor's post-edit idea. Insert a temp field that will assign some obscure ascii character that will never be used in the data and then run a vbscript to replace the trailing comma, double quote, character, double quote, and comma in one replace call with vbcrlf.

VI for imports. Visual Cut (Crystal Reports tool) for exports.