I'm receiving an xml file that has a child called modified and it represents a date value in the form of a string -- Nov 14, 2008 -- and in my app, I have items associated with each object and I'm trying to sort them by the date modified field.
So what's the problem, right?
Well, obviously Sep 14, 2008 is before Nov 14, 2008, but when doing a sort process, ActionScript will come back with Nov coming before Sep, because N comes before S in any sort.
So I figured that I would convert the string to a number and then later specify that this is a numeric sort.
Here's the code that traverses through the XML and changes the string to numbers: -
public function createDate(s:String):String
-
{
-
var retStr:String = '';
-
var str2xml:XML = new XML(s);
-
var xml2list:XMLList = new XMLList(str2xml);
-
var list2col:XMLListCollection = new XMLListCollection(xml2list);
-
-
var mods:XMLList = list2col.children().child("modified");
-
-
var mod:String = list2col.children().child("modified").text();
-
for each(var h:XML in mods)
-
{
-
var xml2str:String = h;
-
trace("list2col"+list2col.children().child("modified").text());
-
switch(xml2str.substr(0,4))
-
{
-
case "Jan ":
-
xml2str=xml2str.replace("Jan ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Feb ":
-
xml2str=xml2str.replace("Feb ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Mar ":
-
xml2str=xml2str.replace("Mar ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Apr ":
-
xml2str=xml2str.replace("Apr ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "May ":
-
xml2str=xml2str.replace("May ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Jun ":
-
xml2str=xml2str.replace("Jun ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Jul ":
-
xml2str=xml2str.replace("Jul ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Aug ":
-
xml2str=xml2str.replace("Aug ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Sep ":
-
xml2str=xml2str.replace("Sep ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Oct ":
-
xml2str=xml2str.replace("Oct ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Nov ":
-
xml2str=xml2str.replace("Nov ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
case "Dec ":
-
xml2str=xml2str.replace("Dec ","01");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.replace(",","");
-
xml2str=xml2str.replace(" ","");
-
xml2str=xml2str.substr(0,8);
-
retStr = xml2str;
-
break;
-
default:
-
// do nothing
-
}
-
trace("retStr"+retStr);
-
}
-
return retStr;
-
}
-
No problem, right? This definitely works, but that is not where my issue lies.
How do I re-insert the converted values in the exact same place as where it was located when I received the xml?
Or do I have to grab every object and reassemble it?
I'm hoping there is an easier way and, as usual, your help is appreciated and thanx n advance
3  3283 
I'm not an expert with integrating XML and Flash, but could you like create a new instance of the XML file and copy all of the data from the XML file you opened into that instance. Therefore, whenever you change anything, you'd change the second instance, leaving the originally XML file, unchanged?
If worse comes to worse, you might have to "reassemble " the XML file...
joedeene
Thanx 4 d idea of treating it as one object/instance.
After making my replaces, then it was time to return the whole xml object: -
public function createDateModified(s:String):XML
-
{
-
var i:int = 0;
-
var retStr:String = '';
-
var str2xml:XML = new XML(s);
-
var xml2list:XMLList = new XMLList(str2xml);
-
var list2col:XMLListCollection = new XMLListCollection(xml2list);
-
-
var mods:XMLList = list2col.children().child("modified");
-
-
var mod:String = list2col.children().child("modified").text();
-
for each(var h:XML in str2xml.children().child("modified"))
-
{
-
var someStr:String = str2xml.children().modified[i].text();
-
switch(someStr.substr(0,4))
-
{
-
case "Jan ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Jan ","010");
-
}
-
else
-
{
-
someStr=someStr.replace("Jan ","01");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Feb ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Feb ","020");
-
}
-
else
-
{
-
someStr=someStr.replace("Feb ","02");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Mar ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Mar ","030");
-
}
-
else
-
{
-
someStr=someStr.replace("Mar ","03");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Apr ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Apr ","040");
-
}
-
else
-
{
-
someStr=someStr.replace("Apr ","04");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "May ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("May ","050");
-
}
-
else
-
{
-
someStr=someStr.replace("May ","05");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Jun ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Jun ","060");
-
}
-
else
-
{
-
someStr=someStr.replace("Jun ","06");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Jul ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Jul ","070");
-
}
-
else
-
{
-
someStr=someStr.replace("Jul ","07");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Aug ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Aug ","080");
-
}
-
else
-
{
-
someStr=someStr.replace("Aug ","08");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Sep ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Sep ","090");
-
}
-
else
-
{
-
someStr=someStr.replace("Sep ","09");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Oct ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Oct ","100");
-
}
-
else
-
{
-
someStr=someStr.replace("Oct ","10");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Nov ":
-
trace("comma"+someStr.substr(6,1));
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Nov ","110");
-
}
-
else
-
{
-
someStr=someStr.replace("Nov ","11");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
case "Dec ":
-
if(someStr.substr(6,1) != ",")
-
{
-
someStr=someStr.replace("Dec ","120");
-
}
-
else
-
{
-
someStr=someStr.replace("Dec ","12");
-
}
-
someStr=someStr.replace(" ","");
-
someStr=someStr.replace(",","");
-
someStr=someStr.replace(" ","");
-
someStr=someStr.substr(0,8);
-
str2xml.children().modified[i] = someStr;
-
i++;
-
break;
-
default:
-
// do nothing
-
}
-
//trace("retStr"+retStr);
-
}
-
return str2xml;
-
}
-
So, you fixed the problem? Because that was a lot of code, haha. I just skimmed it.
joedeene
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Ramakrishnan Nagarajan |
last post by:
Hi,
I am converting Excel data into a Dataset in C#. There are around 24 columns
in the Excel Sheet.
First I tried to insert one row with correct values in the Excel sheet. i.e.
for text columns I entered text values and for numeric columns I entered
numeric values. It works fine and pass through all the validation checks and
gets inserted into the database successfully.
But when I gave some junk values in the excel sheet and tried to...
|
by: Frederik Vanderhaeghe |
last post by:
Hi,
I have a problem converting text to a double. Why doesn't the code work:
If Not (txtdocbedrag.Text = "") Then
Select Case ddlBedrag.SelectedIndex
Case 0
Case 1
|
by: Rob Meade |
last post by:
Hi all,
Ok - I've come from a 1.1 background - and previously I've never had any
problem with doing this:
Response.Write (Session("MyDate").ToString("dd/MM/yyyy"))
So, I might get this for example:
21/05/2006
|
by: AMP |
last post by:
Hello,
I want to add some variables to a string and this isnt working.
textBox1.Text="'BSL version='+ bslVerHi+ bslVerLo";
What am I doing wrong?
Thanks
Mike
|
by: CoreyWhite |
last post by:
Problem:
You have numbers in string format, but you need to convert them to a
numeric type, such as an int or float.
Solution:
You can do this with the standard library functions. The functions
strtol, strtod, and strtoul, defined in <cstdlib>, convert a null-
terminated character string to a long int, double, or unsigned long.
You can use them to convert numeric strings of any base to a numeric
| | |
by: allthecoolkidshaveone |
last post by:
I want to convert a string representation of a number ("1234") to an
int, with overflow and underflow checking. Essentially, I'm looking
for a strtol() that converts int instead of long. The problem with
strtol() is that a number that fits into a long might be too big for
an int. sscanf() doesn't seem to do the over/underflow checking.
atoi(), of course, doesn't do any checking. I've long thought it odd
that there aren't strtoi() and...
|
by: Brian Parker |
last post by:
I am beginning to work with VB2005.NET and I'm getting some problems
with string formatting converting an application from VB6.
VB6 code:-
sTradeDate = Format(pArray(4,i Record), "mmddyy")
pArray is a variant array containing a date string at pArray(4,
iRecord) in the format "yyyy/mm/dd"
|
by: Jef Driesen |
last post by:
How can I convert a date string to a number (e.g. a time_t value or a tm
struct)? I know about the strptime function, but then I have to know the
format string. And that is a problem.
I'm trying to autoformat the contents of text entries in a GUI. For
numbers, I'm converting the text representation to the appropriate type
(using atoi, atof, ...) and converting the result back to text with the
correct format (using sprintf). But this does...
|
by: PW |
last post by:
Hi,
When I run the following command, some fields are ending up blank when
the clearly have values them in Excel. I have tried converting the
columns to general and text. The ones that are ending up blank (Null,
actually) contain:
lu24769884l
lu24769884xxl
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
