Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- How do I... Reject alpha characters in a SQL Server Character Column?
- Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports. It takes only one piece of bad data to throw everything off. It's...
- Tags: Constraint, ZIP Code, Microsoft SQL Server, Data, Server, Difference, Character, Character Column, CHECK, Databases, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2008-01-25
- How do I... Enforce domain integrity for SQL Server data using CHECK constraints?
- This article is also available as a PDF download.You might think that simple data errors aren't terriblyimportant, but even a small error can do a lot of damage. For instance, anincorrect ZIP code doesn't seem too serious--until a new customer's orderdoesn't show up. Or imagine your best salesperson's surprise when...
- Tags: Microsoft SQL Server, Susan Harkins, ZIP code
- Technical articles 2007-03-05
Additional Resources
- Handling CSV file in UNIX
- I have a csv file in unix which has 140 columns Comma separated. I want to find 'newline character' and replace with null, only in the 137th column in the whole file. Can somebody help ?Is the newline the first newline character in the row? If so, try this...
- Tags: amit.sethia@..., line character, linux, Unix
- Q&A 2004-10-18
- Learn to use MySQL column types
- This sample chapter, taken from Sams' MySQL Language Reference, offers an overview of column types in MySQL. Learn about the different column types in MySQL, including numeric types, date and time types, and string character types.This sample chapter, taken from Sams' MySQL Language Reference, describes the properties...
- Tags: Sams Publishing, MySQL, Column Type, Open Source, Databases, Enterprise Software, Software, Data Management
- Book chapters 2005-10-27
- Excel -- breaking data in one cell to multiple
- This is a question already made by someone but I was not able o find the "questions Forum" as such. I guess this is the Question Forum, the right place to go.Given 1 colunn say, column C I hace the following datacity, stateabbreviated zip(5 digits)city ...
- Tags: pakoppan@..., Microsoft Excel
- Discussion threads 2007-05-23
- How to select blocks of columnar text in Word
- Moving text from one column to another can be frustrating unless you know a trick or two. With tables, the move is easy. For instance, switching the second and third columns in the table below is simple: Select the third column. To do so, position the cursor at the beginning of...
- Tags: Microsoft Word, Column, Susan Harkins
- Blog posts 2007-08-20
- Excel -- breaking data in one cell to multiple
- My "help" feature in not working correctly so here's my question:I am trying to take multiple email addresses in one cell and put it in separate cells in 1 column. Can someone tell me how to do this? Also what is the command to remove spaces in front...
- Tags: cell, NC Techie, software, programming, Microsoft Excel
- Discussion threads 2007-03-01
- AnyMini C: Character Count Software (exe)
- AnyMini C is automatic character count software. It is character count program for all common file formats, which supports .DOC, .RTF, .XLS, .PPT, .PPS, .HTM, .CSV, .PDF, .TXT, .ZIP and is powered by AnyCount Text Count Engine. After character count is completed, you can: view character count results on the...
- Tags: Character, AnyMini C, Microsoft Excel, Tools & Techniques, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Management
- Software downloads 2005-10-30
- Learn to use MySQL column types
- Learn about the different column types in MySQL, including numeric types, date and time types, and string character types.This sample chapter, taken from Sams' MySQL Language Reference, describes the properties of the column types in each category, and it provides a summary of the column type storage requirements.Title: MySQL Language...
- Tags: MySQL AB, MySQL, storage requirement, storage, MySQL Language Reference
- Download resources 2005-10-27
- display chinese in Firefox browser
- How do I read chinese words in Firefox browser. Do I have to install anything?thanks and regards,Select Tools--Options--click General in the left column--on the right side click the "Languages..." tab--this brings up the "Languages and Character Encoding" dialog box--click the down arrow by "Select a language to add..."--click the Add...
- Tags: choywg@..., click ok, Languages, Mozilla Firefox, software, Web browser
- Q&A 2005-11-28
- Comparing columns of numbers in Excel
- I've never used Excel before yesterday, but I have two sets of data that I transferred into one spreadsheet and I'm trying to compare values in one column with values in another(not row vs. row). For example:Column A Column C1 ...
- Tags: PRODUCTIVITY, jaymcgovern@..., Microsoft Excel
- Discussion threads 2007-09-19
- ColdFusion CFGrid Column Header Height
- Could anyone tell me how to adjust the column header height to view wrapped "column header text" in CFgrid.Many thanks for your help in advance.I am not sure but the text properties is set to wrap text?If set, automatically must adjust the high for wrapped text.Yes, wrap text is on...
- Tags: Adisha, Allaire ColdFusion, column header, header, software
- Q&A 2005-12-15
- (Dinosaur Sightings 2)
- Tape drive was 7-trackI worked with a Honeywell 437 in the early 70's. Looks like the same tape unit we had which was 7-track.I believe you are wrong on the IBM 082The IBM 082 Sorter was built during the early 1950's. It did sort one column of an...
- Tags: robert.t.moss@...
- Discussion threads 2006-07-31
- Excel: Mix Data Sort
- I need to know how to sort large amount of data in columns when data strings start with one or two characters followed by one to four numbers? For example Excel gives me : AB100, AB11, AB111, AB2,… I would like to get: AB2, AB11, AB100, AB111,…and so on.Can...
- Tags: gmihajlo@..., Microsoft Excel, software
- Q&A 2005-06-22
- Replace and create a string in VB.NET
- In this VB tip, we'll show you a quick and easy way to replace a string within a string by using the Replace method of a String object and create a string that consists of the repeated character. Have you ever needed to replace a portion of a...
- Tags: Microsoft Visual Basic.Net, Irina Medvinskaya, Microsoft development tools, Programming languages, strFull, Visual Basic Tips Newsletter, Method, String, .Net, Development Tools, Software Development, Software/Web Development
- Technical articles 2006-05-18
- Excel VBA to hide a column & unhide it
- I have the following code to enable a hidden columnG to be unhidden, should a certain subcategory in a previous columnE be chosen. I took that from an online example. However what I am trying to achieve without success is the following: I would like columnG automatically to be...
- Tags: Column, ElseIf Target.Column, False ElseIf Target.Column, fhu@..., G, Hidden, Microsoft Excel, software, Target.Value
- Q&A 2005-07-01
- Character Set Converter (zip)
- This is a conversion tool to convert from one character set to another within text documents. It supports 53 character sets, i.e. nearly all ISO 8859 character sets, all DOS character sets, most important Apple character sets and most of Windows character sets non Asian. It is also able to...
- Tags: ISO, Character Set, Iso standards, Process Improvement, Quality, Business Operations
- Software downloads 2007-08-30
- MySQL in a Nutshell: Date and Time Functions
- The ability to record dates and times in a MySQL database is a very common requirement. This paper presents the date and time functions for MySQL. Date and time data comprises only numeric strings, so it can be stored in a regular character column. However, by using temporal datatype columns,...
- Tags: MySQL, Column, Open Source, Databases, Enterprise Software, Software, Data Management
- Book chapters 2005-04-28
- Word Wrapping on Exchange 2003
- Is there a server side control to disable the 75 charachter limit on emails. When we send emails to our exchange server that has a line with more than 75 characters, it adds a line break in the end of the 75th charachter and dumps everything after the 75 character...
- Tags: e-mail, jguasch@..., Microsoft Exchange Server 2003, Microsoft Word, Plain Text, server
- Q&A 2005-06-28
- Such A Character (zip)
- Create foreign language documents with ease using the pre-designed character pads to insert language characters into any document format. Using the unique drag and drop method, the user can instantly copy and paste the character into the document.
- Tags: Character
- Software downloads 2006-07-18
- << Previous
- page 1 of 1
- Next >>
