Search Results

Search found 10060 results on 403 pages for 'column'.

Page 137/403 | < Previous Page | 133 134 135 136 137 138 139 140 141 142 143 144  | Next Page >

• How should I parse this simple text file in Java?

  - by Winston

  I have a text file that looks like this: grn129 agri- ac-214 ahss hud114 ahss lov1150 ahss lov1160 ahss lov1170 ahss lov1210 ahss What is the best way to parse this file using Java if I want to create a HashMap with the first column as the key and the second column as the value. Should I use the Scanner class? Try to read in the whole file as a string and split it? What is the best way?

  Read the article

• text replace with regex in sqlserver

  - by Thiyaneshwaran S

  Currently i have sql-server nvarchar(max) column which has text that starts with """ The only thing that varies in the pattern is the < in the class name. The common part is "" Some sample values are "" "" "" All the These span text are present only at the beginning of the column. Any such matching span in the middle should not be removed or matched. Whats the sql server query with regex to remove all these occurance of span?

  Read the article

• about Select statement !

  - by user329820

  hi, I have read that after select we use column-names but I have found a statement that was like this: SELECT 'A' FROM T WHERE A = NULL; would you lease help me? thanks (A is a column- name here?) my DBMS is MySQL

  Read the article

• PostgreSQL + Rails citext

  - by glebm

  I am trying to move to heroku which uses PostgreSQL 8.4 which has a citext column type which is nice since the app was written for MySQL. Is there any way to use :citext with rails (so that if the migrations are run on MySQL the citext would just use string/text? I found this ticket, but it seems like it isn't going to be a part of rails for a while: https://rails.lighthouseapp.com/projects/8994/tickets/3174-add-support-for-postgresql-citext-column-type

  Read the article

• selectionindexchange event in Gridview

  - by Faizan Dosani

  Hi All, I have a combo box column in vb.net datagridview . i want to perform some validation like to put some values in another text column of Grid on selectionindexchanged event of a combo box in datagridview. but unable to do so. Any Help appreciated. Thanks in Advance.

  Read the article

• Excel : Increment Row number on fill right

  - by soldieraman

  When one "Fills right in excel" , the Column name updates eg. 1st cell is =A2 If I fill right the next cell will be =B2 But rather than the column incrementing I want to increment the row number so 1st cell is =A2 The cell on its right is =A3 how do i do that?

  Read the article

• Bulk update + SQL + self join

  - by Nev_Rahd

  Hello All I would like to update a column in Table with reference to other column(s) in same table. Ex: As in figure below - I would like to update effective endate with min date whichever is greater than effective Start Date of currrent record. How can this be acheived in T-SQL. Can this be done with single update statement ? Thanks.

  Read the article

• Asp.net 3.5 ListBox DataTextFormatString value to convert the string data to TitleCase

  - by Maheep

  I have a webform with a ListBox control bind to a DataTable with a string column mapped(bound) to dataText field. This column retruns a string in all lowercase. I want to display the string in title case(sometimes uppercase) what value should I assign to DataTextFormatString field to get this functionality? Is there any better way of doing this? Thanks. Maheep

  Read the article

• Shell Script - print selected columns

  - by teepusink

  Hi, I have a txt file with columns separated by tabs and based on that file, I want to create a new file that only contains information from some of the columns. This is what I have now awk '{ print $1, $5 }' filename newfilename That works except that when column 5 contains spaces e.g 123 Street, only 123 shows up and the street is considered as another column. How can I achieve what I'm trying to do? Thanks, Tee

  Read the article

• How to get the trending tags using php and mysql?

  - by Tom

  Hello I have a table : tags(tagname,entryid,stamp) and i want to make a section for the most trending tags today, the tagname column has no unique value, because many entries has the same tag, so the php code that i want should display the most attached tags today. Note: the "stamp" column is the date of adding the tag in UNIX time stamp format. Thanks

  Read the article

• CSS :nth-child Equation

  - by Meander365

  I have an unordered list and each li makes up one item in a two column layout: col1 col2 1 2 3 4 5 6 7 8 9 10 11 12 I need to have an alternating background colour for each item BUT NOT so each item in one column is the same. So : 1,4,5,8,9,11 will have one colour; and 2,3,6,7,10,12 will have another colour. Can this be achieved with one :nth-child rule? Thanks!

  Read the article

• Microsoft Excel Programming

  - by hkf

  I have data in the form of four columns. The first three columns represent time, value1, value 2. The fourth column is binary, all 0's or 1's. Is there a way to tell excel to delete time, value1 and value 2, when the corresponding binary value in column four is 0? I know this is a lot easier in C++ or matlab, but for reasons beyond my control, I must do it in excel.

  Read the article

• Database maintenance, big binary table optimization

  - by jgemedina

  Hi i have a huge database, around 1 TB in size, most of the space is consumed by a table which stores images, the tables has right now almost 800k rows. server response time has increased, i would like to know which techniques should i use or you recomend, partitioning? o how to reorganize the table every row is accessed by the image id column, and it has its clustered index by that column, and every two days i reorganize the index and every 7 days i rebuild it, but it seems not to be working any suggestions?

  Read the article

• Select distinct values from multiple columns

  - by nuhusky2003

  I had a table (Some_Table) with two columns: A B ------------------- 1 test 2 test 3 test1 4 test1 i would like to return DISTINCT values for column B and it's associated value in column A (first in distinct set), so something like this: A B ----------- 1 test 3 test1 What is the sql?

  Read the article

• vba Loop over a non-contiguous range

  - by Jeffrey

  I have a non-contiguous range on rows (example address of myRange: $2:$2,$4:$205,$214:$214) and I would like to access a specific row and column within the range. I have tried the following: 'Get the value of the 2nd row, 1st column within the range myRange.rows(2).Cells(, 1).Value However, this is giving me the value of the 2nd row in the WorkSheet, and NOT in the range - meaning it is giving me address $3$1 - and not $4$1 Can someone please explain how I can access the values within in my range? (It may have to do with different areas) Thank You

  Read the article

• Automatic Data sorting/ analysis in Excel

  - by hkf

  I have data in the form of four columns. The first three columns represent time, value1, value 2. The fourth column is binary, all 0's or 1's. Is there a way to tell excel to delete time, value1 and value 2, when the corresponding binary value in column four is 0? I know this is a lot easier in C++ or matlab, but for reasons beyond my control, I must do it in excel.

  Read the article

• Need help with Binary Columns

  - by nusrath

  Hi, I have to query a column containing a Binary column with data like this ®â{Õ¦K!Eòû¦?;#§ø. How can i query this colmn..if I wanted something like: SELECT Name FROM Users WHERE ID = ®â{Õ¦K!Eòû¦?;#§ø THanks

  Read the article

• Problems writing a query to join two tables

  - by Psyche

  Hello, I'm working on a script which purpose is to grant site users access to different sections of the site menu. For this I have created two tables, "menu" and "rights": menu - id - section_name rights - id - menu_id (references column id from menu table) - user_id (references column id from users table) How can a query be written in order to get all menu sections and mark the ones where a given user has access. I'm using PHP and Postgres. Thank you.

  Read the article

• Store children in database preserving information about their order

  - by GUZ

  I am designing database tables for a master-detail scenario. The specific requirement is that it is necessary to store information about the order of children. I see some possible solutions (like adding a column representing a position in the sequence, or a column with foreign key to the previous child) but I would like to know the best practices how to solve such problems. Best regards Lukasz Glaz

  Read the article

• Microsoft Excel; Two conditions have to be true then be counted

  - by Chris Jones

  I'm working on a spreadsheet that two conditions have to true in order to be counted. If the month is January, and the number next to it is less than or equal to 30, then it's counted. Same rule applies for all the other months. Thus far, I have: =COUNTIFS(Sheet1!D2:D7,(SUMPRODUCT(--(MONTH(D2:D7)=1))),Sheet1!E2:E7,(COUNTIFS(E2:E7,"<=30"))) For example: Column D Jan 1, 2014 Feb 3, 2014 Feb 16, 2014 Mar 5, 2014 Mar 13, 2014 Mar 29, 2014 Column E 37 25 30 31 1 16 Outcome Jan 0 Feb 2 Mar 2

  Read the article

• I have a problem with a TextBox in an application... A window has a Grid with two columns. The left

  - by haagel

  I have a problem with a TextBox in an application... A window has a Grid with two columns. The left column contains a control with a constant width but with a height that adapts. The right column contains a TextBox that takes up all remaining space in the Grid (and thereby in the Window). The Grid is given a minimal width and height and is wrapped within a ScrollViewer. If the user resizes the window to be smaller than the minimal widht/height of the Grid, scrollbars are displayed. This is exactly how I want it to be. However, a problem occurs when the user starts typing text. If the text is to long to fit in one line in the TextBox, I want the text to wrap. Therefore I set TextWrapping="Wrap" on the TextBox. But since the TextBox has an automatic width and is wrapped in a ScrollViewer (its actually the whole Grid that is wrapped), the TextBox just keeps expanding to the right. I do want the TextBox to expand if the window is expanded, but I don't want the TextBox to expand by the text. Rather the text should wrap inside the available TextBox. If the text don't fit within the TextBox height, a scrollbar should be displayed within the TextBox. Is there a way to accomplish this? Below is some code that shows my problem. <Window x:Class="AdaptingTextBoxes.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" Title="MainWindow" Height="300" Width="400" Background="DarkCyan"> <Grid Margin="10" Name="LayoutRoot"> <ScrollViewer HorizontalScrollBarVisibility="Auto" VerticalScrollBarVisibility="Auto"> <Grid MinWidth="300" MinHeight="200"> <Grid.ColumnDefinitions> <ColumnDefinition Width="auto" /> <ColumnDefinition Width="*" /> </Grid.ColumnDefinitions> <Button Grid.Column="0" Margin="0,0,10,0" Content="Button" Width="100" /> <TextBox Grid.Column="1" AcceptsReturn="True" TextWrapping="Wrap" ScrollViewer.HorizontalScrollBarVisibility="Disabled" ScrollViewer.VerticalScrollBarVisibility="Auto" /> </Grid> </ScrollViewer> </Grid> </Window>

  Read the article

• filter items in a list view on sharepoint

  - by saravanaram

  Basically i have created a list by importing a spread sheet which contains username as one of the column. I now want to create a specific view which will show only items in the list only based on currently logged in users how do i do it. I've tried using [Me] with matching column from the imported spreadsheet but it was not working as expected.

  Read the article

• iTunes style layout using CSS

  - by Liam

  What is the best way (using HTML/CSS) to create an iTunes-style layout with the following features: a left column with a fixed width but fluid height (scrollbars for overflow) (BLUE below) a main content column with fluid width and height (scrollbars for overflow) (RED below) a bottom right box with fixed width and height which remains stuck to the bottom of the browser? (GREEN below) Here is an example: I'm happy to use Javascript/JQuery if there really isn't a pure CSS solution. Thanks!

  Read the article

• Calculation error in Datasheet view in SharePoint

  - by Marius

  I have a custom list, with calculation, in SharePoint. Everything worked fine until recently when the DataSheet will show strange or wrong % calculation in a % column. But the Standard View will show correct values. IT checked the server side and everything looked ok, I checked the formulas and even re-did them in the column and the issue persist. Anyone, any suggestion? Thanks,

  Read the article

• Finding a Identity Specification using SQL

  - by J Harley

  Good Morning, I have an MS SQL database, of which there is a column that has an identity specification. However, if I do a SQL query such as: SELECT * FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = It doesn't tell me if the column is an identity specification - is there a query that will? Many Thanks, Joel

  Read the article

< Previous Page | 133 134 135 136 137 138 139 140 141 142 143 144  | Next Page >