How to rename a Temp Field in a VI export?

Question

Haven't found this posted before, although it may have been and my searching skills are diminished. I also understand that this might be something that I can pull into Access or Excel, or even write a Crystal Report, to accomplish. But for the moment let's just say I would like to pull this into a CSV with VI. 
 I'm using a Temp Field to concatenate 2 fields into one column, but I can't figure out how to give the column header a name other than Temp001. Seems like a simple thing, right?

David_Speck · Accepted Answer

You can do this with a temp field with perform logic or by using a file containing the perform logic. The goal is to manipulate the cFirstRec$ variable and can be done with the SUB function. 
 Given a export job set up like this. 
 
 The Temp001 field should be set up like this. 
 
 ""; IF UCS(ExportNamesAsFirstRecord$)=UCS("Y") AND LEN(cFirstRec$)>0 THEN cFirstRec$ = SUB(STP(SUB(cFirstRec$, "Temp002", "ProductLine"), "R", FieldDelimiter$), "Temp001" + FieldDelimiter$, "") END_IF 
 Replace the Temp002 with the target temp field and replace "ProductLine" with the target column name.

Sage 100

How to rename a Temp Field in a VI export?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING