Page 1 of 1

parsing variable digits cleaning unwanted characters

Posted: Thu Jan 13, 2005 8:41 am
by 990405
I am new to texpipe and I am having difficulty understandingthe filters
my problem is outlind below, I need to transform all into excel fields

One of the difficulties is separation into different fields and clean unwanted characters
Any suggestions?

Would like to get all on one line like below:
ALPINA S.P.A. *Piazza Velasca 5 *20122 * Milano *MI* TELEFAX* 02/8690963

actual data is given below:



ALPINA S.P.A.
Piazza Velasca 5 - 20122 Milano (MI)
TELEFAX 02/8690963



--------------------------------------------------------------------------------

ASA
Largo Arturo Toscanini 1 - 20122 Milano (MI)
Tel. 02/76001659 - TELEFAX 02/782517



--------------------------------------------------------------------------------

Posted: Thu Feb 24, 2005 8:49 am
by DataMystic Support
How is this a problem - surely you just need to replace '*' with a comma ',' ?