Search results for query: *

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

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

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

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

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

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

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

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

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,

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

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

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