Forum Discussion

TKRK's avatar
TKRK
Occasional Contributor
4 months ago

Property check point does not work with multiline data in a csv

col1,col2,col3
test1,"test2.1
test2.2
test2.3",test3

A similar to this csv is what I am using in the data loop,  and in the "Quoted Text" section I am using ", when I look at the file in that section it displays like this

col1,col2,col3

test1,test2.1

test2.2

test2.3",test3

 

 

and the property check point is failing 

 

Actual Value: "test2.1↴test2.2↴test2.3"

Expected Value: "test2.1"

 

Please show me the right path, the guidance, the light.

3 Replies

  • TKRK's avatar
    TKRK
    Occasional Contributor

    I am trying to compare multiline of text in a cell from a excel/csv file, how can I do that? I am using keyword test - property checkpoint.

  • Marsha_R's avatar
    Marsha_R
    Champion Level 3

    Show us the code for your data loop please. Does your data actual have the word test in it? If not, please also show us some sample data. It is difficult to help when we have to guess what is actually happening.

  • rraghvani's avatar
    rraghvani
    Champion Level 3

    Note, you can use carriage return \r (and new line \n) in your string, when comparing i.e. "test2.1\rtest2.2\rtest2.3"