RE : MI-L Combining text from two columns into one
Hi, You just need to use "+" sign between column names in the column update menu. Example : Column "Name" and column "Surname", you just need to update column "Full Name" (name and surname with a space between) with : Name + " " + Surname Careful : no quote around column names. Robin. Message d'origine De: Ronning, Christine [mailto:[EMAIL PROTECTED] Date: jeu. 17/02/2005 19:14 Ã: mapinfo-l@lists.directionsmag.com Cc: Objet: MI-L Combining text from two columns into one Hi, I'm new to MapInfo and SQL so sorry if this questions is very simple. Anyways I'm trying to combine two text columns into one. What SQL command should I be using? I'm depending on my excel knowledge and was trying to use CONCATENATE, which isn't working! Also any good referene material I should be looking at for SQL? Thanks, Christine
RE : MI-L Combining text from two columns into one
oups, sorry, just realized you were talking about SQL...
Message d'origine
De: Robin Prest
Date: jeu. 17/02/2005 19:43
Ã: Ronning, Christine; mapinfo-l@lists.directionsmag.com
Cc:
Objet: RE : MI-L Combining text from two columns into one
Hi,
You just need to use "+" sign between column names in the column update
menu.
Example : Column "Name" and column "Surname", you just need to update
column "Full Name" (name and surname with a space between) with :
Name + " " + Surname
Careful : no quote around column names.
Robin.
Message d'origine
De: Ronning, Christine [mailto:[EMAIL PROTECTED]
Date: jeu. 17/02/2005 19:14
Ã: mapinfo-l@lists.directionsmag.com
Cc:
Objet: MI-L Combining text from two columns into one
Hi,
I'm new to MapInfo and SQL so sorry if this questions is very
simple. Anyways I'm trying to combine two text columns into one. What SQL
command should I be using? I'm depending on my excel knowledge and was trying
to use CONCATENATE, which isn't working! Also any good referene material I
should be looking at for SQL? Thanks,
Christine
RE : [MI-L] MI-L : Funny One - Is there a way to select by boundarycolour?...
Title: Message Hi, No problem, it's a classical one in fact. You've got a pretty nice and very useful tool here : http://members.iinet.net.au/~haycraft/iaa/ in Free Tools / SDS (Select by Drawing Style) Have fun ! Robin. ### Extract : Select By Drawing Style (SDS)If you're a Mapinfo Pro user and you want to Select some rows of a table, not by values in the text fields, but by the Drawing Style of the objects in the Obj field, then it's a real chore. For example if you need to select, from a table of Text objects, the rows containing Text features drawn with Box background Bold and Shadow effects then you'll have to type select * from TextTable into Selection where (((StyleAttr(ObjectInfo(Obj,2),2)\256) mod 2)=0) and (StyleAttr(ObjectInfo(Obj,2),5)<>-1) and (((StyleAttr(ObjectInfo(Obj,2),2)\1) mod 2)=1) and (((StyleAttr(ObjectInfo(Obj,2),2)\32) mod 2)=1) SDS is query builder tool that lets you build and execute such queries through familiar style-picker dialogs. -Message d'origine-De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de John NottEnvoyé : vendredi 2 juin 2006 12:25À : mapinfo-l@lists.directionsmag.comObjet : [MI-L] MI-L : Funny One - Is there a way to select by boundarycolour?... Hello All, This is an odd one – I have received a table containing about 3,000 sites. Approximately half of which have been updated and half haven’t. The problem is that the data capture team doing the updates have simply coloured the updated sites red and the left the unupdated ones black – they haven’t added a column to the database unfortunately. As you can imagine manually selecting all the red ones would be a pain as they are scattered amongst the table. Is there anyway or any tool that can select all the “red” site boundaries?? Told you it was a funny one!! Cheers! John Nott Consultant/GIS Analyst ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
RE : [MI-L] Selecting object types
Title: Message Hi, See below, it goes much further than what you're asking for (it selects all sorts of things, including points for exemple) Rob. From IAA Website : http://members.iinet.net.au/~haycraft/iaa/ (an Information Technology consultancy business located in Canberra, Australia) Select By Drawing Style (SDS)If you're a Mapinfo Pro user and you want to Select some rows of a table, not by values in the text fields, but by the Drawing Style of the objects in the Obj field, then it's a real chore. For example if you need to select, from a table of Text objects, the rows containing Text features drawn with Box background Bold and Shadow effects then you'll have to type select * from TextTable into Selection where (((StyleAttr(ObjectInfo(Obj,2),2)\256) mod 2)=0) and (StyleAttr(ObjectInfo(Obj,2),5)<>-1) and (((StyleAttr(ObjectInfo(Obj,2),2)\1) mod 2)=1) and (((StyleAttr(ObjectInfo(Obj,2),2)\32) mod 2)=1) SDS is query builder tool that lets you build and execute such queries through familiar style-picker dialogs. For a screenshot of the SDS dialog settings for the above query see SDS. To get a copy see Downloads. http://members.iinet.net.au/~haycraft/iaa/iaa11g.htm -Message d'origine-De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Peter Horsbøll MøllerEnvoyé : mardi 27 juin 2006 19:57À : Ronning, ChristineCc : mapinfo-l@lists.directionsmag.comObjet : RE: [MI-L] Selecting object types Christine, There is a few ways of doing this: Select * From MYTABLE Where 1. Str$(OBJ) = "Point" 2. Str$(ObjectInfo(OBJ, 1) = "5" 3. Area(OBJ, "sq m") = 0 And ObjectLen(OBJ, "m") = 0 I would recommend using the second. If you need to find other object type, the values to be used are these (copied from the MapBasic.def): Define OBJ_TYPE_ARC 1Define OBJ_TYPE_ELLIPSE 2Define OBJ_TYPE_LINE 3Define OBJ_TYPE_PLINE 4Define OBJ_TYPE_POINT 5Define OBJ_TYPE_FRAME 6Define OBJ_TYPE_REGION 7Define OBJ_TYPE_RECT 8Define OBJ_TYPE_ROUNDRECT 9Define OBJ_TYPE_TEXT 10Define OBJ_TYPE_MPOINT 11Define OBJ_TYPE_COLLECTION 12 By the way, a different approach would be to export the table to Shape using Universal Translator. This would result in a number of tables named by the object types. Remember that Shape can not contain different objecttypes in the same file. Then you just need to reimport - or open - the generated Shape files. HTH, Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ronning, ChristineSent: Tuesday, June 27, 2006 7:32 PMTo: David Reid; Bill ThoenCc: mapinfo-l@lists.directionsmag.comSubject: [MI-L] Selecting object types Hi all,Can anyone tell me how to select object types within a table? For example I have a table with points and regions but would like to seperate them out. How would I select just the points? ThanksChristine-Original Message-From: [EMAIL PROTECTED] on behalf of David ReidSent: Tue 6/27/2006 7:50 AMTo: 'Bill Thoen'Cc: mapinfo-l@lists.directionsmag.comSubject: RE: [MI-L] Strange "Find" results geocoding in MI ProViewerI should have added that within the Workspace being used, I have "Insetaddress" from end of street set to zero as these are mainly rural streetsset to 0.001 mile addressing format.Find Using Streets(COL1) Refine Using Communities(COL1) Options Abbrs OffClosestAddr Off OtherBdy Off Symbol Inset "0" Distance Units "ft" Offset "15" Distance Units "ft"When I plot the two addresses (that have come to our attention) in Mapinfo,they geocode right where their supposed to. Thus far, all other addressesthat have been searched appear where their supposed to.Additionally, the tables being used are maintained in MI 6.5, but theProviewer we're using is 6.0. I would think that would be an issue though.Strange indeedDave-Original Message-From: Bill Thoen [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 27, 2006 9:08 AMTo: David ReidCc: mapinfo-l@lists.directionsmag.comSubject: Re: [MI-L] Strange "Find" results geocoding in MI ProViewerOn Tue, Jun 27, 2006 at 08:42:57AM -0500, David Reid wrote:> Yesterday, on various addresses entered to the "Find" dialog, it started> geocoding s
RE : [MI-L] MapBasic Language Definition and program building
Title: Message Hi, I sent you an answer, but I forgot a link and the copy to the list... http://www.ultraedit.com/index.php?name=Content&pa=showpage&pid=40#wordfiles All the syntax files you need... Robin. -Message d'origine-De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Mike TongeEnvoyé : jeudi 6 juillet 2006 14:37À : MapInfo-L@lists.directionsmag.comObjet : [MI-L] MapBasic Language Definition and program building Hi List Does anyone have a language definition for mapbasic that could be used with ultraedit to provide syntax highlighting? Also does anyone know if makefiles are possible with mapbasic code? Mike Summer Placement Student Atkins All New Yahoo! Mail – Tired of [EMAIL PROTECTED]@! come-ons? Let our SpamGuard protect you. ___ MapInfo-L mailing list MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
