python xls to xlsx converter windows

def get_list_files_in_folders(path: str, file_ext: str = ''): """ directory deki ve sub directory deki dosyalarin listesini doner """ tmp_list = [] for root, dirs, files in os.walk(path): for file in files: if file.endswith(file_ext): tmp_list.append(os.path.join(root, file)) # print(os.path.join(root, file)) return tmp_list def get_file_name_from_path(path: str): return os.path.basename(path) import os import win32com.client as …

Devamını Oku »

postgresql gtip noktalı çevir

create or replace function fn_getGtipNoktali(p_gtip varchar) returns varchar language plpgsql as $$ declare temp_gtip varchar; ret_gtip varchar; begin SELECT replace(p_gtip, '.', '') into temp_gtip; select SUBSTRING ( temp_gtip ,0 , 5 )||'.'||SUBSTRING ( temp_gtip ,5 , 2 )||'.'||SUBSTRING ( temp_gtip ,7 , 2 )||'.'||SUBSTRING ( temp_gtip ,9 , 2 )||'.'||SUBSTRING …

Devamını Oku »