Sponsored Content
Top Forums Programming Query to SELECT only Column Names that Contain a Specific String? Post 302879240 by mrm5102 on Wednesday 11th of December 2013 11:30:44 AM
Old 12-11-2013
Hey Robin, thanks for the reply!

Sorry for the delay in my reply, the weather has been pretty crazy here the last few days...

Thanks, I used your keyword's search and found a few things to try, but still having a little trouble. I modified the Google search
a bit and found an example of someone trying to list ALL tables where they have column names with a certain string. Which is
pretty close to what I'm trying, but I'm just looking to search within one Table and not the whole DB.

This is the example I found. It lists all Tables and their column names that are LIKE "%string%". So how can I modify this to
search only within one Table instead of the whole DB. I only know the very basics of DB Querying so I'm not really sure...
Code:
SELECT c.name AS ColName, t.name AS TableName 
FROM sys.columns c 
    JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name like '%email%'

So that gives me a list of Column Names containing the string "email" and their corresponding TableName they are in... Any
idea how I can modify it to display just one Table and list column names and their data where the colname contains the string "email"..?

Any suggestions would be much appreciated!

EDIT:
After playing a bit with the given SQL Query above, I was able to add the part below in blue to include ONLY the table I want, but I'm still
trying to figure out how to include the data for those columns as well...
Quote:
SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name like '%email%' AND t.name = 'Table_Name_I_Want'
Thanks Again,
Matt

Last edited by mrm5102; 12-11-2013 at 12:44 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

How to select only those file names whose name contains only numbers

Hi Guru's, Before writing to this forum I have searched extensively on this forum about my problem. I have to write a shell script which takes out only those file names from the given directory which contains only numbers. For example, In the given directory these files are present: ... (4 Replies)
Discussion started by: spranm
4 Replies

2. UNIX for Dummies Questions & Answers

replacing string in a column on a specific line

hi, i currently have a file with columns similar to this customer name owed CID123 John 300 CID342 harry 500 at present i use use awk to find the amount owed by the customer using the customer ID (CID). if the customer spends more money how would i go about using sed/awk etc to... (2 Replies)
Discussion started by: skinnygav
2 Replies

3. UNIX for Dummies Questions & Answers

How to remove a string from a specific column in a file

Hello, A basic query. How can I remove a string from a specific column. For example, remove "abcd" just from column 2 in example file: abcd abcd1 abcd abcd2 abcd abcd3 to get output: abcd 1 abcd 2 abcd 3 Thank you!:) (4 Replies)
Discussion started by: auburn
4 Replies

4. Shell Programming and Scripting

Select a specific part of the string and print it

Hi all, I have a string that looks like: #!/bin/sh options="arguments: --user=alpha --group=beta --prefix=/usr/share --proxy-path=/proxy --proxy-tmp=/tmp --conf-path=/etc" My goal is to transform the string into an array, then for each key, if it starts with "--proxy" to print the string... (2 Replies)
Discussion started by: TECK
2 Replies

5. Shell Programming and Scripting

Print unique names in each row of a specific column using awk

Is it possible to remove redundant names in the 4th column? input cqWE 100 200 singapore;singapore AZO 300 400 brazil;america;germany;ireland;germany .... .... output cqWE 100 200 singapore AZO 300 400 brazil;america;germany;ireland (4 Replies)
Discussion started by: quincyjones
4 Replies

6. Shell Programming and Scripting

Print unique names in a specific column using awk

Is it possible to modify file like this. 1. Remove all the duplicate names in a define column i.e 4th col 2. Count the no.of unique names separated by ";" and print as a 5th col thanx in advance!! Q input c1 30 3 Eh2 c10 96 3 Frp c41 396 3 Ua5;Lop;Kol;Kol c62 2 30 Fmp;Fmp;Fmp ... (5 Replies)
Discussion started by: quincyjones
5 Replies

7. Shell Programming and Scripting

Delete column with exact string in specific col

Hi, my file structur looks like File structure looks: GeneID protein_gi Symbol 1246500 10954455 repA1 1246501 10954457 repA2 1246502 10954458 leuA But some of the cases do not have record for protein id. for example: 1343044 - orf01 I want to remove those rows. But I tried awk... (9 Replies)
Discussion started by: smitra
9 Replies

8. Shell Programming and Scripting

Replace specific column range in a non-delimited file with a string!

Hi All, I will need an help with respect to replacing a range of columns on a non-delimited file using a particular string pattern. Say file input is MYNUMBERD000000-BAN CHUE INSNTS ** N+ MYAREDSDD000000+BAN CHUE INSNTS ** N+ MYDERFFFSD00000-GIR PENT - ACH ** ... (5 Replies)
Discussion started by: navojit dutta
5 Replies

9. Shell Programming and Scripting

Overwrite specific column in xml file with the specific column from adjacent line

I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file. Here is the file. <!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies

10. Shell Programming and Scripting

Change some string in specific column with space

Hello All of Master Script , i need help to solve my problem before : mount /dev/rdsk/c1t69d0s6 /dev/rdsk/c1t69d0s6 /vol/cl123/PURGE1 ufs mount /dev/rdsk/c1t70d0s6 /dev/rdsk/c1t70d0s6 /vol/cl123/PURGE2 ufs expected : mount /dev/dsk/c1t69d0s6 /dev/rdsk/c1t69d0s6 /PURGE1 ufs mount ... (3 Replies)
Discussion started by: k0p0nkkk
3 Replies
Object::ID(3pm) 					User Contributed Perl Documentation					   Object::ID(3pm)

NAME
Object::ID - A unique identifier for any object SYNOPSIS
package My::Object; # Imports the object_id method use Object::ID; DESCRIPTION
This is a unique identifier for any object, regardless of its type, structure or contents. Its features are: * Works on ANY object of any type * Does not modify the object in any way * Does not change with the object's contents * Is O(1) to calculate (ie. doesn't matter how big the object is) * The id is unique for the life of the process * The id is always a true value USAGE
Object::ID is a role, rather than inheriting its methods they are imported into your class. To make your class use Object::ID, simply "use Object::ID" in your class. package My::Class; use Object::ID; Then write your class however you want. METHODS
The following methods are made available to your class. object_id my $id = $object->object_id; Returns an identifier unique to the $object. The identifier is not related to the content of the object. It is only unique for the life of the process. There is no guarantee as to the format of the identifier from version to version. For example: my $obj = My::Class->new; my $copy = $obj; # This is true, $obj and $copy refer to the same object $obj->object_id eq $copy->object_id; my $obj2 = My::Class->new; # This is false, $obj and $obj2 are different objects. $obj->object_id eq $obj2->object_id; use Clone; my $clone = clone($obj); # This is false, even though they contain the same data. $obj->object_id eq $clone->object_id; object_uuid my $uuid = $object->object_uuid Like "$object->object_id" but returns a UUID unique to the $object. Only works if Data::UUID is installed. See Data::UUID for more details about UUID. FAQ
Why not just use the object's reference? References are not unique over the life of a process. Perl will reuse references of destroyed objects, as demonstrated by this code snippet: { package Foo; sub new { my $class = shift; my $string = shift; return bless {}, $class; } } for(1..3) { my $obj = Foo->new; print "Object's reference is $obj "; } This will print, for example, "Object's reference is Foo=HASH(0x803704)" three times. How much memory does it use? Very little. Object::ID stores the ID and address of each object you've asked the ID of. Once the object has been destroyed it no longer stores it. In other words, you only pay for what you use. When you're done with it, you don't pay for it any more. LICENSE
Copyright 2010, Michael G Schwern <schwern@pobox.com>. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See <http://www.perl.com/perl/misc/Artistic.html> THANKS
Thank you to Vincent Pit for coming up with the implementation. perl v5.12.4 2011-09-26 Object::ID(3pm)
All times are GMT -4. The time now is 06:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy