Compute and Merge columns in array - Visual Basic 4 / 5 / 6

Hello
Here is my issue

I have a two dimensions array that looks like this:

EMPTY, Type1, Type2, Type3, Type4
Choice1, Value11, Value 12, Value 13, Value 14
Choice2, Value21, Value 22, Value 23, Value 24
Choice3, Value31, Value 32, Value 33, Value 34

I am being posted a value from another page which looks like this

dim mergeAndCompute :mergeAndCompute="ColumnName:Type1,Type3"

I've to produce the following array

AMPTY, ColumnName, Type2, Type4
Choix1, Value11+Value13, Value 12, Value 14
Choix2, Value21+Value23, Value 22, Value 24
Choix3, Value31+Value33, Value 32, Value 34

I'm lost. I've tried several approches but I can complete the code and that is the reason why I'm requiring your help

Thx a lot!
Regards
WhiteArrow

Jul 7 '10 #1

Subscribe Post Reply

1485

Guido Geurs

767

Expert 512MB

Is this VB6 or VBA ?

dim mergeAndCompute :mergeAndCompute="ColumnName:Type1,Type3"

Normaly in VB6 it's=

Array2.ColumnName = Array1.Type1 & array1.Type3

Jul 8 '10 #2

whitearrow38

Infact it is vbscript for asp...

Jul 8 '10 #3

Similar topics

dataset casting (merge)

by: Bernard | last post by:

How can I cast the dataset I generated the dataset from schema and named it 'Staff'. I use this dataset (staff dataset) as a datasource in the report then I would like to generate the data from...

.NET Framework

Merge two rows in the same table

by: laurenq uantrell | last post by:

I want to create a stored procedure that will merge columns from two rows that contain duplicated contacts. I have can easily identify the duplicates and extract the UniqueIDs as parameters, but...

Microsoft SQL Server

Datagrid columns using AutoGenerate via the autoGenColumnsArray private member array collection (reflection)

by: Jason Coyne Gaijin42 | last post by:

I have seen several people looking for a way to access the Columns collection when using the AutoGenerate = true option. Some people have gotten so far as to find the private autoGenColumnsArray...

C# / C Sharp

DataGrid Columns

by: CSL | last post by:

I am using the DataGrid in a Windows Application, how can I adjust the widths of each column individually.

Visual Basic .NET

DataGrid columns created at runtime

by: Gary Blakely | last post by:

I'm giving this post another try - it can't be too difficult for everyone.... In the program below, the web page has dataGrid1. the only thing that has been done to it at design time is to...

ASP.NET

Merge Sort in C - array output is same as input after sort routine completes

by: rkk | last post by:

Hi, I have written a generic mergesort program which is as below: --------------------------------------------------------- mergesort.h ----------------------- void MergeSort(void...

C / C++

How can I return an array from C to python

by: shashi59 | last post by:

Now i need information about interface c and python.Now i call c function from python but i dont know how to return a array from c to python

Python

Columns in Dropdown list and list box

by: =?Utf-8?B?RGF2ZSBU?= | last post by:

Is there a way to add columns to the drop down list and list box controls so I can show multiple columns? My DBA refuses to allow concatenation in SQL

ASP.NET

Array/Collection Question

by: markliam | last post by:

How would I declare a fixed number of ColumHeader objects without having to manually type "new ColumnHeader()" for each one? Is it even possible? I'm thinking there has to be an easier way than...

C# / C Sharp

How to merge columns (BoundFields) in a gridview?

by: Tea Maker | last post by:

Hi, I have an access database that has the following fields: firstName, fatherName, lastName Now I have placed a gridview in my aspx page, and included three BoundFields, and filled the data in...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server