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|[email protected]|Female|112.175.143.209

what I am expecting is
“1”|“Eustacia”|“Grabert”|“[email protected]”|“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.