IF NOT EMPTY(lcStr) lcStr = STRTRAN(lcStr,[,"],[|]) lcStr = STRTRAN(lcStr,["],[]) && get rid of any extra quotes FPUTS(lhOut, lcStr) ENDIFThis correctly produces a file delimited with | characters. I looked at it with a text editor and it has one record per line, delimited with those pipes.
Append From yardi.Csv Type DELIMITED WITH |where that file is the one of interest, does not get what I expected. The cursor has the 1st field correctly populated, but others are not. Sometimes, that's the only field in the record that ends up with data. Other times, several concatenated fields end up in a single field
PLAT 202||FOUNTAIN HILLS|AZ|8I don't understand this.
lcStr = STRTRAN(lcStr, ["], [])>