import csv

import re

# Define the input and output file names and paths

baselight$\_$file $="/$Users$/$alex$/$Documents$/$pythonProjects$/$Baselight$\_$export.txt$"$

xytech$\_$file $="/$Users$/$alex$/$Documents$/$pythonProjects$/$Xytech$.$txt$"$

output$\_$file $=$ "Output.csv$"$

# Define the field names for the CSV file

fieldnames $=["$Producer$",$ "Operator", "Job", "Notes", "Location", "Frames"$]$

# Define a function to parse the data from the text files using regular expressions

def parse$\_$data$($baselight$\_$file, xytech$\_$file$)$:

# Create an empty list to store the data

data $=[]$

# Open the baselight file and read the lines

with open$($baselight$\_$file$)$ as f:

lines $=$ f$.$readlines$()$

# Loop through the lines and extract the location and frames

for line in lines:

# Skip the empty lines

if line.strip$()$:

# Use regular expressions to match the location and frames

match $=$ re$.$search$($r$"(/.+/)(\backslash$d$+)(\backslash$s$+.+)",$ line$)$

if match:

# Get the location and frames from the match object

location $=$ match.group$(1)$

frames $=$ match.group$(3)$

# Append the location and frames to the data list

data.append$([$None$,$ None, None, None, location, frames$])$

# Open the xytech file and read the lines

with open$($xytech$\_$file$)$ as f:

lines $=$ f$.$readlines$()$

# Initialize variables to store Xytech data

producer $=$ None

operator $=$ None

job $=$ None

notes $=$ None

location $=$ None

frames $=$ None

# Loop through the lines and extract the producer, operator, job, notes, and location

for line in lines:

# Skip the empty lines

if line.strip$()$:

# Use regular expressions to match the producer, operator, job, notes, and location

match $=$ re$.$search$($r$"(\backslash$w$+)$:$\backslash$s$+(.+)",$ line$)$

if match:

# Get the key and value from the match object

key $=$ match.group$(1)$

value $=$ match.group$(2)$

# Assign values to corresponding variables

if key $==$ "Producer":

producer $=$ value

elif key $==$ "Operator":

operator $=$ value

elif key $==$ "Job":

job $=$ value

elif key $==$ "Notes":

notes $=$ value

elif key $==$ "Location":

location $=$ value

# If all required fields are populated, append the data to the list

if producer and operator and job and notes and location and frames:

data$[-1][$:$4]=[$producer$,$ operator, job, notes$]$

# Reset variables for next entry

producer $=$ None

operator $=$ None

job $=$ None

notes $=$ None

location $=$ None

frames $=$ None

# Return the data list

return data

# Define a function to export the data to a CSV file using csv module

def export$\_$data$($data$,$ output$\_$file, fieldnames$)$:

# Open the output file in write mode

with open$($output$\_$file, $"$w$",$ newline$=\text{'}\text{'})$ as f:

# Create a csv writer object

writer $=$ csv$.$writer$($f$)$

# Write the field names as the header row

writer.writerow$($fieldnames$)$

# Write the data rows

writer.writerows$($data$)$

# Call the functions and write the output to the CSV file

data $=$ parse$\_$data$($baselight$\_$file, xytech$\_$file$)$

export$\_$data$($data$,$ output$\_$file, fieldnames$)$ it works but its not showing anything other than Producer Operator Job Notes Location Frames