|
I wanted to ask if i can do an interface in excel where i can enter a value from the table and return another value that coresponds! Is it possible?
Help!
|
|
|
|
|
You can! Did you want to get a value from your worksheet and perform a calculation on it? Or is this a value from and external table? Please give more details.
Ken
|
|
|
|
|
to convert I build shamsi.OCX
connect me to send;)
|
|
|
|
|
Dude - none of this makes any sense. Please try to explain what you want, because no-one is going to know how to answer this.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Formula
1. Subract 621 from Milady year 2005 - 621 = 1384 (x)
2. Divede x to 33 1384 : 33 = 41.939 (=42)
3. Add division result to x 1384 + 42 = 1426
Protected Function ConvertMiladyToHicry(ByVal Year As Integer) As Integer<br />
Return Year - 621 + Math.Round(Year - 621 / 33)<br />
End Function
|
|
|
|
|
Hi there,
i have a database which contain some junk character in some fields like for ex:"è" i need to replace this junk character into "è" the application where iam using this database is ASP page and need to have a solution where at one shot i can replace all this junk charac in my database fields there are around 7 different junk character in 5 fields and i have 500 records like this in my database
i try to solve this problem with the javascript but i need a connection so that in one click i can loop thro all the fields and replace the character but cant do it here is the code snippet :
sqlqry=""
set rstest=server.CreateObject("ADODB.Recordset")
sqlqry = "select Title, Description, Description_abtract, Dc_source, Rights_Rightsholder from Articles_production"
rstest.Open sqlqry,conn,3,3
var str= sqlqry
(str.replace(/è/gi,"è"))
(str.replace(/é/gi,"é"))
(str.replace(/’/gi,"’"))
(str.replace(/“/gi,"“"))
(str.replace(/â€/gi,"”"))
(str.replace(/ç/gi,"ç"))
(str.replace(/ä/gi,"ä"))
pls any solutions
regards
cyus
|
|
|
|
|
You could (should be able to depending on the database u r using?) do the entire thing at the database level, below is a mssql example -
update Articles_production set Description = replace(Description,'junk character','replacement character'), Description_abtract = ....
You may however have to run the update statement for each junk character.
|
|
|
|
|
Hi jeffrey,
i try the above qury in my query Analyzer it show me error:
argument data type ntext is invalid for argument 1 of replace function.
To support unicode character i created datatype as ntext.
Regards
cyus
|
|
|
|
|
if you know that the data in the columns doesn't exceed a length of 8000 you could try something like - update Table1 set test1=replace(convert(varchar(8000),test1),'x','a'),
test2=replace(convert(varchar(80000),test2),'x','a')
Otherwise you might have to go the code route.
|
|
|
|
|
hey Jeffery,
i try this in my code but some problem in the updated stmt can u help me shoot wht the problem is the compiler thro me error The name Var1 does not exist in the class or namespace of the project....
here is the codesnippet
string strsql;
DataTable dt;
SqlDataAdapter da;
SqlConnection objConn = new SqlConnection("data source=yusuff;user id=sa;password=sa;initial catalog=Heritage");
dt = new DataTable();
strsql = "select * from Articles_production";
da = new SqlDataAdapter(strsql,objConn);
da.Fill(dt);
if(dt.Rows.Count > 0)
{
//foreach (DataRow dr in dt.Rows) //ervy loop
for (int i=0;i
|
|
|
|
|
Hi there,
i have a database which contain some junk character in some fields like for ex:"è" i need to replace this junk character into "è" the application where iam using this database is ASP page and need to have a solution where at one shot i can replace all this junk charac in my database fields there are around 7 different junk character in 5 fields and i have 500 records like this in my database
pls any solutions
regards
cyus
|
|
|
|
|
I am having problems with using an array to put info into a stack, I have to use parenthesis and put them in a stack and see if the string has equal parenthesis and i can come up with a code to just get the "(" out of a string
|
|
|
|
|
I don't understand the question. Perhaps if you post some code ? The replace method on a string can replace a ( with an empty string if that's what you need, or you could use regex if you wanted to.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
THIS IS THE PROBLEM:Use a stack to check whether a programming statement or a fuormula has a balanced parentheses. It checsk the number of parentheses in the expression and highlights a parenthesis that is unbalanced
|
|
|
|
|
Oh, I see. Have you written any code for your homework assignment yet ? If so, post it and I'll be glad to help. Otherwise, I won't do your homework for you.
Do you know what a stack is ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
For intI = 0 To StrExample.Length - 1
If (Char.IsPunctuation(StrExample.Chars(intI))) Then
stkReverseCheck.Push(StrExample.Chars(intI))
lstReverse.Items.Add(stkReverseCheck.Peek)
End If
Next
End Sub
I wanted it to check to see if it was an "(", "{" "[" and push it into the stack and when it came to a ")" "}" "]" put it into another stack and evaluate it the two stacks
|
|
|
|
|
There's no Char function for brackets, and because ( doesn't match } or ], you'd do better to build three stacks, one for each type of brackets. You could then pull them off for closing brackets from the right, and whatever is left on the stack, does not match anything to close it.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
i cant figure out how to work that with the string, when the array breaks it down what do i need to do for it to examine what it broke down to decide what stack to put it in
I tried if intI = ")", ect.... but it gave me a cant do it because Double error
|
|
|
|
|
You need to use single quotes to compare a char to a char, at least in C# you do.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
well single quotes in VB comment things out, and I cant see to figure it out
|
|
|
|
|
Something like this ? OR perhaps for each would work as nicely, and read better ?
Sub Main()
Dim s As String = "this (is )a ((test), sucka)"
Dim i As Int16
For i = 0 To s.Length
If s.Chars(i) = "(" Then
' push onto stack
End If
Next
End Sub
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
THanks, I am trying to figure it out
|
|
|
|
|
Glad to help. A lot of people post homework questions here, I have no time for them. However, people like you, who are trying to work it out for themselves and just need a little help, I'm always keen to help out.
Good luck.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Maybe you already figured it out, but a char in vb is something like
Dim c as Char = "("c
Pompiedompiedom... 
"..Commit yourself to quality from day one..it's better to do nothing at all than to do something badly.."
-- Mark McCormick
|
|
|
|
|
A good reference for parsing code (or whatever) is in Compilers, Principles techniques and Tools (aka The Dragon Book) by Aho, Sethi and Ullman, c. 198x?
...Steve
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
