when using the "&" operator in the process of exporting to csv files

[uscitizen]

my downstream contact needs to see data from my a2k database in a csv file and, in particular, wants to see names as follows: LASTONE^FIRSTONE^MIDINITL

being the inexpert with respect to exporting to csv, i understand you want to start with a query and then redefine your output variables....which brought me to contrive the following: NEWVERSION: ([LASTONE]&"^"&[FIRSTONE]&"^"&[MIDINITL]), which would result in

"Public^John^Q"

when the patient's got a middle initial, but the troublesome looking

"Doe^Mary^"

when the patient doesn't.

any suggestions'd be kind of welcome.

“The philosophy of the school room in one generation will be the philosophy of government in the next." --- Abraham Lincoln

 

[mgolla]

Have you tried this:

NEWVERSION: IIf(IsNull([MIDINITL])OR [MIDINITL]="",([LASTONE]&"^"&[FIRSTONE]),([LASTONE]&"^"&[FIRSTONE]&"^"&[MIDINITL]))

HTH
Mike