#comma delimited

[the-automators]

Easily pushing delimited data into a ListView in AutoHotkey

Easily pushing delimited data into a ListView in AutoHotkey

I used to be a Data Scientist and often found data that I’d want to “peak” at.  AutoHotkey listviews are an easy way to do this!

Example Easily pushing delimited data into a ListView in AutoHotkey

Here’s the code I used to Easily pushing delimited data into a ListView in AutoHotkey  

#Include ;***********************************…

View On WordPress

[jhtechie]

Parsing CSV file with Perl - changing commas to tabs

I have an input csv file, comma delimited. The trouble is there are some fields which look like this; field1,another_one,"hello, there",2,3,4 This obviously will cause an issue as most import routines will see this as two separate fields. Ideally, I'd like to parse the file, change the commas to tabs, and get rid of double-quotes. This Perl sample shows how to open a text file, parse it, write it out to a new file, as well as how to loop through an array of arrays and how to use the Perl Text::ParseWords module. #!/usr/bin/perl # # Perl script to change commas to tabs in comma-delimited CSV # This also avoids issue of commas embedded in fields # (in case you think a one-line sed would have achieved this!) # print "Converting from comma to tab delimited \n"; # Print a message use Text::ParseWords; local $/ = "\n"; # tell chomp to look for LF (for CRLF change this to \r\n) # delete existing output file, open input and output files unlink("sample_output_tabs.csv"); open (INFILE, './sample_output.csv'); open (OUTFILE, '>>sample_output_tabs.csv'); while () { chomp; $_ =~ s/\'//g; # remove single quotes @lists = &nested_quotewords(',', 0, $_); # parse each line push @arr,@{$_} foreach(@lists); for($i=0;$i<=$#arr-1;$i++){ print OUTFILE $arr[$i]; if ($i != 14) {print OUTFILE "\t";} # put tab on end if not the last field } @arr = (); print OUTFILE "\n"; # line feed on end of each line } close (INFILE); close (OUTFILE);

[woodvavb027-blog]

Auto Trakker downloadable Software

Auto Trakker downloadable Software Key features: * Monitor fuel usage * Track fuel economy trends * Track vehicle service expenses * Generate maintenance expense reports * Monitor all vehicle maintenance * Schedule maintenance by date and/or distance * Track every vehicle expense with one program! * Track up to 15 vehicles * Create comma-delimited (.csv) reports that can be view on a PC *User friendly Graphical User Interface * Works with color, 2-bit, and 4-bit screen displays Auto Trakker is a compact PDA program that has the ability to track records for up to 15 vehicles. You have the capability to monitor records using the units of your choice. That is, liters versus gallons or Mpg versus km/L and many more. The option to convert existing database entries to different units is available too. Auto Trakker builds on to the already popular Fuel Trakker program. Fuel records can be entered in any order. There is a built in validation checker to verify data entries. For example, more recent entries must have higher odometer readings and vice versa. Unlike other programs that have you calculate the distance you traveled from the previous fuel purchase then enter the value into the program, Auto Trakker handles all of the operations for you. You can even enter records out of order, just as long as the new entry meets Auto TrakkerÂs validation requirements. Maintenance reminders can be set for any vehicle using the date alarm or by distance taken from odometer readings. All al