#!/bin/bash

# Extract ccTLDs from original Tranco 1m list

# File paths
CSV_FILE="ccTLDs_with_CC.csv"
DOMAIN_FILE="tranco_V99PN.csv"
OUTPUT_FILE="tranco_V99PN_ccTLDs.csv"

rm $OUTPUT_FILE

# Read the CSV file line by line
while IFS=, read -r ccTLD CC country; do
    grep -E "\.${ccTLD}$" "$DOMAIN_FILE" | sed "s/$/,-,$CC,$country,(ccTLD)/" >> $OUTPUT_FILE
    
    # Print the result
    echo "Processed ccTLD: $ccTLD ($CC, $country)"
done < "$CSV_FILE"