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
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.
You’re suggesting add one more field to the schema and add all previous?
Hi @grivera - yes, sometimes if settings don’t give you exactly what you need, the template field can.
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
@grivera you can preface any field label with __ (two characters of underscore _ ) which makes that field hidden
didn’t know that, is there like an instructions document or something where that is written?
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"""
@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
No worries, I hope mockaroo support jumped in to the conversation
I have used delimiter in Unix, which is used to join two sentences. dell printer error 016-302 helped me to get the solution.