Compare RTF file with Excel file and generate separate RTF file based on group assigned in excel using C# and VB.Net in ASP.Net

Last Reply one year ago By dharmendr

Posted one year ago

Dears,

I have a RTF file including several different references and three groups, and also I have an excel database including some references in three groups too.

I would like to compare the references which are in RFT file with the all the references in excel file and separate references based on their group and export three separated RFT file.

I attached these two file in following link:

https://www.file-upload.com/ydxpfmbi9eym

https://www.file-upload.com/dwcxnxlihr8f

Can somebody help me in this regards ? how I can handle it ?

 

BR

MA

Results 1 - 5 of 9 12
Posted one year ago

Hi mod7609,

Please paste the RTF and Excel file data here.


Posted one year ago
dharmendr says:

Hi mod7609,

Please paste the RTF and Excel file data here.

it was not possible to paste file here but you can find some thing of the data as follow :

RTF File :

Nr

Case Nr

References

Goods designation

Quantity

Total net weight, kg

Total gross weight, kg

Country of origin

 

 

 

 

 

 

 

 

1

126178212

 

 

64

426,880

451,380

 

 

 

8200537190

COMPR

 

64

426,880

451,380

TH

2

126179212

 

 

64

426,880

451,380

 

 

 

8200537190

COMPR

 

64

426,880

451,380

TH

3

130701211

 

 

480

547,200

571,700

 

 

 

765872424R

REINF- SIDE IMPACT RE

 

480

547,200

571,700

EU

4

130718211

 

 

480

547,200

571,700

 

 

 

8200536832

REINF- SIDE IMPACT RE

 

480

547,200

571,700

EU

5

155932212

 

 

336

493,920

518,420

 

 

 

476604621R

UNIT-ABS HYD

 

336

493,920

518,420

EU

 

Excel file :

Refrences Name of Group
8200537190 Group 1
8200537190 Group 1
765872424R Group 2
8200536832 Group 1
476604621R Group 3

 

thanks for your help

 


Posted one year ago

Will you please provide the required output?


Posted one year ago
dharmendr says:

Will you please provide the required output?

 As you see , all Refrencess are in just one RTF file (5Ref), I want to seperate this refrences with their data based on database and group name, and issue 3 new RTF file
for excample one file for Group 1

another for Group2

and another one for Group 3

 

Thanks


Posted one year ago Modified on one year ago

Hi mod7609,

Your word document contains the record in table format like below or in any other format or in sinple text without table format?

Nr

Case Nr

References

Goods designation

Quantity

Total net weight, kg

Total gross weight, kg

Country of origin

1

126178212

 

 

64

426,880

451,380

 

 

 

8200537190

COMPR

 

64

426,880

451,380

TH

2

126179212

 

 

64

426,880

451,380

 

 

 

8200537190

COMPR

 

64

426,880

451,380

TH

3

130701211

 

 

480

547,200

571,700

 

 

 

765872424R

REINF- SIDE IMPACT RE

 

480

547,200

571,700

EU

4

130718211

 

 

480

547,200

571,700

 

 

 

8200536832

REINF- SIDE IMPACT RE

 

480

547,200

571,700

EU

5

155932212

 

 

336

493,920

518,420

 

 

 

476604621R

UNIT-ABS HYD

 

336

493,920

518,420

EU