Data not generated with double quotes when format is custom and delimiter is |

1

I tried to set
output format to custom
delimiter to |
quote to "

however I got the output as below
1|Eustacia|Grabert|egrabert0@wikimedia.org|Female|112.175.143.209

what I am expecting is
“1”|“Eustacia”|“Grabert”|“egrabert0@wikimedia.org”|“Female”|“112.175.143.209”

double quotes are missing for each data cell

This happens in download, preview, Generate APIs

2

Use the template field. I just did a quick test:

“{first_name}”|"{last_name}"|

returned:

“Leta”|“Flawith”|

You can use any static values in template if you want certain parts hard-coded.

3

You’re suggesting add one more field to the schema and add all previous?

5

Hi @grivera - yes, sometimes if settings don’t give you exactly what you need, the template field can.

6

But that would leave you with a table that includes all the “malformed” fields plus all the good ones. And then you would need to manually edit it so you get rid of the bad ones

7

@grivera you can preface any field label with __ (two characters of underscore _ ) which makes that field hidden

8

didn’t know that, is there like an instructions document or something where that is written?

9

It didn’t work for me I had something like

__field1
__field2
__field3
field4

field4 was the template one and I set it to

"{__field1}"|"{__field2}"|"{__field3}"

data showed as

"""value1""|""value2""|""value3"""
10

@grivera I see what you mean - not sure what else to try off the top of my head and a bit busy at the moment to do further test. Sorry

11

No worries, I hope mockaroo support jumped in to the conversation

12

I have used delimiter in Unix, which is used to join two sentences. dell printer error 016-302 helped me to get the solution.