Returning Data on One Line

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

stephanie

Returning Data on One Line

Postby stephanie » Thu Feb 03, 2005 5:21 am

Hello,

I have textpipe v6.2.9. I am running an extract matches filter where the data entered looks like this:

4373 Holiday Hills Dr please call 903-940-2843

The filter I designed works just great, it extracts the address and phone number (which is what I need it to do). However, when it returns the information it gives it to me like this:

4373 Holiday Hills Dr
903-940-2843

Is there a way to have it return the information like this:

4373 Holiday Hills Dr 903-940-2843

Thanks!

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

Postby DataMystic Support » Fri Feb 04, 2005 10:06 am

Yes - don't include a new line in the replacement text. What are you search string and replacement string?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Guest

Postby Guest » Tue Feb 08, 2005 9:49 pm

How do I not include a new line in the replacement text? My search string is a string of variables separated by the | alternative. When it picks up one of the alternatives, it places it on a new line.

So for example, in a text file it will pick up the first alternative

4373 Holiday Hills Dr

Then the next alternative is 903-940-2843

which it places on a new line.

The entire string is far to large to post here.

Thanks in advance for your help. :)

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

Postby DataMystic Support » Wed Feb 09, 2005 10:00 am

Make sure the replacement string does not end in a new line or \r\n characters.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Guest

Postby Guest » Thu Feb 10, 2005 6:16 pm

Thanks for the reply. The replacement string does not end in an \r or \n. They just simply end when the string is complete.

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

Postby DataMystic Support » Thu Feb 10, 2005 8:54 pm

Then you must be capturing the \r\n from the end of the text, and then outputting it to the replacement. TextPipe does not add any text.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


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

Who is online

Users browsing this forum: No registered users and 1 guest