extract by delimiter

Jim Ault jimaultwins at yahoo.com
Tue Dec 28 19:11:10 EST 2010


Try this approach, since this is an XML-like format that you need to  
unwind to database style.

every line begins with word 1 as a category
  then a string of attributes as
      attrib="string with spaces"

--------- working code ---------------
on parseToArray
    put fld 1 into block --your data
    set the itemDel to "="
    repeat for each line LNN in block

       put word 1 of LNN into cat
       put word 2 to -1 of LNN into attributes
       replace (quote&space) with (quote&cr) in attributes
       --because it is like XML, we need to...
       if cat = "forecast" then
          get line 1 of attributes
          put char 2 to -2 of item 2 of IT after cat
          --making cat unique for an array
          delete line 1 of attributes
       end if
       -- now every pair is on a separate line
       --build an array of unique keys using 'cat'
       repeat for each line ATR in attributes
          put char 2 to -2 of item 2 of ATR into arrayStor[ (cat &&  
word 1 of item 1 of ATR) ]
       end repeat
    end repeat

    combine arrayStor using cr and "^"
    ;put arrayStor
end parseToArray

------------------------- output
astronomy sunrise^7:39 am
astronomy sunset^4:58 pm
atmosphere humidity^51
atmosphere pressure^30.04
atmosphere rising^1
atmosphere visibility^10
condition code^26
condition date^Tue, 28 Dec 2010 4:52 pm EST
condition temp^30
condition text^Cloudy
forecastTue code^27
forecastTue date^28 Dec 2010
forecastTue high^30
forecastTue low^22
forecastTue text^Mostly Cloudy
forecastWed code^28
forecastWed date^29 Dec 2010
forecastWed high^32
forecastWed low^25
forecastWed text^Mostly Cloudy
location city^Bethel Park
location country^United States
location region^PA
units distance^mi
units pressure^in
units speed^mph
units temperature^F
wind chill^21
wind direction^250
wind speed^10


On Dec 28, 2010, at 2:58 PM, Thomas McGrath III wrote:

> I am stuck. I've been trying to extract text from an RSS feed and so  
> far I have the information I need but am stuck at extracting it into  
> a better format. Here is what I have so far:
>
> location city="Bethel Park" region="PA"   country="United States"
> units temperature="F" distance="mi" pressure="in" speed="mph"
> wind chill="21"   direction="250"   speed="10"
> atmosphere humidity="51"  visibility="10"  pressure="30.04"   
> rising="1"
> astronomy sunrise="7:39 am"   sunset="4:58 pm"
> condition  text="Cloudy"  code="26"  temp="30"  date="Tue, 28 Dec  
> 2010 4:52 pm EST"
> forecast day="Tue" date="28 Dec 2010" low="22" high="30"  
> text="Mostly Cloudy" code="27"
> forecast day="Wed" date="29 Dec 2010" low="25" high="32"  
> text="Mostly Cloudy" code="28"
>
> I can't delimit with space as "location city" has a space in it.
> I can't use = because then I get " "Bethel Park" region" instead of  
> just "Bethel Park"

Jim Ault
Las Vegas






More information about the Use-livecode mailing list