Home » Other » General » Concatenate
Concatenate [message #104088] Tue, 27 July 2004 03:40
krishna murthy
Messages: 3
Registered: January 2002
Junior Member


- value -
- quantity -
- des1 -
- des2 -
- des3 -
- des4 -
- des5 -
- des6 -
- des7 -
- result -

- -
- -
- -
- -
- -
- -
- -
- -
- -
- -

- res1 -
- 4 -
- r1 -
- r3 -
- r4 -
- r2 -
- -
- r7 -
- r8 -
- r1,r3,r4,r2,,r7,r8 -

- res2 -
- 5 -
- r13 -
- r1 -
- r3 -
- r2 -
- r8 -
- r6 -
- -
- r13,r1,r3,r2,r8,r6,r7,r4,r12,,,,,, -

- -
- -
- -
- r7 -
- r4 -
- r12 -
- -
- -
- -
- -

- res3 -
- 2 -
- r1 -
- r3 -
- r2 -
- r5 -
- r8 -
- r11 -
- r7 -
- r1,r3,r2,r5,r8,r11,r7 -

- res4 -
- 7 -
- r3 -
- r5 -
- -
- r7 -
- -
- -
- -
- r3,r5,,r7,,,, -

- res5 -
- 5 -
- -
- r5 -
- -
- -
- r2 -
- -
- -
- ,r5,,,,r2,,, -

 

 

 

 

 

 

I I am Creating an excel sheet as mentioned above

-

result comlumn will contain the contenated data of the columns before that

-
-

-
-

-

-

 
-
-

-

-

-
-

-
-

 
-
-

-
-

-
-

-
-

-
-

-
-

-

-

I have the macro to add the data into result column, but the comma is added to the result when there is a blank cell,

 

So I need a Macro to concatenate all the values in to result column without an extra comma for blank cell,

if any row in value is empty the valuew of that row should be added to theprevious row's result
-

-

-
-

-
-

-
-

-
-

-
-

-
-

-
-

-
-

-

- -
-

-
-

-
-

-
-

-

-

-
-

-
-

-
-

-
-

-
-

-
-

-
-

-
-

-
Previous Topic: Oracle Discoverer Licensing Rules - URGENT HELP REQUIRED
Next Topic: Question
Goto Forum:
  


Current Time: Thu Mar 28 17:00:43 CDT 2024