issue with pipe delimited CSV file on portal for data generation

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I tried registering a pipe delimited CSV file on portal for data generation but instead of creating a table with columns as the per the delimited value, it created a table with only one column with all values.

There was no option to select the delimiter while registering the file.

Environment

Release : 4.9.1 or newer

Component : Web Portal - Generator

Resolution

   Engineering team confirmed that, we only support csv file in portal console. Other delimited files are considered as enhancement request. 

   As a workaround, convert the input file to csv (by replacing pipe with comma) then register the file and then replace comma with pipe after re-generating the file