Yeah, sorry. That doesn't work. I looked at some of my old 8.3 code where I had create each line of an EDI file ending with ~ but no CRLF and I ended up with something like Create

Leave your I/O file line as None, leave your data only on the first form, create a 2nd form, 2 wide, put ascii(13)&ascii(10). Output the the second form in the record prefix with the condition NOT

If the output file is not too large, you can load it into a blob and thenremove the last 2 characters and then recreate the file. update B = file2blb('c:\file.txt') where B is a blob

Format = None output trim(data)&chr(13)&chr(10) This result : Format = None output trim(data)&chr(13)&chr(10) De: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] En

The EOF function that I mentioned is to know the last line on a conversion of files process... from a IO entry to read to IO entry to write, this with Format=None.

Perhaps you can clarify why this is needed. I don't think there's actually an extra line created, the final text line just ends with chr(13)&chr(10) You can tell for sure

Set the IO properties to Format =None. End each line except the last with chr(13)&chr(10). That is, output trim(data)&chr(13)&chr(10) Alternatively, if you don't know

8.30 De: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] En nombre de Steven Blank Enviado el: Martes, 21 de Julio de 2020 03:31 p.m. Para: main@magicu-l.groups.io Asunto: Re: [magicu-l]

What version?

The cursor is positioned on the next line and I want it to be positioned on the last line at the end Regards Andres De: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] En nombre de

You can try changing the Format on IO properties to None, this stop the native line ending control from Magic. Use the EOF function to check for the end of file reached... and for every line output

How to remove the blank line that is generated when reaching the end of a text output file Regards Andres

Hi Group, I have just faced the following problem with MSSQL database: I have 2 DATETIME fields in MSSQL with database default value: 1901-01-01 00:00:00. There is a date and a time field

Has anyone come across the magic "windows" on some devices on IOS 13 not filling the screen properly - It happens on iPhone x and Ipad pros. The window sits inside the full-screen parameters, when you

There are free programs available to create digital signatures with certificates on PDF documents: http://wiki.cacert.org/PdfSigning

Dear All, Are there any ways to add Digital signatures to mass produced PDFs? I would like to see if there are any free command line tool options, similar to pdftk? Thanks in

Hello Roman! Yes, the SQL server is local to me. Didn't want to work with the productive server for it. I followed the instructions (link) and I think it worked too. Regards, wolfgang

Thanks Steve, yes this worked. Lado

Lado, Try replacing your expression with the following: 'ENG Hours' & ASCIIChr(10) & Trim(BG) Steve Blank

Hi Group, Can someone suggest on how to fix the below problem: I need highlighted column header to be read as below: ENG Hours 07/27 - 07/31 See my expression in the picture below. Thanks Lado