switch to TSV files to not worry about commas

1 files changed, 6 insertions, 6 deletions

diff --git a/screener.js b/screener.js
index f607476..68f1138 100644
--- a/screener.js
+++ b/screener.js
@@ -175,7 +175,7 @@ const formatDataFromHistories = (histories) => {
         
         const mappedValues = {
             Ticker: symbol,
-            Name: name.replace(',', ' '), // replace commas in name with spaces for CSV
+            Name: name,
             '% Weight': weight,
             'Sector': sectorMap[symbol] ? sectorMap[symbol][0] : 'Unknown',
             'Subsector': sectorMap[symbol] ? sectorMap[symbol][1] : 'Unknown',
@@ -192,12 +192,12 @@ const formatDataFromHistories = (histories) => {
     });
 
     // write the formatted data to a CSV file
-    const csvContent = csv_final.map(e => e.join(',')).join('\n');
-    if (fs.existsSync('sp500_formatted_data.csv')) {
-        fs.unlinkSync('sp500_formatted_data.csv');
+    const csvContent = csv_final.map(e => e.join('\t')).join('\n');
+    if (fs.existsSync('sp500_formatted_data.tsv')) {
+        fs.unlinkSync('sp500_formatted_data.tsv');
     }
-    fs.writeFileSync('sp500_formatted_data.csv', csvContent);
-    console.log('Formatted data saved to sp500_formatted_data.csv');
+    fs.writeFileSync('sp500_formatted_data.tsv', csvContent);
+    console.log('Formatted data saved to sp500_formatted_data.tsv');
     return csv_final;
 };
 // testGetHistories();