Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Koen Piller
  Where is Koen Piller?
 Koen Piller
 To: Tyrone Matthews
  Where is Tyrone Matthews?
 United Kingdom
 Tyrone Matthews
Subject: RE: Dodgy Text File
Thread ID: 228397 Message ID: 228414 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Other
Date: Monday, May 18, 2009 7:25:16 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

Hi Tyrone,

Try to make use of Chrtran() function
something like:

lcTableField = myTable.Field
lcUnwantedChr = chr('x')
lcReplacement = chr('y')
lcCleanedField = CHRTRAN(lcTableField,lcUnwantedchr,lcFReplacement)




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