Search found 7 matches

by lg777
Fri Oct 26, 2012 11:57 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Excel xlsx files
Replies: 1
Views: 3938

Excel xlsx files

I am trying to use the excel spreadsheets to text feature and it works great for xls files but doesn't seem to work for xlsx files. Is there something different that I need to do?

I am using this to basically mimic saving a file as CSV in excel and using the CSV file to process.

Thanks,
by lg777
Fri Aug 24, 2012 7:33 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Help with multiple line items
Replies: 10
Views: 14024

Re: Help with multiple line items

Thanks! Unfortunately won't load in my latest version 8.6.1. I got some of these working and would like feedback if it is either an okay way to do it or not. For the invoice one I started, I simply match a cr and Invoice and replace with just Invoice to merge all the invoice lines together. Seems si...
by lg777
Thu Aug 23, 2012 8:49 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Help with multiple line items
Replies: 10
Views: 14024

Re: Help with multiple line items

Thanks! I'm not sure I understand the script yet but I'll dig a bit deeper. In the same vein, I have something like this that I need to figure out and not sure if the script will help as well but here it goes: From: Colour, Red A,1 A,2 A,3 A,4 Colour, Blue A,1 A,2 A,3 Colour, Green A,1 A,2 A,3 A,4 A...
by lg777
Wed Aug 22, 2012 3:07 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Help with multiple line items
Replies: 10
Views: 14024

Re: Help with multiple line items

Sorry to bring this up but is it possible to get a text output of that script contained in the zip file. I have to use an older version so I just need to get an idea of how the perl expressions were used.

Thanks in advance.
by lg777
Wed Apr 11, 2012 12:28 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Help with multiple line items
Replies: 10
Views: 14024

Re: Help with multiple line items

Yikes, I can't read this as I'm using an older version, 8.1.1. Is it possible to send me the text of the script? And many thanks for helping. Got another question about my example though: In Payment 1, I can use a Exact search/replace by using [capture(csvfield)],[capture(csvfield)] to capture the f...
by lg777
Fri Apr 06, 2012 11:48 am
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: Help with multiple line items
Replies: 10
Views: 14024

Help with multiple line items

I need to convert an invoice that looks something like this: Payment 1 Invoice 1,$2000 Invoice 2,$3000 Invoice 3,$4000 Invoice 4,$5000 Total,$14000 Payment 2 Invoice 5,$100 Total,$100 Payment 3 Invoice 6,$100 Invoice 7,$100 Invoice 8,$100 Total,$300 Output: Payment1, Invoice 1 - $2000 Invoice 2 - $3...
by lg777
Thu Dec 01, 2011 12:15 pm
Forum: TextPipe Tips and Tricks, Questions and Support
Topic: PO Box Patterns
Replies: 3
Views: 4443

PO Box Patterns

I need help with PO Box searches. Any combination of P.O. Box, PO BOX, P O Box, etc... I tried some perl patterns I found on the internet and they don't work in Textpipe so maybe there's a better Easy Pattern method. What I'm trying to do is look at an address field and if I see any mention of post ...