DataMystic

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,

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

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

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.

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

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

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