Aug
2
2010
My JaxCodeCamp Schedule
My JaxCodeCamp Schedule
0 comments - Posted by john at 11:08 PM - Categories: (Tech) .Net | (Tech) Microsoft SQL
Scion Of Faith was lost but now I am found...
Category: (Tech) .Net
Sep
16
2009
I will be presenting to the Jacksonville Developer User's Group Oct 7th
Unity3D leverages Mono, an open source implementation of C#, to build out to multiple platforms including Apple's OSX (including IPhone and Itouch), Microsoft's Windows and Nintendo's Wii.
0 comments - Posted by john at 5:31 PM - Categories: (Tech) .Net | (Tech) Game Engines | (Tech) Microsoft SQL | Gaming (Dev) | Gaming (General)
May
26
2009
My turn now
I am being laid off as part of nelnet's office closure in JAX. June 30 is my last day. I am a senior Coldfusion developer, mid level C# (Mono) command line developer and Have taken 3 Java programming Classes. I am VERY comfortable working from the SQL command line for MySQL and MS-SQL. If you know of anything open hit me up please!
1 comments - Posted by john at 12:01 PM - Categories: (Tech) .Net | (Tech) Microsoft SQL | (Tech) MySQl | Adobe | Coldfusion | Life (Annoyances)
Feb
28
2008
Need some Coldfusion , HTML, CSS, Javascript or PHP Help
or perhaps you need some DTS Packages converted to SSIS. Drop me a line at tyrsblade [at] google mail domain. I am looking to pickup a couple small to medium sized side projects. with the addition of the Little One a little extra cash would be nice.
1 comments - Posted by john at 12:56 PM - Categories: Coldfusion | Adobe | (Tech) Open Source | (Tech) Hardware | (Tech) .Net
Feb
19
2008
Parsing large flat files with irregular delimiters
using System;
using System.Collections;
using System.IO;
using System.Text;
using System.Text.RegularExpressions;
namespace FileSplitter
{
class Program
{
public static void Main(string[] args)
{
if(args.Length < 4){
Console.WriteLine("Usage: ");
}
else
{
string FilePathnName = args[0];
string oFilePathnName = "Candidates";
//string oFilePathnName = "Requisitions";
string cLine = null;
string cDelim = null;
string rDelim = "<><>";
string nRow = null;
string oRow = null;
string sRow = null;
int iCount = 0;
string strBuild = null;
string sColumn = "candidatehrms_code|firstname|middlename|lastname|address1|address2|city|state|zip|countryhrms_code|email|login|password|isemployee|statushrms_code|resumertf|referraltypehrms_code|referraldetail|active|homephone<><>";
//string sColumn = "requisitionhrms_code|jobtitle|markettitle|orderdate|statusdate|createdate|internalexpires|jobcode|jobgradehrms_code|externaljobdescription|internaljobdescription|approved|statushrms_code|openings|placements|flsaexempt|fullpart|eligibleemployeereferral|wagecurrencyhrms_code|countryhrms_code|departmentshrms_code|locationhrms_code|hiringmanagerhrms_code|recruiterhrms_code|eeocodehrms_code|jobcategoryhrms_code|percenttravel|workflowhrms_code|webapproved|confidentialreq|supervisory|active|udfhirereqid|requisitiontypehrms_code|employmenttypehrms_code|incumbentname|aibtarget<><>";
StreamReader sReader = new StreamReader(FilePathnName);
StreamWriter sWriter;
while(sReader.Peek() >= 0){
sRow = sRow + sReader.ReadLine();
if(sRow.Contains("~~")){
iCount = iCount + 1 ;
string[] dRow = sRow.Split("~~".ToCharArray());
if(dRow.Length > 1){
oRow = dRow[0];
sRow = dRow[1] + dRow[2];
strBuild = strBuild + oRow + "<><>";
if(iCount == 1500){
strBuild = sColumn + strBuild;
sWriter = File.CreateText(oFilePathnName + "_" + DateTime.Now.ToString("yyyyMMdd")+ "_" + DateTime.Now.ToString("HHmmss")+ ".txt");
sWriter.Write(strBuild);
sWriter.Close();
iCount = 0;
strBuild = null;
}
else{
if(sReader.Peek() <= 0 ){
strBuild = sColumn + strBuild;
sWriter = File.CreateText(oFilePathnName + "_" + DateTime.Now.ToString("yyyyMMdd")+ "_" + DateTime.Now.ToString("HHmmss")+ ".txt");
sWriter.Write(strBuild);
sWriter.Close();
iCount = 0;
strBuild = null;
}
}
}
}
}
}
}
}
}
Now the only remaining issue is that it strips \r \n and replaces it with tabs and i have no idea why.
0 comments - Posted by john at 1:48 PM - Categories: Adobe | (Tech) Open Source | (Tech) .Net