question

GregM avatar image
GregM asked GregM posted

Response Maps for table with borders

I'm working on a services project creating response maps.  All of the responses have borders, some have borders around the cells.  Assuming I use table RMs, I have three issue I'd like help with:

 

  1. How to get rid of the "|" values in the returns from the queries
  2. How to get rid of the "---------" values in the returns from the queries
  3. How to trim the extra spaces in the returned value (for example "cfmr2       ")

Below are the response, test case Response view and reponse map.

 

Greg 

 

+------------------------------ CFM Port Stacks -------------------------------+
|Vlan|Port    |Typ|L|Mep |Adm|Service         |MAID                            |
| or |        |   | |    |   |                |                                |
|BVID|        |   | |    |   |                |                                |
+----+--------+---+-+----+---+----------------+--------------------------------+
|1001|        |MIP|3|    |   |                |                                |
+----+--------+---+-+----+---+----------------+--------------------------------+
|1001|28      |Up |4|102 |en |cfmr2           |md4cfmr2                        |
+----+--------+---+-+----+---+----------------+--------------------------------+
|1002|27      |Up |4|201 |en |cfm1050         |md4cfm1050                      |
+----+--------+---+-+----+---+----------------+--------------------------------+

 

iTestresponse map
lined_table.GIF (5.5 KiB)
cfm_stack_show.ffrm (9.4 KiB)
10 |950
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
manishapawle avatar image
manishapawle answered manishapawle posted

Hi,

 

To get rid of "----------" values in return from the queries you can add Response Filters in response map editor with patter type as a 'wildcard' and the pattern you want to exclude in pattern field, and set the action to 'exclude lines containing the matches of pattern' with this you should not see the "---------" pattern in response and queries for that particular pattern when you use the response in testcase execution.

 

 

10 |950
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

PaulD avatar image
PaulD answered PaulD posted

1.  Use a custom column delimiter based on the |  Also, you'll want to uncheck the box for including irrelevant columns (first and last) artificially created because delimiters at the front and back.

 

2.  Little tricky, but by using the | delimiter, the intervening rows won't have any columns in them, or more properly, those cells will all be treated as part of the first column that we're tossing away anyway.  So you just want to exclude rows where the Vlan is empty.

 

3.   The extra whitespace is because the last column is a delimiter.  Add an artificial column and exclude it from the structured results.

 

I've done all of this and you'll find it in the attached response map.

Message Edited by PaulD on 10-07-2008 04:35 PM

grid_table.ffrm (6.8 KiB)
10 |950
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.