Concatenate fields, VI 1

[Databaseguy]

I haven't found a way to do this in an Export Job. Either combining two fields, or combining a field and a string which I define.

Louie, I'm going to class in a week so go easy on me

 

[BigLouie]

Why anyone would use VI to export information is beyond me and beyond help. I use either Excel or Access to pull the data. Way easier and faster.

Normally you use a temp field.

 

[Databaseguy]

Yes, I suggested using ODBC to pull the data.

The project manager asked "Why don't you just use VI ?", so I have to justify the Access/VB utility.

 

[BigLouie]

Here is something you should tell the project manager. I worked with a MAS reseller. They had a client that wanted to use VI to extract a number of data files such as the ARN and ARO at night. They estimated that it would take 12 HOURS to complete the process. I created an Access application for them that took only 5 minutes to extract the same data.

Let the project manager know that if they wanted to use VI they should have started right after the birth of the cosmos so it could finish in our life time.

 

[Databaseguy]

Thanks Louie.

BTW, I WAS able to concatenate, however MAS puts an ascii chr 27 in the string for some reason.

For example, in temp01, I have AR.INVHISH:INVOICE_NUMBER+'Ty', it returns 0100033TY

The good news is anyone can create an Access database.

The BAD news is anyone can create an Access database.

 

[BigLouie]

Have you tried using & instead of +

 

[Databaseguy]

Thanks Luoie. Yeah, I tired the ampersand. I really don't think it can be done. Here's what the help files says

The calculation expression consists of valid numeric data items, dates, and/or numeric constants separated by arithmetic operators.

The good news is anyone can create an Access database.

The BAD news is anyone can create an Access database.