Faganga 0 Posted June 26, 2019 Report Share Posted June 26, 2019 Boa tarde. Há alguma forma de eliminar todas as transações com data posterior a 31/05/2017? Sendo que a data não consta em todas as linhas da transação. Exemplo de uma transação a eliminar: <Transaction> <TransactionID>2017-06-23 1 00010006002164000001</TransactionID> <Period>6</Period> <TransactionDate>2017-06-23</TransactionDate> <SourceID>XPTO</SourceID> <Description>Importação</Description> <DocArchivalNumber>00010006002164000001</DocArchivalNumber> <TransactionType>N</TransactionType> <GLPostingDate>2017-06-29T13:05:22</GLPostingDate> <Line> <RecordID>000000000000000000000000000023</RecordID> <AccountID>211115108</AccountID> <SystemEntryDate>2017-06-29T13:05:22</SystemEntryDate> <Description>Factura</Description> <DebitAmount>70.000000</DebitAmount> </Line> <Line> <RecordID>000000000000000000000000000024</RecordID> <AccountID>72112</AccountID> <SystemEntryDate>2017-06-29T13:05:22</SystemEntryDate> <Description>Factura</Description> <CreditAmount>70.000000</CreditAmount> </Line> </Transaction> Estou a usar o Notepad++ Link to post Share on other sites
M6 150 Posted June 28, 2019 Report Share Posted June 28, 2019 Com um editor terás de ver manualmente cada transação e apagar a mesma, uma a uma. 10 REM Generation 48K! 20 INPUT "URL:", A$ 30 IF A$(1 TO 4) = "HTTP" THEN PRINT "400 Bad Request": GOTO 50 40 PRINT "404 Not Found" 50 PRINT "./M6 @ Portugal a Programar." Link to post Share on other sites
Faganga 0 Posted June 28, 2019 Author Report Share Posted June 28, 2019 1 hora atrás, M6 disse: Com um editor terás de ver manualmente cada transação e apagar a mesma, uma a uma. M6, obrigado pela resposta. No entanto tal não é viável uma vez que o ficheiro tem cerca de 20 milhões de linhas. Link to post Share on other sites
M6 150 Posted July 4, 2019 Report Share Posted July 4, 2019 Assim sendo, tens de fazer um programa para tal. 10 REM Generation 48K! 20 INPUT "URL:", A$ 30 IF A$(1 TO 4) = "HTTP" THEN PRINT "400 Bad Request": GOTO 50 40 PRINT "404 Not Found" 50 PRINT "./M6 @ Portugal a Programar." Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now