To "Guest":
Thanks for the feedback. The following are the results:
The pattern \$[\d,]+? did great job of finding all the combinations of the dollars ( $1; $12; $123; $1,234; $12,345; $123,456 ).
The pattern \$\d{2} (etc) works great as long as I include a "space" character in the pattern. This ...
Search found 3 matches
- Sat Oct 04, 2003 4:43 am
- Forum: TextPipe Tips and Tricks, Questions and Support
- Topic: correcting the alignment of table data
- Replies: 4
- Views: 23313
- Fri Oct 03, 2003 6:37 am
- Forum: TextPipe Tips and Tricks, Questions and Support
- Topic: correcting the alignment of table data
- Replies: 4
- Views: 23313
Round two - isolating columns in a table
Hey Simon,
Thanks for the reply.
1. The number of records I have to process exceeds Excel's capacity.
2. I tried a) replacing the six spaces between the numbers with tabs but the alignment of the columns was still incorrect. The size of the numbers (ranging from "$0" to $9,999,999) was greater ...
Thanks for the reply.
1. The number of records I have to process exceeds Excel's capacity.
2. I tried a) replacing the six spaces between the numbers with tabs but the alignment of the columns was still incorrect. The size of the numbers (ranging from "$0" to $9,999,999) was greater ...
- Mon Sep 29, 2003 4:38 am
- Forum: TextPipe Tips and Tricks, Questions and Support
- Topic: correcting the alignment of table data
- Replies: 4
- Views: 23313
correcting the alignment of table data
I am trying to improve the alignment of data first sourced in an HTML table. TextPipe was great about stripping off the HTML tags and has left me with the data I'm interested in but I would like to see the data line up in columns or tabbed properly.
My source looks like this ...
My source looks like this ...