Re: How to escape characters in strings in CSV Data Set Config

[Felix Schumacher]

Am 19.07.22 um 01:28 schrieb ohaya:

  Hi,

I was able to get this working by change the "Delimiter" in the CSV Data Set Config to 
"@", which isn't occurring in any of the CSV lines.

Good to know, that this helped you.



"a,b","a,""b"""

(should work, haven't tried)

Felix

You could also try to use quoted data. But you have to make sure, that quotes in the data are escaped by quotes. Say, you have a delimiter of ',' (comma) and the values 'a,b' and 'a,"b"' (the single ticks are to show the boundaries of the values and are not part of the values), the quoted data would look like

Jim


      On Monday, July 18, 2022, 05:07:56 PM EDT, ohaya<oh...@yahoo.com>  wrote:


I tried replacing the "," in the CSV string with %2C, but when it sent the 
request body if left the %2C literally in the CSV string :(!!




      On Monday, July 18, 2022, 04:46:08 PM EDT, ohaya<oh...@yahoo.com>  wrote:


I have a test plan that uses  CSV Data Set Config to rotate through a set of request 
bodies (strings), but some of the bodies in the CSV files have characters like comma 
(","), e.g.:

<Request xmlns:xacml-context="urn:oasis:names:tc:xacml:2.0:context:schema:os" xmlns="urn:oasis:names:tc:xacml:2.0:context:schema:os">    <Subject>        <Attribute AttributeId="urn:oasis:names:tc:xacml:1.0:subject:subject-id" 
DataType="http://security.bea.com/ssmws/ssm-ws-1.0.wsdl#PrincipalInfo";>            <AttributeValue>{name=cn=ImageryPolicyUser1,ou=People,ou=xxx,ou=yyy,o=ooo,c=us}+(class=weblogic.security.principal.WLSUserImpl)</AttributeValue>              </Attribute>    </Subject>    <Resource>        <Attribute 
AttributeId="urn:oasis:names:tc:xacml:2.0:resource:resource-id" DataType="http://www.w3.org/2001/XMLSchema#string";>            <AttributeValue>h://z/iEval</AttributeValue> </Attribute></Resource><Action><Attribute AttributeId="urn:oasis:names:tc:xacml:1.0:action:action-id"       
     DataType="http://www.w3.org/2001/XMLSchema#string";>            <AttributeValue>GET</AttributeValue>        </Attribute>    </Action>    <Environment>        <Attribute AttributeId="http://security.bea.com/ssmws/ssm-ws-1.0.wsdl#metadata";  
DataType="http://www.w3.org/2001/XMLSchema#string";>  <AttributeValue>{ "wac": 1000 }                                </AttributeValue>            </Attribute>    </Environment></Request>

How can I escape those characters?

Thanks,
Jim

Hi, Hi,

OpenPGP_0xEA6C3728EA91C4AF.asc
Description: OpenPGP public key

OpenPGP_signature
Description: OpenPGP digital signature