Returning Data on One Line

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
stephanie

Returning Data on One Line

Post by stephanie »

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: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

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

Post by Guest »

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: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

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

Post by Guest »

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: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

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.
Post Reply