Hi, I have generated an array of random numbers and I'm trying to then write this array to a .txt file but the code I have written doesn't seem to do this correctly. Any help on this would be great. Here is what I have so far:

The length of the prefix and suffix strings are used to respectively align and wrap the output. An array is typically printed as: prefix + array2string(a) + suffix.

import numpy as N
import random

def main():
n=10
size=1500
initial=N.zeros([n,3], dtype=N.float64)
filename='initialpositions.txt'

for i in range(n):
for j in range(size):
initial[i,j]=random.randrange(0,size)
file=open(filename,'w')
file.write(initial)
file.close()

• 4 Contributors
• forum 5 Replies
• 19,669 Views
• 8 Hours Discussion Span
• commentLatest Postby snippsatLatest Post

richieking44

APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

To remove the square brackets that surround the JSON output of the FOR JSON clause by default, specify the WITHOUT_ARRAY_WRAPPER option. Use this option with a single-row result to generate a single JSON object as output instead of an array with a single element.

If you use this option with a multiple-row result, the resulting output is not valid JSON because of the multiple elements and the missing square brackets.

Example (single-row result)

The following example shows the output of the FOR JSON clause with and without the WITHOUT_ARRAY_WRAPPER option.

Query

Too many other short comings to mention. Free wii iso files download. When I think of Price Is Right, I think of playing with friends and family. Also, this game makes you choose what games you want to play prior before playing. I would like for the game to randomly give me the games like the original TV show and have the option of choosing individual games in another mode. Was very disappointed.

Result with the WITHOUT_ARRAY_WRAPPER option

Result (default) without the WITHOUT_ARRAY_WRAPPER option

Example (multiple-row result)

Here's another example of a FOR JSON clause with and without the WITHOUT_ARRAY_WRAPPER option. This example produces a multiple-row result. The output is not valid JSON because of the multiple elements and the missing square brackets.

Query

Result with the WITHOUT_ARRAY_WRAPPER option

Result (default) without the WITHOUT_ARRAY_WRAPPER option

Learn more about JSON in SQL Server and Azure SQL Database

Microsoft videos

For a visual introduction to the built-in JSON support in SQL Server and Azure SQL Database, see the following videos:

See Also