Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. opinky

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

    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
  2. opinky

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

    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
  3. opinky

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

    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
  4. opinky

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

    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...

Part and Inventory Search

Back
Top