Modify RegularExpression To Parse VCard/vCalendar To Allow A Particular Field Type?
Nov 18, 2009modify RegularExpression to Parse vCard/vCalendar to allow a particular field type?
View 5 Repliesmodify RegularExpression to Parse vCard/vCalendar to allow a particular field type?
View 5 RepliesI have an vCard application that needs to read vCard Data, and have found a RegularExpression which gets the FieldName, Encoding and FieldValue from the file, here it is below:
^(?<FIELDNAME>[w-]{1,})(?:(?:;?)(?:ENCODING=(?<ENC>[^:;]*)|CHARSET=(?<CHARSET>[^:;]*))){0,2}:(?:(?<CONTENT>(?:[^
]*=
){1,}[^
]*)|(?<CONTENT>[^
]*))
This Regular Expression Reads these kind of values fine:
ORG:Company
FN;ENCODING=QUOTED-PRINTABLE;CHARSET=UTF-8:RoguePlanetoid
However I want it to read these values also
TEL;WORK;VOICE:0200 0000000
Without skipping them. How can I modify the RegularExpression so TEL;WORK;VOICE ends up as part of the "FIELDNAME" and 0200 0000000 is part of the "CONTENT".I am unfamiliar with complex RegularExpressions and cannot figure out how to modify it, there is a regular expression that gets these:
^(?:TEL)([^:]*):(?<TEL>[^
]*)
However it only gets the FieldName as "TEL" and I need the whole value for this so I can tell the numbers apart in my application.If possible the Regular Expression would read the WORK and VOICE elements also like the CHARSET and ENCODING in the current regular expression, so they can treated like an Attribute and Type for example, however anything which allows the Regular Expression to read the whole TEL;WORK;VOICE as the FIELDNAME will be fine.
Edit
^(?<FIELDNAME>[^:]{1,})(?:(?:;?)(?:ENCODING=(?<ENC>[^:;]*)|CHARSET=(?<CHARSET>[^:;]*))){0,2}:(?:(?<CONTENT>(?:[^
]*=
){1,}[^
]*)|(?<CONTENT>[^
]*))
Reads up to the first Colon which covers the Whole FieldName, however it would be nice to store each SemiColon Element in a seperate item such as ATTRIBUTE or TYPE.
I want to be able to read vCard and vCalendar data using .NET, I have something which does this, and have looked at the specification. For those not familar with the format here is some test data from my current application:
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Microsoft Corporation//Windows Calendar 1.0//EN
CALSCALE:GREGORIAN
[Code]....
These are both stored as plain text, filename.ics for vCalendar and filename.vcf for vCard. I currently use line by line parsing, however this seems primitive as iCalendar items can be multi-line could LINQ or similar method be used, such as those that cope with missing or extra elements, including carriage returns in the data? I have the specifications for this, if a similar way is possible for something else then this will be fine, I am using .NET 3.5 and Visual Basic 2008, so can use any .NET feature available that could support this.
If there are fields in a combo box as i press the drop down arrow. and if i select a field... then it should not b deleted using a backspace or anyother key..
View 3 RepliesI am trying to edit a dbf table. I would like to be able to rename field headings and change the field type, ie string or dbl, and the size of the field. is this possible to do with vb.net. I have connected to the dbf file but after that am lost on what to do.
View 3 RepliesI am pulling data from a local MSSQL database using a stored procedure, then send the data to a web service. Every part of the component works well except for a pesky problem will a DBNull being returned from the DataRow field, when I know that the field is not null and has valid data. The database and associated INSERT statements that add to this field are designed to not allow NULL entries. When I debug break the program on or right before the line that throws the error I see that the field has valid data for the current row.If I add a null check to the code (as below) the operation continues as normal:
Dim dataResultsTable = Me.myViewTableAdapter.GetData(int)
For Each myDataRow In dataResultsTable.Rows
If worker.CancellationPending Then
[code]....
Why is the read operation returning DBNull instead of the data in the database?
EDIT: Just to be clear, the operation does return the proper data, but the data is not being saved into the variable.
i need to do something as the old scholl on vb6, create a control array, i need to put 50 listviews controls and when the form is initialized start asigning properties since i will drag items to each one of those grids, im goin to make a dragdrop event to handle all the 50 controls, dont like the idea of adding handles c1, c2,cn, c50 but whatever, is there soemthing easy to create a routine to change properties and add columns to each one control dinamically?
sample
for x=0 to 50
control(x).property = true or ""
next
Having a few problems trying to parse a CSV in the following format using the FileHelpers library. It's confusing me slightly because the field delimiter appears to be a space, but the fields themselves are sometimes quoted with quotation marks, and other times by square brackets. I'm trying to produce a RecordClass capable of parsing this.Here's a sample from the CSV:
xxx.xxx.xxx.xxx - - [14/Jun/2008:18:04:17 +0000] "GET http://www.some_url.com HTTP/1.1" 200 73662339 "-" "iTunes/7.6.2 (Macintosh; N; Intel)"
It's an extract from an HTTP log we receive from one of our bandwidth providers.
Using FileHelpers; how to parse this CSV type
View 1 RepliesI'm trying to import XML duration data into my app and store it as a Timespan.An XElement named 'Q' has a child element 'Timer' of type xs:duration. To extract the value I use the code below:
Dim Timer As Timespan
If Not TimeSpan.TryParse(Q.<Timer>.Value, Timer) Then Timer = Nothing
[code].....
I have some JSON data that looks like this[code]...
I get one root object with key "data", and value another object with 2 children, with keys "name" and "id", and the appropriate values one might expect. But when I try to cast that object to my UserData type, it returns Nothing. I had this code working at some point, but now that I am returning to it and attempting to use it again, it seems some code rot has set in and it has stopped working.
I have a nomenclature to respect while performing some tasks against the Active Directory.Here's the nomenclature:
TT-EEE-Mnemonic: if TT = 'GA' or 'GS' or 'PA' or 'PF' -> the schema to create is a "group", with a groupScope of Global.
[code].....
I need a RegularExpression that can convert a string from a fraction or decimal like "1/2" or "0.5" to a decimal "0.5". It needs to handle both cases. Input can be either fractional or decimal, output must be decimal.
View 3 RepliesI need a RegularExpression that can convert a string from a fraction or decimal like "1/2" or "0.5" to a decimal "0.5". It needs to handle both cases. Input can be either fractional or decimal, output must be decimal...
View 7 RepliesSystem.Text.RegularExpressions.Regex("#*#") is this correct..!? my text can be like #abc1234+as00# etc. ie, anything between #..#
View 4 Replies.NET I want to clone a value type's fields. How can i set a field value on a value type using reflection (or something else dynamically)?
This works for reference types but not for value types. I understand why but I don't know an alternative.
shared function clone(of t)(original as t) as t
dim cloned as t
'if class then execute parameterless constructor
[Code]....
I've got a SQL Database with the field type Date, when i load any data such as 06/04/2010 into my masked textbox it shows as 64/20/10 (without the leading zero's so the date shows wrong.
Also how can I set it to be dd/mm/yyyy and not mm/dd/yyyy?
I am inserting the nChar type value into sql db using the vb.net. Its simple insert query but i dont know why not inserting into db.
[Code]...
I have problem in my application when updating 3 items otherwise it is as good as work. The problem is when updating the username to the access database an error showing that "Datatype mismatch" when updating the date and time field an error occurs and tells that the "Unknown field type". This is my code where bold faced lines have errors:
Dim objCmd As OleDb.OleDbCommand = New OleDb.OleDbCommand()
objCmd.Connection = con.con
'Make a command to insert data
[Code].....
If the field type in the SQLServer db is 'nvarchar 10', what would be / is the field type in a DataTable filled by rows from this SQLServer table? String?
View 1 RepliesWhat value should I put as a default value for Image Data type field on a record?
View 4 RepliesI've got a set of static "enumeration" classes that I'm using to hold meaningful variable names to represent meaningless code values I receive on an input file. Here's an example of one.
Public Class ReasonCodeValue
Private Sub New()
End Sub
[code].....
I have an array set up to receive the names of forms when they open. The form name is sent as a Form not a String therefore when I run my code I cannot check for whether the field is empty in the normal way (ie. array(1) = "") as the "" are only usable with strings!
Dim Forms(24) As Form
Dim i As Integer
Dim Free As Integer = -1
[CODE]...
I only need a solution to do the same as array(1)="" but for windows forms.
How could you, update the fields on database if its data type is Y/N, and the method of updating is a checkbox??
View 1 RepliesA string can contain from 0 to approximately 2 billion (2 ^ 31) Unicode characters. Does this mean the length field for the string is a 4 byte unsigned binary field, or is it a 4 byte signed binary ?
View 4 RepliesI've got a custom NumericEditor control that has a nullable Decimal property called Value. When I bind a data field to Value, I'd like to retrieve the underlying Type of the data that's bound, so that I can restrict the use of decimal places if the source field is an integral data type.I figure I'd have to do this in the BindingContextChanged event, but how do I get the Type of the data field from the binding itself? My Google-Fu is failing me at the moment.
In short, I'm looking for something like the GetValueType method mentioned in the following question: Simple databinding - How to handle bound field/property change. Winforms, .Net I imagine this method would also be handy if the Value property was an Object.
I have the following Data Transfer Objects defined:
Public Class MemberWithAddressesDTO
Public Property Member_PK As Integer
Public Property Firstname As String
Public Property DefaultAddress As AddressDTO
Public Property Addresses As IQueryable(Of AddressDTO)
End Class
[Code]...
How can input number to database where my field in database data type money.[code]...
View 5 RepliesI am linking to an SQL table with 'Money' field. When i try to update this field in VB.NET I get an error message that "Can not convert a character value to money. The char value has incorrect syntax".
[Code]...
My LINQ query is as follows
Dim Query = From t In New XPQuery(Of xUser)(Xpo.Session.DefaultSession)
.Where("Name=John").Select("new (Name as FirstName)")
Unfortunately i get the error No property or field 'John' exists in type 'xUser'.Of course no such property exists in my xUser class, but hot can i fix that?After reading within the DynamicLinq Class i found this function
Function FindPropertyOrField(ByVal type As Type, ByVal memberName As String, ByVal staticAccess As Boolean) As MemberInfo
Dim flags As BindingFlags = BindingFlags.Public Or BindingFlags.DeclaredOnly Or _
If(staticAccess, BindingFlags.Static, BindingFlags.Instance)[code]...
How can i edit my "faulty" query? What am i doing wrong here?