I cannot seem to use the find and replace function to remove unwanted dashs's.
Eg
<TABLE style="WIDTH: 230pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=306 border=0><COLGROUP><COL style="WIDTH: 230pt; mso-width-source: userset; mso-width-alt: 11190" width=306><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 230pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=306 height=20>ADAMS-Matthew-469312-</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>ADAMS-Michele-360221--</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>ADAMS-Nathan-265675---
Without going into to much detail I am stuck with betwen one and four unwanted dashs at the end of the info I want to keep. I have 5000 lines which I want to remove the dsh from but using find --- and replace " " doesnt seem to work.
Any Ideas?
Cheers
Paul
</TD></TR></TBODY></TABLE>
Eg
<TABLE style="WIDTH: 230pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=306 border=0><COLGROUP><COL style="WIDTH: 230pt; mso-width-source: userset; mso-width-alt: 11190" width=306><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 230pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=306 height=20>ADAMS-Matthew-469312-</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>ADAMS-Michele-360221--</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>ADAMS-Nathan-265675---
Without going into to much detail I am stuck with betwen one and four unwanted dashs at the end of the info I want to keep. I have 5000 lines which I want to remove the dsh from but using find --- and replace " " doesnt seem to work.
Any Ideas?
Cheers
Paul
</TD></TR></TBODY></TABLE>