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
-

-

-
-

-
-

-
-

-
-

-
-

-
-

-
-

-
-

-

- -
-

-
-

-
-

-
-

-

-

-
-

-
-

-
-

-
-

-
-

-
-

-
-

-
-

-

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 21:46:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.