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.
[{"Product":{"code":"SSSHCT","label":"Rational RequisitePro"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Views","Platform":[{"code":"PF033","label":"Windows"}],"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","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21243723