how to send a common form address- Formating for one field only

[hownow]

I have two files a filmaker file and a text file

 

This is a sample of the text file

 

·  9

First Congregational Ucc

41 Main St

Hatfield, MA

(413) 247-9540

 

·  10

First Churches ABC

129 Main St

Northampton, MA

(413) 584-9392

 

·  11

Chabad at the Five Company

194 Amity St

Amherst, MA

(413) 835-0085

 

I would like to parse the addresses into their respective fields which I have worked out already.

 

But I need to find out how to format the import so that the ENTIRE  address can populate a field

called "parse" as we see it above

 

There is a number before each address which I would like to send to another field called

"number"

 

I have enclosed a text field called sample text test doc.txt with the original form of the addresses

I have enclosed a sample FMP file with the import as I would like it to populate so I can parse it later

 

Can someone help me figure out how to do this either by pre filemaker formating or within filemaker

 

Thank you.

sample text test doc.txt

test import fmforums.fmp12.zip

[comment]

There is a number before each address

 

I don't see that in your attached document. You have exactly this:

 

All Saints Episcopal Church
7 Woodbridge St
South Hadley, MA
(413) 532-8917
 
*  7
Maple Ridge Church
659 Amherst Rd
Sunderland, MA
(413) 584-8455
 
*  8
Christ Community Church
1255 Federal St
Belchertown, MA
(413) 253-0292
 
*  9
First Congregational Ucc
41 Main St
Hatfield, MA
(413) 247-9540
 
*  10
First Churches ABC
129 Main St
Northampton, MA
(413) 584-9392
 
*  11
Chabad at the Five Company
194 Amity St
Amherst, MA
(413) 835-0085

 

Also, your first example shows live links - which indicates a document other than plain text. You need to be extremely accurate in these matters, since they make the difference between success and failure.

 

how to do this either by pre filemaker formating or within filemaker

 

What tools can you use for pre-processing outside of Filemaker? Is this a one-time conversion or will you be doing this periodically?

[hownow]

sorry I used some different address in the text file. I was just a sample

 

I have been copying from this type of page

 

https://search.yahoo.com/local/s;_ylt=AwrBJSDebV5UB3wA_pfumYlQ?p=churches&fr=spigot-chr-ffmac&fr2=sb-top&addr=BEDFORD+MA

 

as in the case of bedford churches

 

I have to do this a lot. For other types of lists

 

I use word and nisus pro to process the text if I need but when I zoom out on the web browser I can

copy the 15 page limit in one select. Then I paste into microsoft word.

 

There may be someway to get just the addresses from the web pages but I don't know how to do that.

when I do a search as above they seem to be in the same format; Once in a while there are 5 lines but mostly they are 4 lines preceeded by a number.  All I really want to do is get an addresses list with name

address, city, state, zip. and phone.   But I need to use the yahoo local searh engine as you can see in the above URL.

 

[comment]

Offhand, I would say you should see if Yahoo! provides an API for this type of search, that would allow you to get the result as formatted data. Otherwise you are looking at a lot of work.

[Lee Smith]

Not quite sure if I’m understanding you correctly, but if you are just copying the data straight out of Yahoo, and as long as you don’t have a variance in the data from which you have posted as an example, then I have modified your files so it will separate the data into their own separate fields.

 

 If you have something else in mind please let know.

 

Hope this helps, Lee

test import fmforums_Parse.fmp12.zip

[comment]

Here's another idea for you:

 

If I go to the page you have linked to, and do Select All + Copy, I get the following text:

Yahoo Local Web Search
    Home
    Mail
    News
    Sports
    Finance
    Weather
    Games
    Groups
    Answers
    Screen
    Flickr
    Mobile
    MoreSign In
Mail
Yahoo!
Search query87 results
Best Match
Category    1
    St Michael Catholic Church
    90 Concord Rd
    Bedford, MA
    (781) 275-6318
    
    2
    Lutheran Church of the Savior
    426 Davis Rd
    Bedford, MA
    (781) 275-2004
    
    3
    First Baptist Church
    155 Concord Rd
    Bedford, MA
    (781) 275-8151
    
    4
    Boston Evangelical Church
    276 Old Billerica Rd
    Bedford, MA
    (781) 275-8233
    
    5
    First Church-Christ Cngrgtnl
    25 Great Rd
    Bedford, MA
    (781) 275-7951
    
    6
    Immanuel Baptist Church
    400 Great Rd
    Bedford, MA
    (781) 275-8104
    
    7
    St Paul's Episcopal Church
    100 Pine Hill Rd
    Bedford, MA
    (781) 275-1383
    
    8
    First Parish in Bedford
    75 Great Rd
    Bedford, MA
    (781) 275-8802
    
    9
    Church of Pentecost
    17 Caesar Jones Way
    Bedford, MA
    (781) 778-7004
    
    10
    St Mary's Roman Catholic Chr
    796 Boston Rd
    Billerica, MA
    (978) 663-2215
    
    11
    Grace Chapel
    3 on Yelp
    59 Worthen Rd
    Lexington, MA
    (781) 862-6499
    
    12
    Burlington Presbyterian Church
    335 Cambridge St
    Burlington, MA
    (781) 272-0081
    
    13
    Global Evangelical Church
    113 Terrace Hall Ave, #1
    Burlington, MA
    (781) 750-8008
    
    14
    St Irene's Catholic Church
    181 East St
    Carlisle, MA
    (978) 369-3940
    
    15
    Heritage Park Baptist Church
    129 Lexington St
    Burlington, MA
    (781) 273-1669
    More search results
1 2 3 4 5 Next
Add or update your business    Yahoo
    Help
    Privacy
    Terms
    Advertise

Traffic
     Traffic

If I paste this text into a global Text field in Filemaker, and add a calculation field =

Let ( [
text = Substitute ( TrimAll ( gText ; 0 ; 0 ) ; "¶ " ; ¶ ) ;
start = Position ( text ; "Category¶¶" ; 1 ; 1 ) + Length (  "Category¶¶"  ) ;
end = Position ( text ; "¶¶More search results" ; start ; 1 ) ;
clean = Middle ( text ; start ; end - start )
] ;
Substitute ( clean ; [ "¶¶" ; "§" ] ; [ ¶ ; Char (9) ] ; [ "§" ; "¶" ] )
)

the result is:

1    St Michael Catholic Church    90 Concord Rd    Bedford, MA    (781) 275-6318
2    Lutheran Church of the Savior    426 Davis Rd    Bedford, MA    (781) 275-2004
3    First Baptist Church    155 Concord Rd    Bedford, MA    (781) 275-8151
4    Boston Evangelical Church    276 Old Billerica Rd    Bedford, MA    (781) 275-8233
5    First Church-Christ Cngrgtnl    25 Great Rd    Bedford, MA    (781) 275-7951
6    Immanuel Baptist Church    400 Great Rd    Bedford, MA    (781) 275-8104
7    St Paul's Episcopal Church    100 Pine Hill Rd    Bedford, MA    (781) 275-1383
8    First Parish in Bedford    75 Great Rd    Bedford, MA    (781) 275-8802
9    Church of Pentecost    17 Caesar Jones Way    Bedford, MA    (781) 778-7004
10    St Mary's Roman Catholic Chr    796 Boston Rd    Billerica, MA    (978) 663-2215
11    Grace Chapel    3 on Yelp    59 Worthen Rd    Lexington, MA    (781) 862-6499
12    Burlington Presbyterian Church    335 Cambridge St    Burlington, MA    (781) 272-0081
13    Global Evangelical Church    113 Terrace Hall Ave, #1    Burlington, MA    (781) 750-8008
14    St Irene's Catholic Church    181 East St    Carlisle, MA    (978) 369-3940
15    Heritage Park Baptist Church    129 Lexington St    Burlington, MA    (781) 273-1669    

(that's tab-delimited data) which should be very easy to parse into records and fields.

 

Of course, this will only work for as long as Yahoo! do not change their results format.

[hownow]

I like what you both have said. Lee Thank you I can do that but comment I tried to make that in my file

When I use the calculation it asks about gtext and will not let me proceed. I keep trying but I don't understand how to make this file.

 

OH NO

I was just playing with it. I am new but I figured out gText means the global field. I figured it out and it

 

 

WORKS!

 

Thanks I am so excited to understand this.

 I will have to work with the calculation to understand it . It is a little over my head.

 

Thanks Lee and Comment

This is so great