2 Replies Latest reply: May 15, 2014 9:54 AM by RichardW _ RSS

    Comma as a delimiter

    RichardW _

      I am trying to create a n=model for a file that has commas as a delimiter, the help file tells me to go to the open/join database wizard but i can't find it anywhere, here is a copy of the type of file.

      60,2,671264,66,13/11/2002,13:15,20032,eLaser 3.05.02

      61,8608717293,12,10.0,"N",1,"AL5 1PW",90440511268138520960,"JOHN SELFE 7","UNIT 7 SOUTHDOWN IND EST","HARPENDEN",,"HERTFORSHIRE","","","671264","066872","317","","",,,,,,,,,

      62,8138520962,,,,,,

      61,8608717249,12,10.0,"N",1,"ME10 3JG",94211031268138520916,"BRIAN HOLLYWOOD 5","UNIT 41 SITTINGBOURNE IND EST","CROWN QUAY LANE",,"SITTINGBOURNE","KENT","","671264","10-52302","133","","",,,,,,,,,

      62,8138520918,,,,,,

      61,8608717260,12,10.0,"N",1,"BN5 9XR",90780591268138520932,"KEVIN NORRIS 5","UNIT 33 MACKLEYS IND EST","HENFIELD ROAD",,"SMALL DOLE","WEST SUSSEX","","671264","10-52371","137","","",,,,,,,,,

      62,8138520930,,,,,,

      61,8608717150,12,10.0,"N",1,"SE1 9JZ",96130191268138520827,"IAN STARK","BUNZL  VENDING  BANKSIDE","5-7 SUMNER      STREET",,"LONDON","","","671264","10-52553","111","","",,,,,,,,,

      62,8138520820,,,,,,

      61,8608717271,12,10.0,"N",1,"SM3 9QP",96210391268138520947,"PETER JONES SVS","UNIT 16 MINDEN ROAD","KIMPTON BUSINESS PARK",,"SUTTON","SURREY","","671264","10-52582","120","","",,,,,,,,,

      62,8138520940,,,,,,

      61,8608717238,12,10.0,"N",1,"BN23 6PU",90782361268138520906,"ALEX KEVILL DAVIS","BLOCK 17C 8 LISTER ROAD","HIGHFIELD IND ESTATE",,"EASTBOURNE","EAST SUSSEX","","671264","10-52599","144","","",,,,,,,,,

      62,8138520907,,,,,,

      61,8608717140,12,10.0,"N",1,"BN1 8AF",90780181268138520816,"BUNZL VENDINGSERVICES (7)","UNIT A3 HOLLINGBURY ENTERPRISE EST","CROWHURST ROAD",,"BRIGHTON SUSSEX","","","671264","20-3890","202","","",,,,,,,,,

      62,8138520819,,,,,,

      61,8608717205,12,10.0,"N",1,"OX8 6BH",95040861268138520877,"IAN HINKLEY 7","UNIT 4","TWO RIVERS IND EST",,"STATION LANE","WITNEY OXFORDSHIRE","","671264","30-34317","316","","",,,,,,,,,

      62,8138520874,,,,,,

      61,8608717227,12,10.0,"N",1,"RG30 4EA",95833041268138520893,"MIKE BURLOW 7","3 MARCUS CLOSE","OFF UPTON ROAD",,"TILEHURST","BERKSHIRE","","671264","30-34356","329","","",,,,,,,,,

      62,8138520896,,,,,,

      61,8608717216,12,10.0,"N",1,"TW14 OLW",96631401268138520885,"MIKE LACEY 7","UNIT 3 HASLEMERE IND EST","ARMADALE ROAD",,"FELTHAM","MIDDLESEX","","671264","30-34447","327","","",,,,,,,,,

      62,8138520885,,,,,,

      61,8608716963,12,10.0,"N",1,"NR12 EN",94660121268138520631,"GARY  SAUNDERS  6","31 EUROPA WAY","MARINEAU LANE",,"NORWICH","NORFOLF","","671264","40-40918-02","421","","",,,,,,,,,

      62,8138520632,,,,,,

      61,8608717183,12,10.0,"N",1,"CM19 5TJ",91091951268138520851,"MICK  BUNYAN 6","3 ASH IND EST","FLEX MEADOW",,"THE PINNACLES HARLOW","ESSEX","","671264","40-41187","419","","",,,,,,,,,

      62,8138520852,,,,,,

      61,8608717194,12,10.0,"N",1,"BS2 0QS",90830201268138520866,"JOHN MOYLAND","BUNZL  VENDING  BRISTOL","UNIT 2 DAYS RD",,"BRISTOL","","","671264","50-30215","524","","",,,,,,,,,

      62,8138520863,,,,,,

      61,8608717161,12,10.0,"N",1,"BS2 0QS",90830201268138520835,"MARYN UZZELL","BUNZL  VENDING  BRISTOL","UNIT 2 DAYS RD",,"BRISTOL","","","671264","50-30252","517","","",,,,,,,,,

      62,8138520830,,,,,,

      61,8608717250,12,10.0,"N",1,"SO14 3AZ",96231431268138520925,"TONY STOREY","10 QUEENSWAY","SOUTHAMPTON",,"HAMPSHIRE","HANTS","","671264","50-30258","514","","",,,,,,,,,

      62,8138520929,,,,,,

      61,8608717282,12,10.0,"N",1,"SP2 7PH",96240271268138520958,"ALAN BAILEY 4","UNIT A","TELFORD ROAD",,"SALISBURY","WILTSHIRE","","671264","50-30262","521","","",,,,,,,,,

      62,8138520951,,,,,,

      61,8608716996,12,10.0,"N",1,"WS9 9AA",97550991268138520664,"MICK EVANS 3","UNIT4/5 COPPICE LANE","ALDRIDGE",,"WEST MIDLANDS","","","671264","60-28635","621","","",,,,,,,,,

      62,8138520665,,,,,,

      61,8608716985,12,10.0,"N",1,"CO4 4QX",91110441268138520659,"BUNZL VENDING SERVICE","BRUNEL HOUSE   BRUNEL WAY","SEVERALLS IND ESTATE",,"COLCHESTER","","","671264","68732","410","","",,,,,,,,,

      62,8138520654,,,,,,

      61,8608716974,12,10.0,"N",1,"SE1 9JZ",96130191268138520643,"BUNZL VENDING SERVICES (B/ SIDE)","","",,"LONDON","","","671264","69215","153","","",,,,,,,,,

      62,8138520643,,,,,,

      61,8608717073,12,10.0,"N",1,"GL2 5YD",92360251268138520748,"IAN COX 4","UNIT 2","CAPITOL PARK",,"103 PEARCE WAY","GLOUCESTER","","671264","69662","512","","",,,,,,,,,

      62,8138520742,,,,,,

      61,8608717117,12,10.0,"N",1,"BS2 0QS",90830201268138520781,"ALAN VARNEY","BUNZL  VENDING  BRISTOL","UNIT 2 DAYS RD",,"BRISTOL","","","671264","69663","522","","",,,,,,,,,

      62,8138520786,,,,,,

      61,8608717095,12,10.0,"N",1,"SN5 7UJ",96220571268138520766,"DOUGLAS CONELL","UNIT 2 COBHAM CENTRE","WESTMEAD IND EST",,"SWINDON","WILTSHIRE","","671264","69664","520","","",,,,,,,,,

      62,8138520764,,,,,,

      61,8608717084,12,10.0,"N",1,"SN5 7UJ",96220571268138520759,"DOUGLAS CONELL","UNIT 2 COBHAM CENTRE","WESTMEAD IND EST",,"SWINDON","WILTSHIRE","","671264","69665","520","","",,,,,,,,,

      62,8138520753,,,,,,

      61,8608717062,12,10.0,"N",1,"GL2 5YD",92360251268138520731,"IAN COX 4","UNIT 2","CAPITOL PARK",,"103 PEARCE WAY","GLOUCESTER","","671264","69672","512","","",,,,,,,,,

      62,8138520731,,,,,,

      61,8608717051,12,10.0,"N",1,"GL2 5YD",92360251268138520724,"IAN COX 4","UNIT 2","CAPITOL PARK",,"103 PEARCE WAY","GLOUCESTER","","671264","69674","512","","",,,,,,,,,

      62,8138520720,,,,,,

      61,8608717128,12,10.0,"N",1,"BS2 0QS",90830201268138520798,"ALAN VARNEY","BUNZL  VENDING  BRISTOL","UNIT 2 DAYS RD",,"BRISTOL","","","671264","69677","522","","",,,,,,,,,

      62,8138520797,,,,,,

      61,8608717106,12,10.0,"N",1,"GL14 2PQ",92361421268138520773,"PAUL WRIGHT 4","27 FOXES BRIDGE ROAD","CINDERFORD",,"GLOUCESTER","","","671264","69678","519","","",,,,,,,,,

      62,8138520775,,,,,,

      61,8608717139,12,10.0,"N",1,"BS2 0QS",90830201268138520804,"ALAN VARNEY","BUNZL  VENDING  BRISTOL","UNIT 2 DAYS RD",,"BRISTOL","","","671264","69683","522","","",,,,,,,,,

      62,8138520808,,,,,,

      61,8608717029,12,10.0,"N",1,"PR4 2TZ",95300421268138520694,"IAIN SOMMERVILLE 2","INTERLINK HOUSE","PROGRESS BUSINESS PARK",,"ORDERS LANE","KIKHAM LANCASHIRE","","671264","70-36934","712","","",,,,,,,,,

      62,8138520698,,,,,,

      61,8608717030,12,10.0,"N",1,"PR4 2TZ",95300421268138520700,"IAIN SOMMERVILLE 2","INTERLINK HOUSE","PROGRESS BUSINESS PARK",,"ORDERS LANE","KIKHAM LANCASHIRE","","671264","70-36952","712","","",,,,,,,,,

      62,8138520709,,,,,,

      61,8608717172,12,10.0,"N",1,"S20 3PJ",96082031268138520842,"JOHN STANIFORTH 2","UNIT 2A","MEADOWBROOK IND ESTATE",,"STATION ROAD HALFWAY","SHEFFIELD WEST YORKSHIRE","","671264","70-37279-01","722","","",,,,,,,,,

      62,8138520841,,,,,,

      61,8608717007,12,10.0,"N",1,"G40 3QF",92244031268138520671,"JOHN  MCINTYRE  1","115 BODEN STREET","GLASGOW",,"","","","671264","80-13899","815","","",,,,,,,,,

      62,8138520676,,,,,,

      61,8608717018,12,10.0,"N",1,"G20 7LU",92242071268138520682,"JASON MULLER","BUNZL  VENDING  GLASGOW","UNIT 2 GARSCUBE RD",,"GLASGOW","","","671264","80-15963-01","813","","",,,,,,,,,

      62,8138520687,,,,,,

      61,8608717040,12,10.0,"N",1,"G42 8LJ",92244281268138520711,"DAVID HUNTER","INTERLINK GLASGOW","",,"","","","671264","80-16176176","816","","",,,,,,,,,

      62,8138520710,,,,,,

      69,34,34,

      [email="richard.webb@bunzlvend.com"]richard.webb@bunzlvend.com[/email]   :rolleyes:    :rolleyes:    :rolleyes:

        • Comma as a delimiter
          Grant Perkins

          Richard,

           

          What is it that you can't find? I assume the open/join database option rather than the file you want to use?

           

          Which version of Monarch do you have? I assume it must be one that offers the facility you require if the help suggests it.

           

          If V5 or V6 you need to go to 'File' >> 'Open Database' and then do whatever you need to do to find your target file.

           

          I have used this very successfully previously so if it fails to work for you there may be some fundamental problem that has to be identified.

           

          Grant

           

          Originally posted by Richard:

          I am trying to create a n=model for a file that has commas as a delimiter, the help file tells me to go to the open/join database wizard but i can't find it anywhere, here is a copy of the type of file.

          /b[/quote]

          • Comma as a delimiter
            RichardW _

            Thanks very much Grant your solution worked fine 

            Richard Sorry i forgot to say that I was using V6  smile.gif[/img]