parsing variable digits cleaning unwanted characters

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Posts: 3
Joined: Thu Jan 13, 2005 8:36 am

parsing variable digits cleaning unwanted characters

Postby 990405 » Thu Jan 13, 2005 8:41 am

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:

Piazza Velasca 5 - 20122 Milano (MI)
TELEFAX 02/8690963


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


User avatar
DataMystic Support
Site Admin
Posts: 2140
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Postby DataMystic Support » Thu Feb 24, 2005 8:49 am

How is this a problem - surely you just need to replace '*' with a comma ',' ?

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Yahoo [Bot] and 3 guests