DataMystic

DataMystic Support wrote:Good luck with your Uni project!

LOL

Hi pakiyabhai,

I think this is something that could be done in TextPipe.

What do you want to do exactly? Can you post the output of the text you would like to see.

Anthony.

simoninsing wrote:Many thanks Anthony. It looks great. I'll need to upgrade to Pro to use it, which I'll do soon ... as soon as I feel rich enough !

Best purchase you'll ever make. You wont regret it!

Yeah, Text Pipe Pro is the best tool out there for text manipulation, and writing regular expressions is like writing poetry, when it works!

Hi,

I have created a filter that will do this also using the restrict to each line in turn filter.
TextPipeForum_Filter_for_simoninsing_By_AnthonyFitz.zip
I tested it on the following input, and got the following output.

Input
apple, pear, tamarillo, orange, banana, "custard apple"
pear ...

Hi WzevGIlK,

I think this filter should work for you. I did some tests and it seems to work on the sample data I threw at it.
TextPipeForum_Filter_for_WzevGIlK_By_AnthonyFitz.zip
Input
Seattle,any,any,any,any
Seattle,any,any,any,any
Seattle,any,any,any,any
Boston,Boston-any,Boston-any,Boston ...

Yes, this is because all text editors try to guess the text encoding of a file, unless it has a BOM (byte order mark).

They all use different algorithms to calculate this. Also they don't read all of the file, they only read a small portion to use as a test sample and the size of this sample is ...

Perfect, thanks Simon!

Amazing, super fast support. Top Class!

Anthony.

Hi Simon,

I'm creating a tool in VB that takes in user input and runs a textpipepro filter in command line mode which outputs to the clipboard. Then the tool silently opens up excel and pastes this data into a specific column.

Everything is working great except that its pasting corrupted ...

Excellent, thats exactly what I was looking for.

I know, RTFM

Cheers,
Anthony.

Hi Simon,

Would it be possible to enable customization of the Right Click menu for text pipe pro so that you can add your own filters to the list for quick execution.

This could be something like a INI file with 2 Variables like Display Name, Full Path to Filter file, and maybe another Boolean ...