FiveTech Software tech support forums

... fortunant enough to export my Customers data into an Excel file which I imported into MS Access. I have all the usual fields like Company Contact Street City, State and Zipcode In my Customers old Sage Product it allowed him to print envelops in all the Standard sizes and I was hoping Someone ...

... function. ``` h['response'] += "{" + '"name":' + '"' + ALLTRIM(address->name) + '",' h['response'] += '"street":' + '"' + ALLTRIM(address->street) + '",' h['response'] += '"city":' + '"' + ALLTRIM(address->city) + '"},' ...

This is the type of csv file that we have to generate from a DBF: customer.csv ID,FIRST,LAST,STREET,CITY,STATE,ZIP,HIREDATE,MARRIED,AGE,SALARY,NOTES 1,Homer,Simpson,32179 Maiden Lane,Springfield,IL,20503-8202,1992-09-18,True,50,5900.0,This is a test for record 1 2,Ceci,Gibbard,9540 ...

... If you ask "... 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 ...

... program that starts at 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 ...

... nPos2 // Find the position 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, ...

... the various attributes ... 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 ...

... help file for 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 ...

... Test() local oDlg, oBrw, oFont, nWild := 2 local cList, aFlds, aHdrs local nChoice, uDataSource local cAlias,oWndChild cList := "First,Last,Street,State,HireDate" cAlias = cGetNewAlias( cFileNoExt("CUSTOMER.DBF" ) ) USE CUSTOMER SHARED NEW ALIAS (cAlias) SET ORDER TO TAG FIRST ...

Silvio, Please try : chr(13)+chr(10) in stead of CRLF COLUMNS "ID", "FIRST+CHR(13)+CHR(10)+LAST", ; "STREET+CHR(13)+CHR(10)+CITY+CHR(13)+CHR(10)+STATE+ '-' + ZIP" ; HEADERS "ID", "NAME", "ADDRESS" ; I can be wrong )))) Not correct. ...

Silvio, Please try : chr(13)+chr(10) in stead of CRLF COLUMNS "ID", "FIRST+CHR(13)+CHR(10)+LAST", ; "STREET+CHR(13)+CHR(10)+CITY+CHR(13)+CHR(10)+STATE+ '-' + ZIP" ; HEADERS "ID", "NAME", "ADDRESS" ; I can be wrong ))))

... do case case cData = "CustName" ... set index name ... scope the data for quick access case cData = "CustStreet" set index street scope the data otherwise // more fields have been filled in, so filtering will be a better option do the filter stuff endcase here is my current ...

... Now you can set "FastReport" to generate a PDF in "silent mode". On our web servers, we have installed our "Grafton Street local host server" in addition to APACHE. If, for example, reports are requested from the web, the localhost server forwards the request ...

Silvio, This line should be like this: local cHeaders := "Fist,Last,Street,State,HireDate" Sorry Antonio, I made this morning a mistake I copied a bad test , the test is this ... #include "fivewin.ch"#include "constant.ch"#include ...

Silvio,

This line should be like this:

local cHeaders := "Fist,Last,Street,State,HireDate"