IBM Support

How to remove spaces in a csv file which affect the hierarchy of imported requirements in a RequisitePro view

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:

  1. Open csv file in Microsoft® Excel
  2. Select the Tag column
  3. Select Edit > Replace then select the Options button
  4. Select the Search drop down and select By Columns
  5. In the Find what field input a space and leave the Replace with field blank
  6. 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"}}]

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

Manage My Notification Subscriptions

Page Feedback