New topic: Comparing a string with a mask
<http://forums.realsoftware.com/viewtopic.php?t=32268> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message amctavis Post subject: Comparing a string with a maskPosted: Sun Jan 31, 2010 5:09 am Joined: Sun Jan 28, 2007 2:37 pm Posts: 16 Hi all, I am uploading data from a CSV file and parsing it into a RealSQLDatabase which is fine. Except that within the CSV is an 'Address' field and within the address field is all of the address data. My problem is that some addresses have four lines and some have five. Trying to extract the post code (zip code) and ensure that it goes into the right data field is being a pain. Has anyone found a way to compare a string of characters with some kind of mask? I need to be able to identify the extracted string with a mask so that I can direct it to the postcode field in the recordset. I am working on the 'long way round' ... comparing characters and pairs of characters etc ... but if someone has already done it or can point to a simpler way, I'd be very grateful. Thanks, Alan ... Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
