|
Why would you use a regex for this? Why not just use a substring? How is it supposed to act for strings that aren't 6 characters exactly?
|
|
|
|
|
Actual goal is to split fixed-width string that consists of multiple fields (dozens of them). Fields are not delimited by any separator but defined by their positions in the string - first field occupies first 4 characters, second - next 2 characters, etc. Using regex allows to do this with one function call. As you can see I almost achieved what I am looking for - I just want to get rid of first and last string in the array that are empty. Yes, I can just ignore them in my code but I would like to know correct regex expression.
|
|
|
|
|
Will this serve your purpose?
string strSource = "abcdef";
string[] w = new string[] { strSource.Substring(0, 4), strSource.Substring(4) };
|
|
|
|
|
You should use Regex.Matches instead of Regex.Split. For example, take this input string:
11112233
When you apply this regex:
(?<first>.{4})(?=.{4})|(?<=.{4})(?<middle>.{2})(?=.{2})|(?<=.{6})(?<last>.{2})
You will get three results:
111
22
33
Note the regex has three sections, each separated by a pipe (|), which means "or". The first part:
(?<first>.{4})(?=.{4})
Finds any 4 characters that are followed by 4 characters. The middle part:
(?<=.{4})(?<middle>.{2})(?=.{2})
Finds any 2 characters that have 4 characters before them and 2 characters after them. The last part:
(?<=.{6})(?<last>.{2})
Finds any 2 characters that have 6 characters before them.
So, for the first match, you pad the end. For the middle matches, you pad the beginning and end. And for the last match, you pad the beginning. Not sure why you'd want to do this, but that's how it would be done. Performance may or may not be an issue... you'll have to test it with large strings. Also, if you use the regular expression more than once, make sure you use the compiled version (you can indicate a regex is compiled in the Regex constructor). Also, if you really are going to used groups, you could simplify the regex quite a bit:
(?<first>.{4})(?<middle>.{2})(?<last>.{2})
Then you can just get the sections by their group name (one match will be produced, but many groups will be in that match). And if you want to ignore certain sections of the string, you can do that too:
(?<first>.{4})(?<middle>.{2})(?<ignore>.{2})(?<last>.{2})(?<ignore>.{2})
Try that with this input string:
111122334455
And if you really want to use Regex.Split for some reason, something like this might work for the example you gave:
(?<=.{4})(?=.{2})
|
|
|
|
|
Thanks, just what I was looking for
|
|
|
|
|
Good Day
I have the following code
<br />
String XMLString = Convert_To_XML(Search);<br />
StringReader xmlSR = new StringReader(XMLString);<br />
xmlDatadoc.DataSet.WriteXml(XMLString);<br />
dsFinal = xmlDatadoc.DataSet;<br />
dsFinal.ReadXml(xmlSR);<br />
DataView dvSubjects = dsFinal.Tables[0].DefaultView;
when i run it , i get
Illegal characters in path.
it looks for a path and i am using an xml string, how to i add an xml from a string variable to a dataset
Thanks
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Vuyiswa Maseko wrote: when i run it , i get
Illegal characters in path.
On which statement do you get this message, and what are the contents of the variables (strings) that the statement is operating on?
It's time for a new signature.
|
|
|
|
|
Good Day Richard
This is the line
<br />
xmlDatadoc.DataSet.WriteXml(XMLString);
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
MSDN[^]
"DataSet.WriteXml Method (String)
Writes the current data for the DataSet to the specified file.
"
In other words, it's expecting a filename, not an XML string.
DaveIf this helped, please vote & accept answer!
Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|
|
Hi,
Am developing a winforms app using C#.
I am using binding source to design the forms.
I have a combobox with items "Yes" and "No"
depending on the selection of this I enable or disable a text box.
private void MyComboBox_TextChanged(object sender, EventArgs e)
{
if(MyComboBox.Text == "Yes")
{
textBox1.Enabled = true;
}
else
{
textox1.Text = "";
textbox1.Enabled = false;
}
}
Lets say I have selected "Yes" from the combobox and entered text into the textbox1 and save the input on save_click.
the value gets stored into the database.
Now if I go back to the form and edit it....I now change the combox to "NO". It clears the text in the textbox1 to "". When i click on save...it saves the record.
But the problem is that it is not updating it into the database.?
Any idea why this is happening or do i need to include more code into the event.
Help Appreciated..thanks,
|
|
|
|
|
You should be using the selected item changed event and not the Text Changed event. Also change your combo box to be of type DropDownList.
|
|
|
|
|
Can you tell me how to update the database when the binding source is modified please?
In this case the textBox text is being modified and I want to know how the selected item changed (i think ur trying to say SelectedIndexChanged event ?)
and changing the property of the combobox to dropdownlist would solve this issue?
Thanks,
|
|
|
|
|
Good morning.
Using Visual Studio 2008 (C# - Excel 2007 Add-in) I created a Excel 2007 Ribbon tab named Macros. It contains several buttons. I got some sample code online, but I can seem to run the macros. I have the following:
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Office.Tools.Ribbon;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;
using Microsoft.Office.Core;
private void btnImport_Click(object sender, RibbonControlEventArgs e)
{
object oMissing = System.Reflection.Missing.Value;
Excel.ApplicationClass oExcel = new Excel.ApplicationClass();
oExcel.Visible = true;
Excel.Workbooks oBooks = oExcel.Workbooks;
Excel._Workbook oBook = null;
oBook = oBooks.Open("c:\\Book1.xlsx", oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
RunMacro(oExcel, new Object[] { "Import" });
}
private void RunMacro(object oApp, object[] oRunArgs)
{
oApp.GetType().InvokeMember("Run",
System.Reflection.BindingFlags.Default |
System.Reflection.BindingFlags.InvokeMethod,
null, oApp, oRunArgs);
}
Any idea what might be an issue with the code? WHEELS
|
|
|
|
|
Update - I have the following:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Office.Tools.Ribbon;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;
using Microsoft.Office.Core;
using System.Windows.Forms;
namespace ExcelAddInCustomTab
{
public partial class RibbonCustom : OfficeRibbon
{
public RibbonCustom()
{
InitializeComponent();
}
private void btnFileImport_Click(object sender, RibbonControlEventArgs e)
{
Excel.ApplicationClass oExcel = new Excel.ApplicationClass();
RunMacro(oExcel, new Object[] { "FileImport" });
}
private void RunMacro(object oApp, object[] oRunArgs)
{
try
{
oApp.GetType().InvokeMember("Run",
System.Reflection.BindingFlags.Default |
System.Reflection.BindingFlags.InvokeMethod,
null, oApp, oRunArgs);
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException.Message);
}
}
}
}
In the Excel 2007 spreadsheet, the Import tab shows up with the several buttons I set up. I am getting the following error: The macro may not be available in this workbook, or all macros may be disabled.
I checked all the trusted location and permission settings, and the add-in and macros are not disabled.
WHEELS
|
|
|
|
|
Hi Guys,
I am having troyble with a SQL query. When I run the same query in SQL Server management studio it works fine. When I try and pass it through C# string I get an error. I know it has to do with the sum(HoursWorked) portion of the query. What I want to do is the following. This is from SQL Server management studio:
SELECT TSPRojectCodeID, EmployeeID, sum(HoursWorked) AS "Total Hours"
FROM tblTimesheetDetails
WHERE TimeSheetDate >= '2010/07/01' AND TimeSheetDate <= '2010/07/30'
GROUP BY TSProjectCodeID, EmployeeID;
When I try and pass the same query in C# i get and error that reads as follows:"The Select statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."
The code used is as follows:
public string processSQL()
{
string sql = null;
string inSql = null;
string firstPart = null;
string lastPart = null;
int selectStart = 0;
int fromStart = 0;
string[] fields = null;
string[] sep = { "," };
int i = 0;
TextObject MyText;
string startdate = fromDate.Value.ToString("yyyy/MM/dd");
string todate = toDate.Value.ToString("yyyy/MM/dd");
inSql = @" Select DISTINCT TSProjectCodeID, EmployeeID, SUM(HoursWorked) AS 'Total_Hours', FROM tblTimesheetDetails WHERE TimeSheetDate >= '" + startdate + "' AND TimeSheetDate <= '" + todate + "' AND TSProjectCodeID = '" + cmbprojects.Text.ToString() + "'ORDER BY TSProjectCodeID, EmployeeID, HoursWorked";
inSql = inSql.ToUpper();
selectStart = inSql.IndexOf("SELECT");
fromStart = inSql.IndexOf("FROM");
selectStart = selectStart + 15;
firstPart = inSql.Substring(selectStart, (fromStart - selectStart));
lastPart = inSql.Substring(fromStart, inSql.Length - fromStart);
fields = firstPart.Split(',');
firstPart = "";
for (i = 0; i <= fields.Length - 1; i++)
{
if (i > 0)
{
firstPart = firstPart + ", " + fields[i].ToString() + " AS COLUMN" + (i + 1);
firstPart.Trim();
MyText = (TextObject)objRpt.ReportDefinition.ReportObjects[i];
MyText.Text = fields[i].ToString();
}
else
{
firstPart = firstPart + fields[i].ToString() + " AS COLUMN" + (i +1);
firstPart.Trim();
MyText = (TextObject)objRpt.ReportDefinition.ReportObjects[i];
MyText.Text = fields[i].ToString();
}
}
sql = "SELECT " + firstPart + " " + lastPart;
return sql;
}
If you have any ideas or suggestions please let me know. I am about to give up on this!!  
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Might not be whats' bugging you, but there's a comma before the "from" keyword;
TimeSheetDate, from tblTimesheetDetails
I are Troll 
|
|
|
|
|
And please use a parameterized statement.
|
|
|
|
|
|
Kwagga wrote: The bold part is where the problem is!! As you can see there is a double assign to an Alias and I can't run the SUM without assigning it to an Alias!!
Wouldn't it get "COLUMN3" as a columnname of you omit it in the declaration?
inSql = @" Select DISTINCT TSProjectCodeID, EmployeeID, SUM(HoursWorked) FROM tblTimesheetDetails WHERE TimeSheetDate >= '" + startdate + "' AND TimeSheetDate <= '" + todate + "' AND TSProjectCodeID = '" + cmbprojects.Text.ToString() + "'ORDER BY TSProjectCodeID, EmployeeID, HoursWorked";
..or would you like to name it "Total_Hours", while the other columns remain mapped to a numbered alias?
I are Troll 
|
|
|
|
|
Hi Eddy. I managed to get it to work OK. However, now I ams tuck on a another bit of an issue. My tblTimsheetDetails has data as follows:
TimesheetDetailID EmployeeID TimesheetID TSProjectCodeID TaskCode TimeSheetDate HoursWorked
100 F3309134 14 MT101 Test Execution (INT) 2010/07/09 4.00
56 F3309134 14 MT101 Test Support 2010/07/26 2.00
62 F3309134 14 MT101 Project Management 2010/07/27 3.00
66 F3309134 14 MT101 Meeting Project 2010/07/27 0.50
67 F3309134 14 MT101 Meeting Project 2010/07/28 0.50
69 F3309134 14 MT101 Project Management 2010/07/28 2.00
70 F3309134 14 MT101 Meeting Project 2010/07/29 1.00
61 F3309134 13 MT900/910 CR 2010/07/26 0.50
When I run the code I am expecting it to group all the MT101 stuff together and give me as single row with a total sum depending on the date range I select as inout. However, it lists thwm all with the individual timea. this is my first attempt at Crystal Reporting and I am hoping to publish this once I get it all to work 100%.
Ay help or suggestions would be great and it is appreciated mate.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
Kwagga wrote: When I run the code I am expecting it to group all the MT101 stuff together and give me as single row with a total sum depending on the date range I select as inout. However, it lists thwm all with the individual timea.
Can you post the generated Sql? Might be something in the GROUP BY clause.
Kwagga wrote: this is my first attempt at Crystal Reporting and I am hoping to publish this once I get it all to work 100%.
I'm afraid I can't help you there; I don't have any experience in creating Crystal Reports. Been using MS-Access for far too long 
I are Troll
|
|
|
|
|
Kwagga wrote: AS 'TOTAL_HOURS AS COLUMN3
That looks wrong.
|
|
|
|
|
using parameterised statements is a bit dodgy when it comes to crystal reports at run time. I am getting input from DateTimePickers and a pre-loaded comboBox with values from the Database, so SQWL injection is kinda limited or not possible. 
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
You can (and should) use parameterized queries with Crystal.
|
|
|
|
|
I managed to resolve the Issues without parameterized queries mate. Because I am creating the dataset at runtime and then populating it to a database at runtime and dynamically assigning them to columns I had to go the route I went. For some reason it is working perfect now. I understand that parameterized queries workes better and they are safer but I am tunning against an MS Access DB which is not that friendly with stored procedures as far as I have read.
Excellence is doing ordinary things extraordinarily well.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
