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!
Search results for query: *
- Users: drummer721
- Order by date
-
parsing and restructuring a field in a table
Your statement is basically true. AND When I looked through the data, I do have a number of records where there is no "/". However, all those records have the info in the format of FirstName LastName. For purposes of printing labels via Paradox, that works out ok. I formatted the labels as...- drummer721
- Post #7
- Forum: Corel: Paradox
-
parsing and restructuring a field in a table
Tony, My deepest thanks. I took what you wrote and again modified it as follows: tc."FIRSTNAME".breakapart(arField,"/") if arField.size()>1 then tc."LASTNAME"=arField[1] tc."FIRSTNAME"=arField[2] else endif It ran just fine. Thank you, thank you.!!- drummer721
- Post #5
- Forum: Corel: Paradox
-
parsing and restructuring a field in a table
Tony, Thanks for the quick reply. I took what you showed me and modified as follows: var arField Array[] string tc tcursor endvar tc.open("Mail2tmp.dbf") tc.edit() scan tc: tc."FIRSTNAME".breakapart(arField,"/") tc."FIRSTNAME"=arField[2]+" "+arField[1] endscan tc.endedit()...- drummer721
- Post #3
- Forum: Corel: Paradox
-
parsing and restructuring a field in a table
I have a data file I want to use that has Name field with the data in the format of LastName/ Firstname I need it in the format FirstName Lastname. I have not been able to find any examples to write a short Objectpal script to do this. Can someone please help? Thanks- drummer721
- Thread
- Replies: 6
- Forum: Corel: Paradox
