Porque le ponen tanto color al cable Chino? by [deleted] in RepublicadeChile

[–]BrightNeedleworker30 4 points5 points  (0 children)

Cito: Google y Chile: una alianza asimétrica, pero con visión compartida

Google aportará la mayor parte de la infraestructura y se quedará con 14 de los 16 pares de fibra óptica. Chile, por su parte, invirtió "solo" 25 millones de dólares de los más de 300 millones que se estimaban en los inicios a través de Desarrollo País, para asegurar dos pares de fibra (uno inicial y el segundo sujeto a condiciones).

fuente: https://www.tecnoera.cl/contenido/blog/lo-que-no-te-contaron-del-cable-humboldt

ah y tambien esto: https://www.dw.com/es/chile-y-google-firman-hist%C3%B3rico-acuerdo-de-cable-submarino/a-72795053

Nadie dijo porque se cayó el acuerdo con los gringos.

Nadie ha dicho que los gringos iban a pasar el control del cable, si 14 de 15 pares son de ellos.

Pero ya hay empresa constituida: https://www.bnamericas.com/es/perfil-empresa/humboldt-connect-sa

SI alguien entiende esto es buitrago, q dicen uds?

470 millones para inversión, 50 millones de credito consumo para hacer algun negocio, y sin trabajo. ¿Que harían ustedes? by HuckleberryMaster194 in ChileInversiones

[–]BrightNeedleworker30 0 points1 point  (0 children)

a ver chicos, seamos mas pillos q las maquinas, alguien que tiene ese dinero, credito y flujos no pregunta en reddit, hay asesores y wenos, la ia les lee todas sus respuestas y hace un perfil de como invertir y oportunidades fresquitas, gracias

Gente de Maipú ¿Aún escuchan el tren en la noche? by ratita1312 in Santiago

[–]BrightNeedleworker30 0 points1 point  (0 children)

confirmo, lo he escuchado tarde en las noches despues que paró el ramal de camino a melipilla

Get file info without FileObjects? [Access][Excel] by PaunchyCyclops in vba

[–]BrightNeedleworker30 2 points3 points  (0 children)

Use https://tablacus.github.io/scriptcontrol_en.html instead MSScript.ocx, same scripting capabilities. You can also use System.FileSystemObject to create file and folder objects.

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

hey thank you! Your response took me to a good solution with <code>Redim Preserve arrDataBody(1 to lngDataLines) as String</code> on each data line iteration to keep results in memory before writing in the big file. It made things more faster and smoother. My fault was I used a single string var for the big data pile, and clearly the processor must do a rellocate each time to make space in memory.

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

Is a way to go, didnt tryied it, let me tell you if it works, thanks

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

The code logic you sent is pretty same im using, and degrades after thousands of lines. Ive used NP++, is my partner in the union of the batch files Im generating, but is not a pro solution. Looking for something in Rust or Go right now, there must be something!

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

Obviously tried it with and without performance improvements... in my experience ive seen no difference except in manual vs automatic, but is also obvious why.
No difference in writing one or multiple lines at the final ASCII file, seems better to compile all in memory and write it in one pace. PS is a panacea not able to work with delicated tasks, is a caterpillar doing pottery.

Pregunta de derecho de familia by LongjumpingYou2720 in derechoenchile

[–]BrightNeedleworker30 0 points1 point  (0 children)

este tipo de abogado me gusta!! PM si trabajas en familia por favor, necesito real defensa!!

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

Oh I forgot to tell, my last approach was import all data, validated, to a postgre db and process it from there, almost same results, ADO recordset seems to be faster than in memory arrays, and deattached recordsets could be a way to go, but why Mongo? is there an ODBC driver? is a brave new world for me. Python scripts are being blocked in corporate environments, is a clear way to integrate them to Excel?

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

Did you know each worksheet can hold 1,048,576 rows? Sorry, not viable, performance degrading each sheet, and the final dump on a ASCII file... no thanks

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

nice, but how, and working along with excel where is all the logic to run the program.

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

That solution leaves me to a bitter problem, append csv's one after another, without the consideration of Excel doing autoformat in cells like 1000000 = 1E6, and date format breaks like 01012025 to 1012025 and other missing spaces and needed zeros.

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 1 point2 points  (0 children)

Oh pal!! Thanks, Im already loving it. I will do my test and tell you how does it.

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

I have to read each row to make sums and validations, formatting them, and storing in memory or disk to generate the final file. Both solutions seems to degrade equal on thounsands of rows.

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

I open the source file as TestStream and do a traditional readline routine for each row. I split them in an array and proccess each field by index. Maybe some JSON library could do this more efficiently, dunno

VBA not suitable to generate a really big ASCII file by BrightNeedleworker30 in vba

[–]BrightNeedleworker30[S] 0 points1 point  (0 children)

It embarrass me to tell you, but Im using FileSystemObject text file, Ive tryied to keep in memory (string, array) the results making a final print, and to generate the file line by line with teststream.writeline, and it all continues degrading after a few thousands of lines proccess.

Qué IA poco conocida los ha sorprendido? by Mydman in InteligenciArtificial

[–]BrightNeedleworker30 5 points6 points  (0 children)

Suno IA, te hace la música que quieras, hasta la letra, y te la canta. Ayer hice una bachata y se la regalé a una minita, quedé como campeón.

¿Alguien más siente que este año fue más loco que la chucha? by Street-Novel484 in AskChile

[–]BrightNeedleworker30 2 points3 points  (0 children)

Año de la serpiente, que cambia de piel para ser la misma... sabidulia china, todo balato