Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bob Brook
  Where is Bob Brook?
 Surrey
 United Kingdom
 Bob Brook
 To: Tyrone Matthews
  Where is Tyrone Matthews?
 Bristol
 United Kingdom
 Tyrone Matthews
 Tags
Subject: RE: Dodgy Text File
Thread ID: 228397 Message ID: 228646 # Views: 3 # Ratings: 1
Version: Visual FoxPro 9 Category: Other
Date: Wednesday, May 20, 2009 12:17:53 PM         
   


> Hi Guys,
>
> I am trying to find a way to get a file into a foxpro table should be a pipe deli format but there is a square where the carrigde return/line feed should be, does anyone have any idea of how i could make a program to change this or a way to change this i have gone back to the supplier but they cant do anything there end
>
> Kind Regards
>
> Tyrone

Not certain in what program/control/etc. you are seeing the small square, but will assume it is within VFP.

The small square is the default character that is shown when the ASCII/ANSI char. code does not have a printable value.

In this case it is probably the Carriage Return and/or Line feed chars (CHR(10) and CHR(13)).

Use a string replace statement like

lstr2 = STRTRAN(STRTRAN(lstr1, Chr(10), ""), CHR(13), "")

to remove the offending chars.
Bear in mind that they could also be Tabs, or any non-printable char.

Regards

Bob of Surrey, England

ENTIRE THREAD

Dodgy Text File Posted by Tyrone Matthews @ 5/18/2009 6:37:19 PM
RE: Dodgy Text File Posted by Stefan Wuebbe @ 5/18/2009 7:17:08 PM
RE: Dodgy Text File Posted by Koen Piller @ 5/18/2009 7:25:16 PM
RE: Dodgy Text File Posted by Ammar Hadi @ 5/18/2009 9:33:46 PM
RE: Dodgy Text File Posted by Bob Brook @ 5/20/2009 12:17:53 PM