Search Forum Home   Visual FoxPro  Baze de date, tabele, view-uri si indecsi  Stergere caract...  Stergere caracter....!!!    4/4/2009 5:42:07 PM valy.m 221 posts Stergere caracter....!!!  (N/A) Salutare baieti. Am si eu o intrebare... Am o tabela in care am importat un fisier de tip text, dar imi apare la un moment dat prin campurile acestei tabele caracterul '|' (fara ' '). Spuneti-mi si mie va rog cum pot face sa sterg acest caracter din toate campurile tabelei? Valy Maties - Beginner programmer  4/4/2009 9:58:42 PM mr_api 353 posts Re: Stergere caracter....!!!  (Romania) CLOSE DATABASES SELECT 0 USE mytable  COPY STRUCTURE TO tbltmp  extende SELECT 0  USE tbltmp     SCAN FOR field_type='C'     wfldname=ALLTRIM(field_name)      SELECT  mytable      REPLACE ALL &wfldname WITH STRTRAN(&wfldname,"|","")     SELECT tbltmp     ENDSCAN * BROWSE  CLOSE DATABASES    Page 1 of 1   Visual FoxPro  Baze de date, tabele, view-uri si indecsi  Stergere caract... Flat View Tree View Oldest To Newest Newest To Oldest