2 Replies Latest reply: May 15, 2014 9:59 AM by qnique _ RSS

    Impossible Model

    qnique _

      I am having a nightmare trying to trap contact data from a text file. The problem appears to be the varying lengths of the addresses, some have phone numbers, others don't etc... I can just about trap the company name and website but the telephone number repeats in report view from the preceeding record. As for trapping the addresses, well I am completely stuck. Here is an example of the text:

       

      Abbey        | Print |

      Type of membership        Member

      Head office:        Abbey National House

      2 Triton Square

      Regents Place

      London

      NW1 3AN                        

      Telephone        0800 555 100                  

      Website        [url="http://www.abbey.com"]www.abbey.com[/url]

       

      ABC International Bank plc        | Print |

      Type of membership        Member

      Head office:        Arab Banking

      Corporation House

      1-5 Moorgate

      London

      EC2R 6AB                        

      Fax        020 7606 9987                  

      Website        [url="http://www.arabbanking.com"]www.arabbanking.com[/url]

       

      Accord Mortgages        | Print |

      Type of membership        Member

      Head office:        1 Filey Street

      Bradford

      BD1 5AT                        

      Website        [url="http://www.accordmortgages.com"]www.accordmortgages.com[/url]

       

      Ahli United Bank (UK) plc        | Print |

      Type of membership        Member

      Head office:        7 Baker Street

      London

      W1U 8EG                        

      Website        [url="http://www.ahliunited.com"]www.ahliunited.com[/url]

       

      AIB Group (UK) plc        | Print |

      Type of membership        Member

      Head office:        4 Queens Square

      Belfast

      BT1 3DJ                        

      Website        [url="http://www.aib.ie"]www.aib.ie[/url]

       

      Airdrie Savings Bank        | Print |

      Type of membership        Member

      Head office:        56 Stirling Street

      Airdrie

      ML6 0AW                        

      Telephone        01236 766 851                  

      Fax        01236 749 462                  

      Website        [url="http://www.airdriesavingsbank.com"]www.airdriesavingsbank.com[/url]

       

      Alliance & Leicester plc        | Print |

      Type of membership        Member

      Head office:        Customer Service Centre

      Carlton Park

      Narborough

      Leicester

      LE19 0AL

      DX 11000 LEICESTER                        

      Website        [url="http://www.alliance-leicester.co.uk"]www.alliance-leicester.co.uk[/url]

       

      Allied Irish Bank (GB)        | Print |

      Type of membership        Member

      Head office:        Bankcentre Britain

      Belmont Road

      Uxbridge

      Middlesex

      UB8 1SA

      DX 45104 UXBRIDGE                        

      Website        [url="http://www.aibgb.co.uk"]www.aibgb.co.uk[/url]

       

      Amber Homeloans Ltd        | Print |

      Type of membership        Member

      Head office:        The Bailey

      Skipton

      North Yorkshire

      BD23 1DN                        

      Telephone        01756 694 411                  

      Fax        01756 705 734                  

      Website        [url="http://www.amberhomeloans.co.uk"]www.amberhomeloans.co.uk[/url]

       

      Bank of Cyprus UK        | Print |

      Type of membership        Member

      Head office:        27-31 Charlotte Street

      London

      W1T 1RP                        

      Telephone        020 8267 7222                  

      Website        [url="http://www.bankofcyprus.co.uk"]www.bankofcyprus.co.uk[/url]

       

      Bank of Ireland Home Mortgages Ltd        | Print |

      Type of membership        Member

      Head office:        Plaza West

      Bridge Street

      Reading

      Berkshire

      RG1 2LZ

      DX 4029 READING-1                        

      Website        [url="http://www.bank-of-ireland.co.uk"]www.bank-of-ireland.co.uk[/url]

        • Impossible Model
          Grant Perkins

          Hi,

           

          Is this close to the format of the original text file?

           

             Originally posted by qnique:

          [font="courier"]Abbey        | Print |

          Type of membership        Member

          Head office:        Abbey National House

          2 Triton Square

          Regents Place

          London

          NW1 3AN                        

          Telephone        0800 555 100                  

          Website        URL=http://www.abbey.comwww.abbey.com[/URL]

           

          ABC International Bank plc        | Print |

          Type of membership        Member

          Head office:        Arab Banking

          Corporation House

          1-5 Moorgate

          London

          EC2R 6AB                        

          Fax        020 7606 9987                  

          Website        URL=http://www.arabbanking.comwww.arabbanking.com[/URL]

           

          Accord Mortgages        | Print |

          Type of membership        Member

          Head office:        1 Filey Street

          Bradford

          BD1 5AT                        

          Website        URL=http://www.accordmortgages.comwww.accordmortgages.com[/URL]

           

          Ahli United Bank (UK) plc        | Print |

          Type of membership        Member

          Head office:        7 Baker Street

          London

          W1U 8EG                        

          Website        URL=http://www.ahliunited.comwww.ahliunited.com[/URL]

           

          AIB Group (UK) plc        | Print |

          Type of membership        Member

          Head office:        4 Queens Square

          Belfast

          BT1 3DJ                        

          Website        URL=http://www.aib.iewww.aib.ie[/URL]

           

          Airdrie Savings Bank        | Print |

          Type of membership        Member

          Head office:        56 Stirling Street

          Airdrie

          ML6 0AW                        

          Telephone        01236 766 851                  

          Fax        01236 749 462                  

          Website        URL=http://www.airdriesavingsbank.comwww.airdriesavingsbank.com[/URL]

           

          Alliance & Leicester plc        | Print |

          Type of membership        Member

          Head office:        Customer Service Centre

          Carlton Park

          Narborough

          Leicester

          LE19 0AL

          DX 11000 LEICESTER                        

          Website        URL=http://www.alliance-leicester.co.ukwww.alliance-leicester.co.uk[/URL]

           

          Allied Irish Bank (GB)        | Print |

          Type of membership        Member

          Head office:        Bankcentre Britain

          Belmont Road

          Uxbridge

          Middlesex

          UB8 1SA

          DX 45104 UXBRIDGE                        

          Website        URL=http://www.aibgb.co.ukwww.aibgb.co.uk[/URL]

           

          Amber Homeloans Ltd        | Print |

          Type of membership        Member

          Head office:        The Bailey

          Skipton

          North Yorkshire

          BD23 1DN                        

          Telephone        01756 694 411                  

          Fax        01756 705 734                  

          Website        URL=http://www.amberhomeloans.co.ukwww.amberhomeloans.co.uk[/URL]

           

          Bank of Cyprus UK        | Print |

          Type of membership        Member

          Head office:        27-31 Charlotte Street

          London

          W1T 1RP                        

          Telephone        020 8267 7222                  

          Website        URL=http://www.bankofcyprus.co.ukwww.bankofcyprus.co.uk[/URL]

           

          Bank of Ireland Home Mortgages Ltd        | Print |

          Type of membership        Member

          Head office:        Plaza West

          Bridge Street

          Reading

          Berkshire

          RG1 2LZ

          DX 4029 READING-1                        

          Website        URL=http://www.bank-of-ireland.co.ukwww.bank-of-ireland.co.uk[/URL] /font[/quote][/b][/quote]You will need a few of the less obvious techniques available from Monarch to grapple with this one. I suspect you are using Appends and Footers to get at the fields which may or may not appear and this is what is giving the erroneous repeats. It looks like it would be better to try to deal with them as fields within a detail record making use of the Advanced Properties > Start Field On > Preceding String funcitonality.

           

          It would be much easier to make a sample model and send it for you to investigate than to to describe everything. If the samp[le looks about right I couold use that. If it is wrong or has other problems it might be better to work with a more complete example of the original file. Let me know if you think a file would be best.(A Private Message will reach me)

           

          Grant

           

           

          EDIT: To add  - Also need to know which verison of Monarch you have.

          • Impossible Model
            qnique _

            The text is in exactly the format/layout as I'm trying to model. I would really appreciate all the help you can offer.