Example using TurboCASH and AI

To import a CSV batch from your #ABSACSV Bank into the Turbocash cashbook

#turbocashcashbookimportexport is a tab delimited file for importing data into a cashbook batch
#ABSACSV is a comma delimited file downloaded from ABSA Bank South Africa

Here is an example of a #ABSACSV Bank downloaded in CSV format
Date,Description,Amount,Balance 20230701,TRANSACTION CHARGE,-22.00,2146.76 20230701,MONTHLY ACC FEE,-58.00,2088.76
20230703,ACB CREDIT ALL TURBO,1500.00,3588.76
20230705,"NOTIFIC FEE SMS NOTIFYME ( 1,20 ) 2 SMS NOTIFICATIONS",0.00,3588.76
20230705,DIGITAL TRANSF DT 45533308-9333-3133 ABSA BANK credit card,-2242.08,1346.68
20230705,"ACB DEBIT:EXTERNAL ( 19,00 ) BLIARTY033551333330900C/P05JUL",-162.91,1183.77
20230710,ACB CREDIT TRF FROM PINK SOFTWA,2000.00,3183.77
20230711,DIGITAL TRANSF DT V ABSA BANK credit card,-2199.98,983.79
20230718,"NOTIFIC FEE SMS NOTIFYME ( 3,00 ) 5 SMS NOTIFICATIONS",0.00,983.79

Here is an example of a #turbocashcashbookimportexport exported from HANDYMAN-A
stored in
BIN\TUTORIALS\EN-TUTORIALS\HANDYMAN-A\cashbook\receipts.csv

To import a batch into TurboCASH this exact format must be used

D5000 01/03/2022 Cash received from owner G505-000 B810-000 T -5000 False Empty Empty
D5001 16/03/2022 Payment received - Thank you D1AB-GRE B810-000 T -2000 False Empty Empty
D5001 16/03/2022 Payment received - Thank you D1MA-CDS B810-000 T -1000 False Empty Empty
******** 01/03/2022 Cash received from owner B810-000 T810-000 T 5000 True Empty Empty
******** 16/03/2022 Payment received - Thank you B810-000 T810-000 T 2000 True Empty Empty
******** 16/03/2022 Payment received - Thank you B810-000 T810-000 T 1000 True Empty Empty

We require chat.openai.com to convert the #ABSACSV into #turbocashcashbookimportexport with:
ignoring column 4 Balance in #ABSACSV
using {Tab} delimiters instead of comma
put strings into columns 1 and 3
Put date in the same format as #turbocashcashbookimportexport in colums 2
Putting the fields G505-000 B810-000 into columns 4 and 5 of #turbocashcashbookimportexport
Putting the Letter T into column 6 of #turbocashcashbookimportexport
The Amount from column 3 of #absacsv as a two decimal real number - into column 7 of #turbocashcashbookimportexport
and the strings False Empty Empty into columns 8,9,10 of #turbocashcashbookimportexport
";