Troubleshooting
Problem
This technote provides steps to remove spaces from a comma separated file (CSV) which affect the hierarchy of requirements when imported into IBM® Rational® RequisitePro®.
Cause
In a CSV file, if there is a extra space after the requirement tag, the hierarchy of the requirements is lost. This problem is usually seen when a view is exported to a csv file. To make sure that the hierarchy is not lost please follow the following steps to remove the extra space.
Resolving The Problem
This issue was logged as a defect under RATLC00480297 which has since been resolved in RequisitePro version 7.0 and later.
Workaround:
Steps to automatically remove spaces in the CSV file:
- Open csv file in Microsoft® Excel
- Select the Tag column
- Select Edit > Replace then select the Options button
- Select the Search drop down and select By Columns
- In the Find what field input a space and leave the Replace with field blank
- Select Replace All.
Selecting Replace All will eliminate all the spaces in each row of the Tag column.
Was this topic helpful?
Document Information
More support for:
Rational RequisitePro
Software version:
2003.06.00, 2003.06.01, 2003.06.10, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15, 2003.06.16, 7.0, 7.0.0.1, 7.0.1
Operating system(s):
Windows
Document number:
85041
Modified date:
16 June 2018
UID
swg21243723