Typically, I've dealt with XML, EDI, and tab-delimited files within Cache. All CSV files were typically done in PHP. It's definitely a great exercise.

I did want to note that the above solution did not work with the following string.

CSIN-01,01/01/2002,01/15/2003,,1,1002381,ABC CORP,02/22/2018,"NET ""15""","ANYTOWN, DC",JANE DOE,"ANYTOWN, DC",06/13/2018,$13900.00 ,$101.15 ,$5.13 ,$308.00 ,$281.70 ,$0.00 ,$0.00 ,$217.00 ,JOHN DOE

The initial post advised that it was to take into account fields enclosed in double quotes. CSV stands for comma-separated value, so I'm not sure how that would change the information.

I did add the example since it appeared someone may not understand what taking into account double quotes means.

This doesn't take into account fields enclosed in double quotes. The goal is to remain compliant with RFC 4180.

This does work. I think the only downside is if you were to apply this to longer numbers. For example, an invoice number with 9 digits you'd have to write "000000000". As far as readability, you'd have to count those zeroes every time. For this reason, I'd say the combination of $TRIM and $JUSTIFY would be more appropriate since you'd alleviate how to count the zeroes.

If in an alternate namespace, this would require the namespace to contain the %qarfunc, or have a routine mapping to the USER namespace.

It's been a while since I posted this. However, we have since upgraded to 2015.2 and we're receiving the above error when we put the correct settings in Task Manager Email Settings.

Is anyone successfully sending emails via SMTP with Office 365/Exchange Online?

I came across this comment and felt that others may benefit by reviewing the documentation rather than the debate. The documented answer for this is found here.

I know that mgstat has the queue size, blocks updated, and phase. What I'm looking for is more what is left in the queue. As of now, the WD is still on the same phase (1h and 6m later).

Answers to the following questions may be helpful.

  • What Caché version are you running?
  • What operating system is Caché running on?
  • What operating system is the shared drive?