Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Seperating Add1 Add2 City State and Zip
LOGIUS, Yes, each field add1 add2 csz are always 30 bytes, populated or not. The data is just pushed back 30 if it's not populated. But the entire field will always have 90 bytes. Hank Kirlin- HankK
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Seperating Add1 Add2 City State and Zip
Hello all, I looking for a little help on seperating a single cell in Excel 2000. The cell contains add1,add2,city,state, & zip. The problem is that some records contain just add1, city, state, and zip with no add2. 419 500TH ST BOX 999 MAMARONECK NY 10543 1511 Helphand PL...- HankK
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Converting Julian Dates for input, to a Fox2.5 Program
I have a program in FPD 2.5. I use a client upload program to import work to the databases. I have a client that used to give me dates as "19991231" yyyymmdd. I converted with the function: CTOD(SUBSTR(DT,5,2)+'/'+SUBSTR(DT,7,2)+'/'+SUBSTR(DT,1,4)). They just recently changed to the...- HankK
- Thread
- Replies: 4
- Forum: Microsoft: FoxPro
