> I am doing a PROCTIME report and outputting to a csv file. Then I am > using a script to read the page requests from this into an XLS > document. However, I have noticed some discrepancies in the data I am > getting in different reports - i.e. sometimes the report has '0.05- 0.1 > ' and other times it has '0.05-0.1 ' and the spaces at the end of the > line vary too from no spaces to 4 or 5 spaces. As I am wanting to read > the data from 16 separate csv files into the same XLS document, this is > proving to be a problem. > > Has anyone seen this before? Is it a bug in the program or am I doing > something badly wrong?
No, the spacing is something Analog adds so that, in a mono-space font (such as the HTML reports use) the two columns of numbers will add up. It should not be very hard to have your script strip the whitespace. If you are using Perl, something like this should work: s/\s*//g; -- Jeremy Wadsack Wadsack-Allen Digital Group +------------------------------------------------------------------------ | This is the analog-help mailing list. To unsubscribe from this | mailing list, go to | http://lists.isite.net/listgate/analog-help/unsubscribe.html | | List archives are available at | http://www.mail-archive.com/[email protected]/ | http://lists.isite.net/listgate/analog-help/archives/ | http://www.tallylist.com/archives/index.cfm/mlist.7 +------------------------------------------------------------------------
