I need to split the words from random character displayed.For example character like
Textbox1--Textbox2, the mention character have to be split up only by the ('--') and both the characterslike("Textbox1","Textbox2") have to be display in corresponding textboxs.
I create a table as picture below :
when I insert any character to column Name then A new string random will auto insert into column Random (picture below) I had used Trigger but It was error !
I want to column Random use to code :
DECLARE @myid uniqueidentifier
SET @myid = NEWID()
insert into table_1 values(@myid, substring(CONVERT(varchar(255), @myid), 1, 5))
but It must auto like column Number (column Number is Identity)
I displayed some words in text box.. The words are,
performcontextEmpRecordhostcontextEmpRefertlcontextEmpdatadatascontextEmpofficemain
contextEmppersonalhardwarecontextEmpsalaryhighcontextEmptype
Now, I want to store these words into database table using asp.net with c#..
each word should be stored into new row..(i.e words spilit into space)..
How should I split a string separated by a multi-character delimiter in VB?
i.e. If my string is say - Elephant##Monkey, How do I split it with "##" ?
How can I generate a 7-digit random number and special character string in a textbox on a button click event, in VB.Net?
View 2 RepliesI have a pretty basic search feature on a site that queries a sqldb with a sqldarasource, and then displays the results on a page, in a panel within a Repeater. I'd like to figure out if it's possible to somehow highlight the words the user searched on as they are displayed in the search results. The code below is my repeater. Do you know of any way to manipulate the Title or Description if the words in it's body match the words searched?
<asp:Panel
ID="pnlExperience"
runat="server"
Height="500px"
ScrollBars="Auto">
[code]...
I need to pull a SubString from a Linq Datasource, but can't use INTs per .SubString(int, int) I have strings such as xxxx.xxxx.xxxxx.AAAA.xxxx.xxxx.xxxx.xxx and I need to pull AAAA out. the preceeding x's will be varying lengths, so I can't use a static int. What I do know is that there will be a static number of periods (.) leading up to the AAAA. I can't figure out how to use the SubSting with characters rather than indexs. This is what I have so far:
[Code]....
My issue is that , need to change the column name(following format "Remove first character and after 3rd character insert colon") of the gridview (which is binded with XMLTextReader). Without changing directly XML file, Required to change the column name dynamically at runtime .
Performance.xml
<Performance>
<Departments>
<Heading>FS</Heading>
<S0015>1</S0015>
<S0020>2</S0020>
<S0025>5</S0025>
<S0030>5</S0030>
<S0035>6</S0035>
</Departments>
<Departments>
<Heading>BS</Heading>
<S0015>0</S0015>
<S0020>3</S0020>
<S0025>5</S0025>
<S0030>1</S0030>
<S0035>3</S0035>
</Departments>
</Performance>
Heading S0015 S0020 S0025 S0030 S0035
FS 1 2 4 5 6
BS 0 3 5 1 3
Required Format: Remove first character and after 3rd character insert colon (S0015 -- 00:15)
Heading 00:15 00:20 00:25 00:30 00:35
FS 1 2 4 5 6
BS 0 3 5 1 3
Norwegian character( å æ ø) does not show instead showing some strange character.
used function below:
utf8 = System.Text.Encoding::get_UTF8();
I want to display first 200 characters of the content put into database from an html editor.I am not able to use substring since the ocntent contains html tags .If I take the plain text, I will loose all the formatting and font styles.
View 13 RepliesHow to extract specific portion of a string using substring? I have strings
100 - abc - jewellery
20 - def - stationary
I only want the portion between to dashes. (abc,def)
Problem in YUI:I am using YUI grid,my dataset contains some special character.i bind my dataset into the grid,but its not displayed in my grid? how to solve this
View 1 RepliesI want to find a substring (email) in a large text using Regex.
just want to return the first valid email that is found from the input text:
example:
string inputString = "Our email is myname@ourcompany.com.
desired output: myname@ourcompany.com
this is the Regex pattern i've used: ^[A-Z0-9._%+-]+@[A-Z0-9.-]+.[A-Z]{2,4}$
- is this pattern correct?
Code:
private static void DumpHRefs(string inputString)
{
Match m;
string HRefPattern = @"^[A-Z0-9._%+-]+@[A-Z0-9.-]+.[A-Z]{2,4}$";
m = Regex.Match(inputString, HRefPattern,
RegexOptions.IgnoreCase | RegexOptions.Compiled);
while (m.Success)
{
Console.WriteLine("Found email " + m.Groups[1] + " at ".......
I have a gridview that has a field called TargetDate which is formatted as dd/mm/yyyy. I want to substring the numbers out of the date. So basically remove the '/'. How do I do that? can't just substring(0,2) because sometimes the date is single digits, sometimes 2 digits. I am using vb.net.
View 2 RepliesI looked up the msdn documentation and it says that InvalidUserName is thrown when it does not find the username in the database, which is fine because the user I am creating should not exist in the database. If I use test@example.com, it works, but if I try it with test.@example.com, the status from Membership.CreateUser is InvalidUserName.
View 1 RepliesHow to read character by character in line from text file?
View 1 RepliesI have a legacy MySQL database which stores the user passwords & salts for a membership system. Both of these values have been hashed using the Ruby framework - roughly like this:
hashedsalt =
Digest::SHA1.hexdigest("--#{Time.now.to_s}--#{login}--")
hashedpassword =
Digest::SHA1.hexdigest("#{hashedsalt}:#{password}")
So both values are stored as 40-character strings (varchar(40)) in MySQL. Now I need to import all of these users into the ASP.NET membership framework for a new web site, which uses a SQL Server database. It is my understanding that the the way I have ASP.NET membership configured, the user passwords and salts are also stored in the membership database (in table aspnet_Membership) as SHA1 hashes, which are then Base64 encoded (see here for details) and stored as nvarchar(128) data.
But from the length of the Base64 encoded strings that are stored (28 characters) it seems that the SHA1 hashes that ASP.NET membership generates are only 20 characters long, rather than 40. From some other reading I have been doing I am thinking this has to do with the number of bits per character/character set/encoding or something related.
So is there some way to convert the 40-character SHA1 hashes to 20-character hashes which I can then transfer to the new ASP.NET membership data table? I'm pretty familiar with ASP.NET membership by now but I feel like I'm just missing this one piece. However, it may also be known that SHA1 in Ruby and SHA1 in .NET are incompatible, so I'm fighting a losing battle.
I've got a Varchar2 field in my table which I want to convert to a CLOB. I am unsure whether the data would get truncated when selected. If so, what is the limit and does it depend on the database settings?
In my TOAD or SQLPLUS window it gets truncated but this may just be the environment settings. I'm not sure whether it would get truncated in my actual application (I can test this, but up to what size should I test?)
If it does get truncated, what's the best way to display the whole CLOB? There are other fields in my SELECT query, so I think I can't just loop through multiple rows. Is there any way out?
The following is a line of huge .txt file and i am reading it line by line. I need the value of second column. In this line, I need to extract 'C9006'.
Mr ABC|C9006|The white field,
ON|493-493-4939|493-493-4939|YR|Inactive
Note : The delimiter char is pipe sign '|'. The length of second column is not consistent.
Need to substring value from DropDownList from position 1 till I reach the first blank character
Example: 'RGWP - West Palm' would be 'RGWP' and 'SBGB3 - Greensboro' would be 'SBGB3'
mid(DropDownList1.Value, 1, ?)
I am binding some data to control, but want to limit the number of character of a specific field to a 30 first characters. I want to do it, if it's possible, on aspx page.
I tried this:
Text='<%# String.Format("{0}", Eval("Title")).Substring(0,30) %> '
But got this error: Index and length must refer to a location within the string. Parameter name: length
I am trying to use substring in c# code.
This is the code i have used:
[Code].... I am getting the error as: "Length cannot be less than zero.
Parameter name: length"} System.Exception {System.ArgumentOutOfRangeException".
I want to get the result 123421, that is after the "\".
I want to read a line character by character, in the sense I want to read each and every character on the line. can I can make that line as a string. breaking string into substrings ? if possiblw how.? I m unable to start. can anyone give the code.
View 7 Repliesi take the text of the html of a site and want to select a substring of the whole text. the text is something like this
[Code]....
Code:
01.If InStr( Request.ServerVariables("HTTP_REFERER"), "google") > 0 Then
KeyURL = Request.ServerVariables("HTTP_REFERER")
' Remove all up to q=
KeyLen = Len(KeyURL)
kStart = InStr( KeyURL, "q=" )
kStart = kStart + 1
KeyRight = KeyLen - kStart
Keyword = Right( keyURL, KeyRight )
[code]...
