correcting the alignment of table data
Posted: Mon Sep 29, 2003 4:38 am
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:
________________________________________
Total USDA - Subsidies
......$0......$0......$107,863......$282,455......$163,739......$234,400......$788,458
Subtotal, Farming Subsidies
......$0......$0......$107,863......$282,455......$163,572......$216,740......$770,631
Production Flexibility Contracts
......$0......$0......$64,717......$62,288......$58,899......$53,909......$239,813
Production Flexibility - Corn
......$0......$0......$64,717......$62,113......$58,731......$53,774......$239,335
Production Flexibility - Wheat
......$0......$0......$0......$175......$168......$135......$478
__________________________________
The table above didn't illustrate properly so I substituted "......" in the illustration above to represent the six spaces actually occuring.
I would like to align the columns of numbers either on the $ sign, or on the decimal.
Any assistance would be appreciated!
My source looks like this:
________________________________________
Total USDA - Subsidies
......$0......$0......$107,863......$282,455......$163,739......$234,400......$788,458
Subtotal, Farming Subsidies
......$0......$0......$107,863......$282,455......$163,572......$216,740......$770,631
Production Flexibility Contracts
......$0......$0......$64,717......$62,288......$58,899......$53,909......$239,813
Production Flexibility - Corn
......$0......$0......$64,717......$62,113......$58,731......$53,774......$239,335
Production Flexibility - Wheat
......$0......$0......$0......$175......$168......$135......$478
__________________________________
The table above didn't illustrate properly so I substituted "......" in the illustration above to represent the six spaces actually occuring.
I would like to align the columns of numbers either on the $ sign, or on the decimal.
Any assistance would be appreciated!