.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

remove pattern from string as seperate column

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
Hey  Everyone This seems like it shouldn't be too difficult but I'm strapped for time- I have a column where the data looks like CN=kmcde,OU=People,DC=ad,DC=FLA,DC=edu I want to pull out the 'kmcde' as a new column. I'm thinking some combination of substring and perhaps patindex but can't get it to work correctly Thanks kam

View Complete Post

More Related Resource Links

Remove characters in a string


i have a string like this   sravani/, asdfff/, lsdsf/
i want to remove last character '/'  in the above string...
which function can i use?

pls help me....

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

Remove japnese / russian words in a String

Hi, I"m currently writing a ASP.NET MVC application in which I search twitter for new tweets. When however I use the language filter I still get some messages in japanese or russian. I tried using a Regular expression: [^\x20-\x7E\wáéíóäëiöúàêèììçù… ] which should tell me when a string contains japanese/NON ASCII characters. At least that's the output I get when I try checking this regex with a JavaScript function. This is my code: ----------- Regex languagesReg = new Regex(@"[^\x20-\x7E\wáéíóäëiöúàêèììçù… ]"); lstEntries.RemoveAll(e => languagesReg.IsMatch(e.Content)); -----------           Does anyone know why I get the right output with JavaScript functions and the wrong output in .NET? Or maybe someone might be able to help me find an other workaround? Thanks in advance Kasper

Search - How to remove a meta tag ... / custom column is not showing up in Crawled Properties after

Hi I got the following warning after I crawled a site. Info out of Crawl Log: "The content for this address was excluded by the crawler because this item was marked with a no-index meta-tag. To index this item, remove the meta-tag and recrawl." Sound easy but I don't no where I could do it. The other problem is that I try to get a custom column from a custom list showing up in the crawle properties. I am using also a custom scope with the behavior "INCLUDE" ... In MOSS 2007 it was a lot simpler ;-) Thanks Regards MIA    

How to filter managed meta data column using page query string?

I have two managed term sets as follows: Articles:Downloads Projects:Downloads I am trying to use a content query web part to filter a list based on the above manged meta data column. I want to filter out only "Articles:Downloads" Scenario 1: When I edit the web part and directly set the filter option with the managed meta data column to "Articles:Downloads" it works fine. When I export the web part, in the .webpart file, the "FilterValue1" property has a value "Downloads|9096e43b-555d-4879-9acc-b4ada9ea9910". Scenario 2: I want the web part to get the filter information from query string [PageQueryString:pageType]. So I tried using these options: a) pageType=Downloads      This works but returns downloads under 'projects' as well. (i want downloads only under 'articles')  b) pageType=Articles:Downloads     Does not work and shows no records c) pageType = Downloads|9096e43b-555d-4879-9acc-b4ada9ea9910     Does not work. (This value is the same as one found in 'FilterValue1' of the static web part). c) pageType = Articles:Downloads|9096e43b-555d-4879-9acc-b4ada9ea9910     Does not work. d) pageType = 9096e43b-555d-4879-9acc-b4ada9ea9910     Does not work.   What am I missing here? Can some one please help?

"String Concatenation": Not appear result Or 'Null v alue' if any column contain Null null value

I write This statement to display FullName of Person SELECT CardID,( FirstName + ':' + FatherName + ':' + GrandFatherName + ':' + FamilyName) as name from PersonalData but I found he dispalay null value if any part of any columns Concatenation contain null value what the exception to make them "solution"

Caml returns table with column, whose value is empty string always, but it's not

I wrote caml query   SPSiteDataQuery query = new SPSiteDataQuery(); query.ViewFields = @"<FieldRef Name='Title' /><FieldRef Name='cmAssignedTo' Nullable='TRUE' />" + "<FieldRef Name='cmDueDate' Nullable='TRUE' /><FieldRef Name='Author' /><FieldRef Name='cmStatus' />" + "<FieldRef Name='cmControler' Nullable='TRUE' /><FieldRef Name='cmControlers' Nullable='TRUE' />" + "<FieldRef Name='FileDirRef' /><FieldRef Name='File_x0020_Type' /><FieldRef Name='cmIcon' /><FieldRef Name='cmPackageGuid' />" ; query.Webs = string .Format("<Webs Scope='{0}' />" , searchScope); query.Lists = "<Lists ServerTemplate='10553'/>" ; Fields cmAssignedTo, cmControler and cmControles return always "", but they include users! Definition of these fields is similar:   <Field xmlns="http://schemas.microsoft.com/sharepoint/" DisplayName="cmAssignedTo" StaticName="cmAssignedTo" Name="cmAssignedTo" ID="{B4B52176-1961-4b06-B7B4-C7DBB751A53F}" Type="User" List="UserInfo" ShowField="ImnName" Mult="TRUE" />   List, where i'm looking for in, includes 2 contenttypes. First one contains these

SharePoint Dataview Insert New Mode - Defaulting a Required Column to a Query String Parameter Valu

I've got a SharePoint DataView with an insert button. there is a required lookup column I want to default to the value of Querystring Value during new mode.  Can I do this in the generated code below? I tried replacing @ApplicantId with @QSApplicantID.. and  tried string(@QSApplicantID) too.. no luck gave me an error: The data source control failed to execute the insert command. Could it be that QSApplicantID (which I've used in my DataView Datasource filter with no problem) is not available during the insert? I think I can do what I want in Javascript but was hoping I could instead right in the XSL markup. *my query string parameter**     ParameterBinding Name="QSApplicantID" Location="QueryString(ID)" DefaultValue="2222222"/ **the new form** SharePoint:FormField runat="server" id="ff4{$Pos}" ControlMode="New" FieldName="ApplicantId" __designer:bind="{ddwrt:DataBind('i',concat('ff4',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@ApplicantId')}" / **the link** a href="javascript: {ddwrt:GenFireServerEvent('__cancel;dvt_1_form_insertmode={1}')}">Insert</a Thanks for any help or information!

How do I remove column headers in list view webpart?

I'd like to remove the column headers from a list view web part, as well as from a document library web part. How can I accomplish this in SharePoint 2010?

Lookup Column Data on seperate Subsite


Is there a way to make a look up reference a column on a seperate subsite?  I was thinking I could do it with BCS but I seem to be having an issue setting up a MOSS 2010 list as a source.

Basically I have SubSiteA with a list that includes some catalog information for systems and SubSiteB is a Doc Center that contains various atricles about the systems. I want to have one column in SubSiteB reference a Column from SubSiteA to use as metadata for search/filter purposes.


Any thoughts?  Thanks

Enterprise Applications Specialist

String column Comparision


Hello All,

I am new to SQL. So please bare with me.

I have two tables say TABLE A( city varchar(100), clean_city varchar(100),country varchar(100))

INSERT TableA (city, country)
VALUES ('London','United Kingdom),
('Ecblondontsr','United Kingdom),
('sdclondon','United Kingdom'),
('londontres','United Kingdom'),
('thichicago','united States'),
('chicago','United States')
('3450 Mumbai','India')

Table B (Input_city varchar(100),output_country varchar(100), city_country varchar(100))

VALUES ('LONDON','London','United Kingdom'),
('CITYOFLONDON','London',United Kingdom'),
('CHICAGO','Chicago','United States'),

I want to search if city in Table A exists in input_city of tableB. If exists to set clean_city with output_city.

Is there a way I can acheive this with out using sql joins.

Any help is highly appreciated.




Best Method to remove special character from string

I am trying to remove the special characters from a string that was entered by the user.  I am not sure the best method to do this.  i can get a foreach of all the characters but what do i check it against?
Christian - developer

best way to remove (or hide) a gridview column in a custom page


can someone tell what the best way to remove (or hide) a gridview column is within a custom page?

I dont want to show the link column that is automatically generated as a result of the relationship between the table in question and a parent table.



How to remove all xmlIns from this xml string



I have a string which is XML. I have to remove all the XML namespaces from this string. That is creating lots of problems while updating XML element values.

Here is my XML. Now out of this XML, I want to remove all the xmlIns, xmlIns:xsi and xmlIns:xsd, I mean all the XML Namespaces.

Can someone provide C# code to do this please?


<?xml version="1.0" encoding="utf-16"?>
<ServerInfo xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <GenerationDate xmlns="http://www.MYSITE.com/WebServices">10/5/2010 12:53:13 PM</GenerationDate>
  <Customer xmlns="http://www.MYSITE.com/WebServices">
    <ContactAddress>200 Cottontail Ln
Somerset, NJ 08873</ContactAddress>
    <Notes />
    <Organization>Ventiv Health</Organization>
  <LAServerHistory xmlns="http://www.MYSITE.com/WebServices">
    <Notes>9/2/09 SO 41233
9/8/09 SO 41369
9/25/09 TL loaner
7/23/10 FR/Convert to perm</Notes>

Column Name - cannot convert between unicode & nonunicode string data types



Im using the OLEDB Source to connect the source columns. But its throwing an error msg Column Name - cannot convert between unicode & nonunicode string data types. Could you please provide me the oracle code so that I can use with the select statement. For some of the schemas I have chaged the data types using the derived column before the OLEDB destination.

Actually, one of my team member suggested me to use the Oracle char(2) in the select statement. Can any one help me with the code so that I can use it for the rest of the columns.

Eg source(External Column) - CreatedBYID - DT_wstr(18)

Source - Output cloumn - CreatedById - DTStr(18)



Remove column from Listview


I'm binding a listview control to LinqDataSource and can't find a way to remove unnecessary columns.

How to remove auto generated right blank column from the wpf datagrid?


i have already use this.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend