def table(self,
input_table,
output_workbook,
use_field_alias_as_column_header=False):
if not arcpy.Exists(input_table):
raise ValueError("input_table does not exist.")
output_workbook = Path(output_workbook).resolve()
if output_workbook.exists():
raise ValueError("output_table already exists.")
# get input feature class description for copy process
d = arcpy.Describe(input_table)
if not d.dataType == "Table":
raise ValueError("input_table is not of type 'Table'.")
output_workbook = xlsxwriter.Workbook(str(output_workbook))
sheet_name = self._table_default_name(d, output_workbook)
self._table(d, output_workbook, sheet_name,
use_field_alias_as_column_header)
output_workbook.close()
invalid_txt = Path(target_invalid_path).open(mode='w',
encoding='utf8',
errors='ignore')
valid_txt = Path(target_valid_path).open(mode='w',
encoding='utf8',
errors='ignore')
with Path(source_path).open(mode='r', encoding='utf8',
errors='ignore') as sample_txt:
count_total = 0
count = 0
for idx, line in enumerate(sample_txt):
line = line.strip()
if len(line) > 0:
# if not is_valid(line.replace(' ', '')) and contains_invalid_unicode_characters(line.replace(' ', '')):
if contains_invalid_unicode_characters(line.replace(' ', '')):
invalid_txt.write(line + '\n')
count += 1
if count % 100000 == 0:
print(
'Wrote %d lines in invalid file from a total of %d lines'
% (count, count_total))
else:
valid_txt.write(line + '\n')
count_total += 1
print('Wrote %d lines in invalid file from a total of %d lines' %
(count, count_total))
invalid_txt.close()
valid_txt.close()
sample_txt.close()
