Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace duplicate with empty space
Message
From
10/06/2008 05:24:47
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Replace duplicate with empty space
Miscellaneous
Thread ID:
01322771
Message ID:
01322771
Views:
63
Dear Experts

Table1 has following indexing
index on dtoc(date,1) + alltrim(type)+str(voucher,4) to abc

Data in Table1 is as

date---Voucher-type-amount
9/6/2008---1---SR---500
9/6/2008---1---SR---600
9/6/2008---2---SR---200
9/6/2008---2---SR---300
10/6/2008--1---SR---400
10/6/2008--1---SR---700
10/6/2008--1---SC---350
10/6/2008--1---SC---200

I want to display empty DATE, VOUCHER and TYPE fields where date+type+voucher is same

Following data view is required

date---Voucher-type-amount
9/6/2008---1---SR---500
--------------------------600
9/6/2008---2---SR---200
--------------------------300
10/6/2008--1---SC---350
--------------------------200
10/6/2008--1---SR---400
--------------------------700

Please help
Next
Reply
Map
View

Click here to load this message in the networking platform