Number of input and output field

Number of input field	:	One
Number of output field	:	One

The SplitJSON function is used to split data from a JSON array or object.

Examples of using SplitJSON in HGrid247-3.5.

1.

Input	[{category:reference,author:Nigel Rees,title:Sayings of the Century,price:8.95},{category:fiction,author:Evelyn Waugh,title:Sword of Honour,price:12.99},{category:fiction,author:Herman Melville,title:Moby Dick,isbn:0-553-21311-3,price:8.99},{category:fiction,author:J. R. R. Tolkien,title:The Lord of the Rings,isbn:0-395-19395-8,price:22.99}]
Result	{category:reference,author:Nigel Rees,title:Sayings of the Century,price:8.95}          {category:fiction,author:Evelyn Waugh,title:Sword of Honour,price:12.99}          {category:fiction,author:Herman Melville,title:Moby Dick,isbn:0-553-21311-3,price:8.99}          {category:fiction,author:J. R. R. Tolkien,title:The Lord of the Rings,isbn:0-395-19395-8,price:22.99}

2.

Input	[{category:reference,author:Nigel Rees,title:Sayings of the Century,price:8.95},{category:fiction,author:Herman Melville,title:Moby Dick,isbn:0-553-21311-3,price:8.99}]
Result	{category:reference,author:Nigel Rees,title:Sayings of the Century,price:8.95}          {category:fiction,author:Herman Melville,title:Moby Dick,isbn:0-553-21311-3,price:8.99}

3.

Input	{Sayings of the Century,Sword of Honour,Moby Dick,The Lord of the Rings}
Result	Sayings of the Century          Sword of Honour          Moby Dick          The Lord of the Rings