Returning Data on One Line

[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!

[DataMystic Support]

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

[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.

[DataMystic Support]

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

[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.

[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.