RQM Excel Importer - Is there a way to add a carriage return if i want to concatenate two columns in Excel through the importer.
I'm trying to use the importer to concatenate two columns. I know I can do something like testcase.description= A & " - " & B so I can merge two lines of text into my Test Case description. However, this puts it in one line, I need to add a carriage return like (A & \n & B) so the data will be separate in more of a paragraph format. Is there a way to do this? We tried some ASCII (CHR(34), (13), \n,) but not sure if this is possible or if we have the wrong syntax. Thanks
Accepted answer
Try using br tag to append the columns.
Refer sample Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne.cfg present in the Samples folder which came with the importer installation. Look at the line configuration.description, here the value is prepared by appending column and text with br tag <br>
Hope this helps
Refer sample Testplan_Testcase_Testscript_TER_Environment_Iteration_AllInOne.cfg present in the Samples folder which came with the importer installation. Look at the line configuration.description, here the value is prepared by appending column and text with br tag <br>
Hope this helps
2 other answers
Where are you trying to import this data into? Description field? Are you conditioning your data in excel template PRIOR to import?
Comments
Importing the data into the step description actually. Regardless, the issue is we would rather not concatenate the data in excel as its a template, but use the importer to add a carriage return instead of a space or delimiter character, which we know can concatenate 2 separate excel columns, i.e. testcase.dc:description= A & " - " & B