Hello,
I would appreciate some help with a problem I am trying to solve.
I don't have much knowledge of creating macros and I need to create one to export a table in a “txt” file with some field properties:
- Each field need to be separated with a comma and a space (“, ”)
- Time:hh:mm:ss
- Total Value: €€€.cc
- Blanckfield: field with empty data
- Name:ClientName
- Finish with a comma “,”
Example of the input information:
Time:09:39:29 01/01/20222
TotalValue: 134,35
ClientName: Client01
Example of the output information in the text file:
09:39:29, 134.35, , Client01,
I already create a query trying to transform the input data but I really need some help...
Any suggestions would be greatly appreciated!
Thank you in advanced.
I would appreciate some help with a problem I am trying to solve.
I don't have much knowledge of creating macros and I need to create one to export a table in a “txt” file with some field properties:
- Each field need to be separated with a comma and a space (“, ”)
- Time:hh:mm:ss
- Total Value: €€€.cc
- Blanckfield: field with empty data
- Name:ClientName
- Finish with a comma “,”
Example of the input information:
Time:09:39:29 01/01/20222
TotalValue: 134,35
ClientName: Client01
Example of the output information in the text file:
09:39:29, 134.35, , Client01,
I already create a query trying to transform the input data but I really need some help...
Any suggestions would be greatly appreciated!
Thank you in advanced.
- Anexos
- ExportTXT.zip
- Você não tem permissão para fazer download dos arquivos anexados.
- (56 Kb) Baixado 8 vez(es)