As per my requirement, I download multiple files from server, and I am getting few csv files with below data inside.
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=Edge" />
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title></title>
<link rel="stylesheet" type="text/css" href="/npw/Content/semantic-ui/semantic.min.css" />
<link rel="stylesheet" href="/npw/Content/bootstrap.min.css" />
<link rel="stylesheet" href="/npw/Content/DataTables/css/jquery.dataTables.min.css" />
<link rel="stylesheet" href="/npw/Content/bootstrap-datepicker.min.css" />
<script src="/npw/Scripts/jquery-3.6.0.min.js"></script>
<link rel="stylesheet" type="text/css" href="/npw/Content/styles.css" />
</head>
<body>
<!-- Skip Navigation -->
<div id="skiptonav">
<a accesskey="N" href="#navigation" class="skip">Skip to Navigation</a>
</div>
<div id="skiptocontent">
<a accesskey="C" href="#maincontent" class="skip">Skip to Main content</a>
</div>
<!-- header -->
<div id="environmentBanner" >
<!-- Options: local-banner, dev-banner, test-banner, prod-banner (display:none) -->
<span class="banner-text"></span>
</div> <!-- end environment banner -->
<header role="banner">
<div class="header">
<div class="container">
<div class="row">
<div class="col-md-7">
<div class="parent-name">Federal Financial Institutions Examination Council</div>
</div> <!-- end col-md-7 -->
<div class="col-md-5 hidden-sm hidden-xs">
<ul class="top-nav">
<li><a href="/npw/Help/Help">Help</a></li>
<li><a href="/npw/Home/About">About</a></li>
<!-- <li> <a href="#"> Federal Reserve Home </a></li> -->
<!--<li> <a href="#"> Link 3</a> </li> -->
</ul> <!-- end unordered list -->
</div> <!-- end col-md-5 -->
</div> <!-- end top row -->
<div class="row">
<div class="col-md-8 header-row-text">
<div class="app-name"> <a href='/npw'> <span class="acronym"> NIC </span> National Information Center</a> </div>
</div> <!-- end col-md-8 -->
</div> <!-- end row -->
</div> <!-- end first container -->
<div class="header-row">
<div class="container">
<div class="row">
<div class="col-md-8">
<div class="app-description">A repository of financial data and institution characteristics collected by the Federal Reserve System</div>
</div> <!-- end col-md-8 -->
</div> <!-- end row -->
</div> <!-- end second container-->
<div class="board-header-logo hidden-sm hidden-md hidden-xs"> </div> <!-- end board-header-background-logo -->
</div> <!-- end header-row -->
</div> <!-- end header class -->
</header> <!-- end header tag -->
<!-- - end header -->
<nav class="navbar navbar-default" role="navigation" aria-label="Main Menu">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#collapse-nav" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span><span class="menu-name">MENU</span>
</button>
</div>
<div class="container">
<div class="collapse navbar-collapse" id="collapse-nav">
<div id="navigation"></div>
<ul class="nav navbar-nav" role="menubar">
<li><a href="/npw/">Search Institutions</a></li>
<li><a href="/npw/Institution/TopHoldings">Large Holding Companies</a></li>
<li><a href="/npw/FinancialReport/BHCPRReports">BHCPR Peer Reports</a></li>
<li><a href="/npw/FinancialReport/FRY15Reports">FR Y-15 Snapshots</a></li>
<li><a href="/npw/FinancialReport/DataDownload">Data Download</a></li>
<li><a href="/npw/FinancialReport/FinancialDataDownload">Financial Data Download</a></li>
</ul> <!-- end left navigation -->
<ul class="nav navbar-nav navbar-right" role="menubar">
<li class="hidden-lg hidden-md"><a href="/npw/Help/Help">Help</a></li>
</ul> <!-- end navbar right -->
</div> <!-- end collapse navbar -->
</div>
</nav> <!-- end navbar navbar-default -->
<div class="container main-body">
<div id="maincontent" tabindex="-1"></div>
<!-- start HTML page content here- -->
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Error</title>
</head>
<body>
<hgroup>
<h1>We are sorry...</h1>
<h2>Your request cannot be served at this time. Please try again later.</h2>
</hgroup>
<script>(function(){function c(){var b=a.contentDocument||a.contentWindow.document;if(b){var d=b.createElement('script');d.innerHTML="window.__CF$cv$params={r:'8acb538d68b3ea60',t:'MTcyMjU3Mjk2MC4wMDAwMDA='};var a=document.createElement('script');a.nonce='';a.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js';document.getElementsByTagName('head')[0].appendChild(a);";b.getElementsByTagName('head')[0].appendChild(d)}}if(document.body){var a=document.createElement('iframe');a.height=1;a.width=1;a.style.position='absolute';a.style.top=0;a.style.left=0;a.style.border='none';a.style.visibility='hidden';document.body.appendChild(a);if('loading'!==document.readyState)c();else if(window.addEventListener)document.addEventListener('DOMContentLoaded',c);else{var e=document.onreadystatechange||function(){};document.onreadystatechange=function(b){e(b);'loading'!==document.readyState&&(document.onreadystatechange=e,c())}}}})();</script></body>
</html>
</div><!-- end main body container -->
<div class="sticky-footer">
<div class="container">
<!-- <div class="row"> -->
<div class="col-md-5">
<ul class="no-style">
<li>
<a href="https://www.ffiec.gov/default.htm">Federal Financial Institutions Examination Council (FFIEC) <span class="glyphicon glyphicon-new-window"></span><span class="sr-only">External site, will open new window</span></a>
</li>
<li>
<a href="https://www.federalreserve.gov/">Board of Governors of the Federal Reserve System <span class="glyphicon glyphicon-new-window"></span><span class="sr-only">External site, will open new window</span></a>
</li>
<li>
<a href="https://www.usa.gov/"><img src='/npw/Content/images/usagov_logo_white.png' class="usa-gov" alt="USA.gov logo" title="USA.gov is the U.S. government's official web portal to all federal, state, and local government web resources and services" /> <span class="glyphicon glyphicon-new-window"></span><span class="sr-only">External site, will open new window</span></a>
</li>
</ul>
</div>
<div class="col-md-4">
<ul class="no-style">
<li>
<a href="https://www.federalreserve.gov/accessibility.htm">Accessibility <span class="glyphicon glyphicon-new-window"></span><span class="sr-only">External site, will open new window</span></a>
</li>
<li>
<a href="https://www.federalreserve.gov/disclaimer.htm">Disclaimer <span class="glyphicon glyphicon-new-window"></span><span class="sr-only">External site, will open new window</span></a>
</li>
<li>
<a href="https://www.federalreserve.gov/privacy.htm">Privacy Policy <span class="glyphicon glyphicon-new-window"></span><span class="sr-only">External site, will open new window</span></a>
</li>
<li>
<a href="https://www.federalreserve.gov/iq_guidelines.htm">Information Quality Guidelines <span class="glyphicon glyphicon-new-window"></span><span class="sr-only">External site, will open new window</span></a>
</li>
</ul>
</div>
<div class="col-md-3">
<ul class="no-style">
<li><a href="/npw/Help/Help">Help</a></li>
</ul>
</div>
<!-- </div> -->
</div>
</div>
<script src="/npw/Scripts/jquery-3.6.0.js"></script>
<script src="/npw/Scripts/jquery.unobtrusive-ajax.js"></script>
<script src="/npw/Scripts/bootstrap.js"></script>
<script src="/npw/Scripts/respond.js"></script>
<script src="/npw/Content/custom.js"></script>
<script type="text/javascript">
//todo: add about highlighter thingy
var currentTab = $("ul[role='menubar'] > li ").filter(function (idx, element)
{
return $(element).text() == document.title;
});
currentTab.addClass("active");
document.title += ' - National Information Center';
$('#environmentBanner').addClass("prod-banner");
</script>
</body>
</html>
Is there any way I can read the csv files that I have in my local machine and if certain text present in my csv file (Your request cannot be served at this time. Please try again later.) then delete that file.
7
var FilePath; //your CSV file path
if (File.Exists(FilePath))
{
//handle your existing code here
}
else
{
//handle your does not exist code here
}
you need to use
using System.IO;
3