Delimiter in String to XML Parser

[Former Member]

Hi

In 12.2 I was able to use the pipe character as a delimeter in the String List to XML Parser action block, but it doesn't work in 15 (SP4).

How can I get it to work?

[Nikhil_Makhija · Accepted solution]

Hi Nick,

Try to escape pipe in delimiter like this ,for each pipe use 2 backslash i.e.

for string a|b|c - > \\|

Nikhil

[RuchirBatra · Accepted solution]

Try

Input as

encode("1||2||3")

Delimiter as

encode("||")

and you will get result as (  a part of result)

  <Row>

            <Item>1</Item>

        </Row>

        <Row>

            <Item>2</Item>

        </Row>

        <Row>

            <Item>3</Item>

        </Row>

[swaroop_anasane · Accepted solution]

That's what. I was trying single slash. Thanks Nikhil for the revival.

Best Regards,

Swaroop

[swaroop_anasane]

Hi Nick,

Migrating a project to higher version is not that straight forward. So not everything would work as it is, you will have to modify stuffs a bit. I remember reading somewhere that pipeline character is not readily supported in all action blocks as it has other meaning too.

I would suggest map your input as stringreplace(string, searchText, replacetext) and then provide delimiter as "replacetext". It would work.

Best Regards,

Swaroop