FiveTech Software tech support forums

... And fivewin" then the answer is very different: To convert an Excel worksheet containing addresses with columns for Street, City, State, and Zip to a SQL table using Harbour and FiveWin, you can follow these steps: 1. Load the Excel file: Use the appropriate library or functions in Harbour ...

... column 1 thru the end column ( whatever ) and take all those values and stuff them into a temp .dbf file. The SQL table has Street,City, State and Zip .. however the Address excel column has street,city,state and zip concatenated into one excel column .. so the trick is as I loop through the for\next ...

... of the commas nPos1 := At(",", cAddress) nPos2 := At(",", cAddress, nPos1 + 1) // Extract the street, city, state, and zip cStreet := SubStr(cAddress, 1, nPos1 - 1) cCity := SubStr(cAddress, nPos1 + 2, nPos2 - nPos1 - 2) cState := SubStr(cAddress, nPos2 + 2, 2) cZip ...

... ... Any code help would be greatly appreciated! Thanks' ChatGPT To split the address string into separate variables for street, city, state, and zip code, you can indeed use the At() function or similar string manipulation functions. The approach depends on the programming language you're using. ...

... the correct use of AT() and RAT() but I finially wrote a function I can use to take a full address field and break it into Street, City,State and Zip .. here is the code : // test.prg#INCLUDE "FIVEWIN.CH"Function Main()Local cAddress,cStreet,cCity,cState,cZip,nAt,nRat,nLen,nDiff,nRat1,nDiff1cAddress ...

... puedes usar la librería xlsxlibhb publicada en estos foros: https://github.com/FiveTechSoft/FWH_tools/blob/master/Xlsxlibhb_ver2.zip El ordenador Apple a usar tiene microprocesador Intel ó es de los más recientes con arquitectura ARM ?

Antonio y amigos: He descargado y sacado del ZIP a Harbour desde la liga que recomendó Antonio desde luego cambié el path para que apunte a Harbour descargado. ahora tengo otros errores hbmk2: Compilando...hbmk2[app]: Error: Ejecutando ...

Antonio,

Same issue. I just emailed you the full source file for the class and the error code that was generated with the newly downloaded file.

I hope your server doesn't reject the attachment. It is small, and I changed .zip to .mls

Tim

Dear Philippe,

? hb_CStr( hb_SHA256( hb_memoRead( "filename.zip" ), nil ) )

... Library download link: https://github.com/FiveTechSoft/FWH_tools/blob/master/Xlsxlibhb_ver2.zip - Any one or both these libraries can be downloaded and linked with FWH application. FWH further provides wrapper classes for these libraries to ...

Estimado Joao, no tengo posibilidad de probarlo en Windows 7
Seguro que es un problema de las DLLS necesarias
Prueba poniendo estas
https://bitbucket.org/fivetech/fivewin- ... E_DLLS.zip
en la carpeta donde tengas FivEdit instalado

... que te solicite en la carpeta de instalación de FivEdit O prueba con estas https://bitbucket.org/fivetech/fivewin-contributions/downloads/FE_DLLS.zip Es un tema necesario a partir de añadir conexion a GitHub, etc. Ya lo explico en próximos posts

Thank you, karina, I'll try to use it.
Question about extracting long files from the .zip archive remains open

Hola,

Me parece que tiene un fichero como retorno, prueba guardar el archivo con extension .zip

... de ticket con el no. de ticket generado en el paso 2, termina con la respuesta del estado del ticket y el nombre del archivo a descargar (archivo zip) 4. Solicito descargar el archivo zip, esto me imprime la pantalla https://i.postimg.cc/Q9CMHZjn/rpta.jpg Hice la prueba en postman ...