Hi there,
We are evaluating BC3 as a more effective way of comparing differences in system specifications. The specifications are currently held in DOORs and we have exported the document at different versions to CSV format to compare side by side.
The initial test was to export only the first 15 columns of the specifications. This has worked well in BC3, with the exception of carriage returns.
(We have already found that we had to strip out carriage returns within individual cells (the documents are written with descriptive text in cells that contain carriage returns) as this confused BC3, it could not tell where the delimiting quotes started and ended).
However working with the full export results in tables in excess of 200 columns. We are having trouble displaying the results in BC3 and are wondering if there is a physical limit on the number of columns BC3 can handle in a CSV file.
If this is not the case then we need to look further into the DOORs export routines can see if there are any other embedded characters that could be mistaken by BC3 for being delimiters.
We are evaluating BC3 as a more effective way of comparing differences in system specifications. The specifications are currently held in DOORs and we have exported the document at different versions to CSV format to compare side by side.
The initial test was to export only the first 15 columns of the specifications. This has worked well in BC3, with the exception of carriage returns.
(We have already found that we had to strip out carriage returns within individual cells (the documents are written with descriptive text in cells that contain carriage returns) as this confused BC3, it could not tell where the delimiting quotes started and ended).
However working with the full export results in tables in excess of 200 columns. We are having trouble displaying the results in BC3 and are wondering if there is a physical limit on the number of columns BC3 can handle in a CSV file.
If this is not the case then we need to look further into the DOORs export routines can see if there are any other embedded characters that could be mistaken by BC3 for being delimiters.
Comment