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!

Register Log in
  • Congratulations derfloh 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. dataslinger

    text replacement for CR/LF characters

    Olaf, You solved it. The issue has been that the one space would be missing when replacing the lone CRs, while lone LFs would have the expected space, even though they use the same replacement. As stated in your first paragraph in your last post, there needs to be a 1:1 between characters...
  2. dataslinger

    text replacement for CR/LF characters

    Thanks. I'm surprised the code works completely for you, for me, where it takes out the lone CR, the expected space is missing. It's mostly right, and by no means terrible. Assuming I found this correctly, they are: version: VFP 9, sp2, w/hotfix code page: "1252" collage: "machine"...
  3. dataslinger

    text replacement for CR/LF characters

    Hi Olaf, Thanks, did you download the last uploaded file (from post 8 Sep 15 20:09)? The first file that I could not delete from the thread, did not have the pairs, but the latest one does. If you look at the second file in a hex editor the CR/LF pairs are visible and OCCURS will be > 0...
  4. dataslinger

    text replacement for CR/LF characters

    Ok, correction, it didn't quite work. I agree that "chr(13) + chr(10)" should work, since you can list multiple characters w/CHRTRAN, but it doesn't in practice. The stray 0A is doing exactly what it did for me, which is that it disappears and there is no replacement character (space) in the...
  5. dataslinger

    text replacement for CR/LF characters

    That does do it, thank you very much Tbleken. I uploaded a corrected sample file (my issue), just for posterity in case someone uses this thread: Link http://files.engineering.com/getfile.aspx?folder=aa483037-086c-4c00-8e47-526371afd580&file=test.csv
  6. dataslinger

    text replacement for CR/LF characters

    File upload to website keeps changing the CR/LF characters in the file. Will try one last time. There should be a CR/LF pair at each end of line, one lone CR, one lone LF.http://files.engineering.com/getfile.aspx?folder=7f3da61b-efc8-40bd-b267-1ac2d02320e8&file=test.csv
  7. dataslinger

    text replacement for CR/LF characters

    Scott, Per post I already tried CHARTRAN, but I did again for you here and it didn't work. Per VFP, CHARTRAN & CHARTRANC are equivalent for single byte characters so it's not wrong and not the problem ... and I don't have a preference for either one so let's just use CHARTRAN and move past...
  8. dataslinger

    text replacement for CR/LF characters

    Scott, I understand this works I appreciate that you want to help, but per post, this is for a file. Please try this with a few lines of data in a file with isolated CRs and LFs here and there (not only as a pair), the CRs will essentially go missing. Thanks
  9. dataslinger

    text replacement for CR/LF characters

    Thanks but no dice. I mentioned I tried that before, but tried again here and it made no difference. My thought was perhaps handling CR as double-byte could help. Regardless, per VFP documentation,
  10. dataslinger

    text replacement for CR/LF characters

    Hello, I need to programmatically read in a text file that are occasionally sprinkled with misplaced single carriage returns (hex 0D/dec 13) or line feeds (hex 0A/dec 10) and then eventually import to a table. When the CR/LF characters are together in a proper pair, I would like to keep them...
  11. dataslinger

    Box Copy of VFP9

    Thanks for the responses so far. I had some of the brown VFP9 boxes back in the day, ideally that's what I'd like to find. I realize I can download SP2, etc. I didn't think you were allowed to get VFP9 from MSDN and then use it for production; perhaps I'm confused on that point as it seems...
  12. dataslinger

    Box Copy of VFP9

    Hello, I'd like to pick up a copy or two of version 9 (full version). I imagine there are a lot of these around to be had but I've searched about everywhere else on the web including e-bay with no luck. Do any of the old salts in here know someone willing to part with theirs? Thanks in advance

Part and Inventory Search

Back
Top