VBA How do I remove from this .txt file the Solidus (/), Less-ThanSign (<) and Greater-Than Sign (>)

R

rebelscum0000

Access 2003 w/SP2
Access 2002 w/SP3
Windows XP Pro w/ SP2

Dear All,
I want to insert into a tbl the data of this .txt file without the /,
<, >, using
Visual Basic, (String manipulation) How do I remove these characters
in one step?
Or is another method to do this task?

Thanks in advance for any help
Regards,
rebelscum0000



<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type="text/xsl" href="C:\Program Files\BitDefender
\BitDefender 2008\Lang\log_format.xsl"?>
<ScanSession creator="BitDefender Antivirus 2008" version="BitDefender
UIScanner v.11" creationDate="11:29:51 11/03/2008" originalPath="C:
\Documents and Settings\All Users\Application Data\Bitdefender\Desktop
\Profiles\Logs\full_scan\1205256591_1_02.xml">
<ScanOptions
showWarnings="1" >
<ScanPaths>
<path id="0000">C:\</path>
<path id="0001">F:\</path>
<path id="0002">G:\</path>
</ScanPaths>
<ScanObjects
scanViruses="1"
scanAddware="1"
scanSpyware="1"
scanApplications="1"
scanDialers="1"
scanRootkits="0"
/>
<TargetSelection
heuristicScan="1"
scanArchives="0"
scanRegistryKeys="1"
scanRegistry="1"
scanCookies="1"
memoryProcesses="1"
scanBootSectors="1"
scanEmail="1"
scanAllFiles="1"
scanPackedFiles="1"
scanSubfolders="1"
includeExtensions=""
excludeExtensions=""
/>
<TargetProcessing
infectedAction="3"
suspiciousAction="1"
hiddenAction="1"
/>
</ScanOptions>
<EngineSummary
archivePlugins="41"
mailPlugins="6"
scanPlugins="12"
totalSignatures="986703"
systemPlugins="4"
unpackPlugins="7"
/>
<ScanSummary
scannedItems="18191"
infectedItems="0"
suspiciousItems="0"
resolvedItems="0"
scannedArchives="166"
bootSectorCount="11"
scannedDirectories="4497"
inputOutputErrors="30"
virusesNumber="0"
scanTime="00:00:14:21"
filesPerSecond="20"<FileSummary
scanned="17860"
archives="166"
packed="369"
infected="0"
suspicious="0"
resolved="0"
deleted="0"
moved="0"
copied="0"
/>
<RegistryKeySummary
scanned="302"
infected="0"
suspicious="0"
/>
<CookieSummary
scanned="0"
infected="0"
suspicious="0"
/>
<ProcessSummary
scanned="29"
infected="0"
suspicious="0"
/>
<MailSummary
scanned="0"
infected="0"
suspicious="0"
/>
</ScanSummary>
<ScanDetails>
<AffectedItem itemType ="File" path="F:\DVD APPZ X II\Appz Backup\OEX
\Soft\OEX020905MX.zip=]Setup.Ini" threatType="virus"
threatName="Password-Protected" action="none" finalStatus= "not
scanned" error= "no action possible"/>
<AffectedItem itemType ="File" path="F:\DVD APPZ X II\Appz Backup\OEX
\Soft\OEX020905MX.zip=]OEXSetup.msi" threatType="virus"
threatName="Password-Protected" action="none" finalStatus= "not
scanned" error= "no action possible"/>
<AffectedItem itemType ="File" path="F:\DVD APPZ X II\Appz Backup\OEX
\Soft\OEX020905MX.zip=]Setup.Exe" threatType="virus"
threatName="Password-Protected" action="none" finalStatus= "not
scanned" error= "no action possible"/>
</ScanDetails>
</ScanSession>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top