That did not work it still gives me the LF. When I look at the hex editor it is giving me 0D0A AND I need it just to be 0A.
this is how i did it in the query
left({PYMT.REMIT_TO_NAME} + space(85), 85)& Chr(13)
Thanks
That worked great thanks the only thing I need to do now is have the end character be 'end of line' as opposed to 'CRLF'. Do you know how to do that? I have to put the file in a hex editor and the end of line characters are OA and CRLF characters are OD
Thanks
I have a file where the last field can be anywhere from 5-85 characters. currently when I export the file at the end of the characters it has a line feed. I am sending the file to a bank and the line feed shows as a period on the file. On a old file when I put it in text it has spaces till the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.