Bug 62345 - Failing assertion in CSV should remove line breaks to allow using grep
Summary: Failing assertion in CSV should remove line breaks to allow using grep
Status: NEW
Alias: None
Product: JMeter
Classification: Unclassified
Component: Main (show other bugs)
Version: 2.9
Hardware: All All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: JMeter issues mailing list
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-05-02 10:21 UTC by ankhila imane
Modified: 2018-07-19 19:30 UTC (History)
3 users (show)



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description ankhila imane 2018-05-02 10:21:03 UTC
Hi,

when I created an assertion response with the equals option, than I created the field to register result in csv format, I've got an syntax error in the error message ; it provides additional blank lines and there was missing quotes, which does not respect the normal syntax of csv files.

here is the result :

timeStamp,elapsed,label,responseCode,responseMessage,threadName,dataType,success,failureMessage,bytes,sentBytes,grpThreads,allThreads,Latency,IdleTime,Connect
1525171309281,659,HTTP Request,200,OK,Thread Group 1-1,text,false,"Test failed: code expected to equal /

****** received  : [[[200]]]

****** comparison: [[[999]]]

/",12470,121,1,1,658,0,383

regards.
Comment 1 Sunny Agrawal 2018-05-08 03:13:13 UTC
Hi,
This behavior is observed due to new line characters given in the code.
        text.append("\n\n");
        text.append(RECEIVED_STR);
        text.append(endingEqSeq);
        text.append("\n\n");

Thanks
Comment 2 Philippe Mouawad 2018-05-27 09:05:09 UTC
(In reply to ankhila imane from comment #0)
> Hi,
> 
> when I created an assertion response with the equals option, than I created
> the field to register result in csv format, I've got an syntax error in the
> error message ; it provides additional blank lines and there was missing
> quotes, which does not respect the normal syntax of csv files.
> 
> here is the result :
> 
> timeStamp,elapsed,label,responseCode,responseMessage,threadName,dataType,
> success,failureMessage,bytes,sentBytes,grpThreads,allThreads,Latency,
> IdleTime,Connect
> 1525171309281,659,HTTP Request,200,OK,Thread Group 1-1,text,false,"Test
> failed: code expected to equal /
> 
> ****** received  : [[[200]]]
> 
> ****** comparison: [[[999]]]
> 
> /",12470,121,1,1,658,0,383
> 
> regards.

Hello,
Where is exactly the issue ?
I see double quote start:
- "Test
and end:
- /"

which seems to me correct and open fine in LibreOffice. 
But I must be missing something.

Thank you for clarification.
Comment 3 Philippe Mouawad 2018-06-15 13:33:11 UTC
(In reply to Philippe Mouawad from comment #2)
> (In reply to ankhila imane from comment #0)
> > Hi,
> > 
> > when I created an assertion response with the equals option, than I created
> > the field to register result in csv format, I've got an syntax error in the
> > error message ; it provides additional blank lines and there was missing
> > quotes, which does not respect the normal syntax of csv files.
> > 
> > here is the result :
> > 
> > timeStamp,elapsed,label,responseCode,responseMessage,threadName,dataType,
> > success,failureMessage,bytes,sentBytes,grpThreads,allThreads,Latency,
> > IdleTime,Connect
> > 1525171309281,659,HTTP Request,200,OK,Thread Group 1-1,text,false,"Test
> > failed: code expected to equal /
> > 
> > ****** received  : [[[200]]]
> > 
> > ****** comparison: [[[999]]]
> > 
> > /",12470,121,1,1,658,0,383
> > 
> > regards.
> 
> Hello,
> Where is exactly the issue ?
> I see double quote start:
> - "Test
> and end:
> - /"
> 
> which seems to me correct and open fine in LibreOffice. 
> But I must be missing something.
> 
> Thank you for clarification.

Hello Imane,
Any feedback ?
Thanks