Question: I have a simple problem but I started to use google bq and their help menu was so complex for me.

I have a column like that for some rows:

```
ANSWER(title of column)
9
10 - Certainly Satisfied.
7 -

```

My aim is to split the previous part of that column from "-" sign and convert it to integer. I found some formulas like split(), regexp\_extract() but I couldn't be sure how can I imply them for my data.

Thanks for your help in advance :)

Answer: 
Just add endline at the end of each random number.

```
line_1 = str(random.randint(1, 501)) + '\n'

```

Since you didn't add any endline character, your input file contains only 1 line of input, and what your code really does is to convert that 1 concatenated string into an int and prints it out.
There is a problem in your randomNumberMaker() function. You are writing all numbers in one line and thus always getting back only one number, which is a textual concatenation of all random numbers.

Change the line
`random_numbers.write(line_1)`to `random_numbers.write(line_1+"\n")`and everything will work as expected.