Replacing Values

[thomas_skariah]

Hi All,

Can anyone suggest how i can achieve the following scenario in which there are three columns Ref,SubDate and Amount.

(Please find the attached screen shot). Here there are Ref 300 & 300A (300 with suffix A) I have to replace the SubDate of 300A with that of Subdate of 300 and then have to  exlcude the entire record of ref 300 from the table.Similarly Subdate of ref 600B should be replaced with 600 and have to exclude both 600 and 600A from the table..This logic should should be applicable to  all Ref with suffix (A or B).

Thanks in advance.

Regards,

Tom

[#2]

Hi Tom

I believe you are looking for something like the below if I have understood correctly.

If I am right, can you mark the answer as correct, or let me know if I have missed the mark,

Regards

Steve

[CELAMBARASAN]

Hi,

Hope the attachment helps.

PFA

[senpradip007]

Try this:

PurgeChar(SubDate,'AB')

[thomas_skariah]

Hi Steve,

Sorry for late reply.Here I don't want the Ref with suffix to be removed.Please find the attached image.

Regards,

Tom

[thomas_skariah]

Anyone.any suggestion on this?

[CELAMBARASAN]

Hi,

Did you have a look at my attachment of my previous reply?