QTP - Webtable().GetCellData() returns unknown symbols and spaces

[lokesh8008]

I have tried to retrive the values from the web table using the Getcelldata method, but it is showing values along with blank spaces and symbols in between them. But i want it to display only the values and no spaces, extra symbols...

The symbol which is getting displayed in between the values is the small box like one which we get when we copy paste spaces..

Even I have tried replace method, but it doesn't worked out.

I am using the chrome browser for testing.

The following is the piece of code which i used,

Code:

RwCount=Browser("xyz").Page("abc").WebTable("table1").RowCount
ColCount=Browser("xyz").Page("abc").WebTable("table1").ColumnCount(1)
Print RwCount
Print ColCount
For i=1 to RwCount
    For j=1 to ColCount
        iValue=Trim(Browser("xyz").Page("abc").WebTable("table1").GetCellData(i,j))
        Print iValue
    Next
Next

Here with I have attached the results image..

Can anyone please tell me how to overcome this issue.?

[Saket]

Replace and Trim should work here, Can you paste how you tried?

[sria123]

Use the replace with search string vbtab,vbcrln, vbln,vbcr,etc.. as thay may be line feed or tab, acarriage return...