How do I make a field have spaces for X amount of characters

[opinky]

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 end of the field.
I could email a print screen of how it looks in ultra editor when i am comparing the files but kind of looks like this:
good file 012365 ARROW INC........... (THE DOTS ARE SPACES)
bad file 012365 ARROW INC LF (THE LF IS THE LF SYMBOL)

 

[TeyBrady]

Something like this may help.

left({table.lastfield} + space(85), 85)

 

[opinky]

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

 

[CRCRCR]

Try chr(13)

i.e "string" & Chr(13)

k.

 

[opinky]

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

 

[lbass]

chr(10) is used for a line feed which is the equivalent of 0A, from what I can gather.

-LB

 

[opinky]

I had heard that also and tried the 10 as well and it still gives me the LF as opposed to end of line symbol.
thx