FiveTech Software tech support forums

Antonio Linares wrote:Dear Rick,

Code: Select all | Expand

#include "FiveWin.ch"

function Main()

   local cAddress := "258 Shoreline Drive, Columbia, SC 29212"
   
   XBrowse( hb_ATokens( cAddress, "," ) )

return nil

I prefer to ask the forum... Always the best answers

Very interesting and fascinating.
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 ...

... assumes that your addresses are formatted consistently.

harbour
Copy code
FUNCTION ParseAddress(cAddress)
LOCAL aAddress := {}
LOCAL nPos

// Splitting based on the assumption that the format is "Street, City, State ZIP"
nPos := RAT(",", cAddress) // Find the last comma
aAddress[1] := hb_substr ...

Rick, I think it has created exactly the program AT() that you posted.
Best regards,
Otto

Otto

I am taking an Excel spreadsheet whos data is taken from a web form. I then have to take that Excel file and write a conversion 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 ...

I think we are aging ... having to go back and look at previous code to remember "how we did it".
BTDT ...

... language's syntax.

Features: It offers file inclusion, substitution facilities, and conditional compilation.

Modularity: Harbourino enables splitting complex functions or classes into smaller, manageable files. For example, you can have a separate file for each method of a class, adhering to ...

Rick, why searching your notes? Ask ChatGPT:





Additional Details: '
harbour'

:'

Help splitting up a character address string

Postby Rick Lipkin » Tue Nov 14, 2023 9:29 pm
To All

I seem to have lost my ability to substring an Address field into seperate cStreet, cCity, cState and cZip ...

Antonio .. All

I had to dig out my old dBase\Harbour 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 ...

Dear Rick,

To All

I seem to have lost my ability to substring an Address field into seperate cStreet, cCity, cState and cZip variables ...

here is a address field I want to break out into the above fields

cAddress := "258 Shoreline Drive, Columbia, SC 29212"

Please help me with the code to breakout the ...