Untitled

#!/bin/bash

# Input and output CSV files
INPUT_CSV="input.csv"
OUTPUT_CSV="output.csv"

# Define function to determine if an AccountID is internal
is_internal() {
  local account_id="$1"
  # Replace this logic with your own determination logic
  if [[ "$account_id" == "123" || "$account_id" == "456" ]]; then
    echo "Internal"
  else
    echo "External"
  fi
}

# Read the input CSV, process, and write to output CSV
{
  # Read the header
  IFS=, read -r header && echo "${header},Status" > "$OUTPUT_CSV"

  # Read the rest of the file line by line
  while IFS=, read -r account_id name other_columns; do
    # Skip empty rows
    if [[ -z "$account_id" ]]; then
      continue
    fi

    # Determine if the account is internal or external
    status=$(is_internal "$account_id")

    # Append the result to the output file
    echo "$account_id,$name,$other_columns,$status" >> "$OUTPUT_CSV"
  done
} < "$INPUT_CSV"

echo "Processing completed. Output written to $OUTPUT_CSV"