Messages - dnm [ switch to compact view ]

Pages: [1] 2 3 4 5 • next
1
General Software Discussion / Re: What are some good free CSV editor programs?
« on: August 05, 2021, 11:46 PM »
I deal with CSV files all the time. I have been using excel, but it's not really made for csv's. Is there a program out there that deals with just csv's and data shaping?
-CarmeloLabadie (July 21, 2021, 05:31 AM)
Hello there,

This happens to be topical to me for a few reasons, so here's some options I'm aware of that I've used, which may or may not be what you're looking for:


CSVFileView isn't really an interactive editor, in terms of e.g., being able to interactively edit individual cell values, etc. However it does provide a lot of ways to interactively manipulate data in CSVs (like reordering columns and rows, sorting, and saving everything or selected subsets, etc.) as well as a lot of options to save in other formats, like TSV, HTML, XML, JSON, and so forth. Also, be sure to check out the wealth of command line options and switches for batch operation too.

Similarly, this next one, Spread32, isn't CSV-specific, but as a minimalist Excel compatible (to some extent) spreadsheet, it can serve as a handy, lighter-weight option to Excel. I often do a lot of minimalist "use a spreadsheet as a table" style of note taking and small-scale editing in Spread32 and save as either CSV or Excel (XLS) depending; I can always export to CSV for shipping to others or for use in other apps.


Finally, one more suggestion might be Textplorer, which is a text editor that also has support for "structured" text/data files, which can be setup to work with CSVs (as it can be set to work with delimited files). It can be a little unclear on how that support works, you'll have to read through what little documentation there is and fiddle with examples, but it does work.


Hope this helps. Let me know what else you find if you come across other options, and what your experiences are if you try any of the above.

2
PBOL / Re: Weird precision (or lack thereof) in time remaining displayed
« on: May 20, 2020, 12:24 AM »
Hi Mouser!

Just happened to be tinkering with PBOL recently, noticed some possibly odd behavior, and saw this thread with a new beta version. Tried the 2.07.00 beta, but still seem to be seeing the same thing, which is where the right edge of the bars always seems to extend past the right edge of the window, regardless of size, when I have captions on the left and "Full width bar panels (one per row)" selected for "Sizing". (Also have "Equalize widths" checked). Important to point out that if I switch captions to the right, no problem.

I can't recall exactly, and haven't yet tested (but will), but I don't think from a fresh (portable) install this was happening, I think it's only after I started adjusting appearance settings and trying out other skins. But not 100% sure. Will try with a fresh copy and see what happens.

Captions: Left
pbol-left.PNG

Captions: Right
pbol-right.PNG

3
General Software Discussion / Re: Best Python IDE
« on: November 04, 2008, 11:55 PM »
I use Wingware's Wing IDE myself, and highly recommend it. I also wanted to second 40hz's recommendation of learning the language first, then learning the IDE. But, having said that, if you know Python well, I find Wing IDE a huge boon, especially for larger projects.

4
Developer's Corner / Re: AutoHotkey Programming Questions Megathread
« on: May 13, 2008, 06:14 PM »
Here's a question to start off the thread.

Earlier today I was trying to get write some basic AHK functions which allow me to convert characters which I've copied to the clipboard to a different representation. For instance, my initial use case was something like this: I want to be able to copy a series of bytes from my hex editor (as hex bytes) and use a hotkey to trigger a function (or series of functions) which will bit-invert those bytes, then save them as hex bytes back to the clipboard. Once that's done, I can paste them back into my hex editor and see the ASCII representation of the inverted bytes.

The strategy I used to go about this was seemingly simple, but possibly too complex. I'm not sure. I assume up front that the bytes I'm copying are already valid hex bytes, 0-9 and A-F, regardless of case (uppercase everything internally), and ignore whitespace (SPC, TAB, and RET). Convert from hex to a binary value, invert the value, then convert from binary to hex and save to the clipboard.

I'm not terribly familiar with writing functions in AHK; mostly I use it for hotstrings and hotkeys only. I tried my hand at a couple different approaches, none of which worked fully. I also looked at the following code samples on the AHK Community Forums, which seemed really interesting, but also overkill for what I want.

http://www.autohotkey.com/forum/topic21172.html
http://www.autohotkey.com/forum/topic21172-105.html

I did find some code in AutoIt (v3) that I modified only slightly that works well (at least the one bit I've tested), but the problem is that I don't run AutoIt like I run AutoHotkey, i.e. running in my system tray, capturing key macros, replacing text, etc. I probably can run AutoIt that way (I'd have to look into it), but generally I run AutoIt scripts for specific tasks, and don't really use it the same way I use AutoHotkey. While I could just write hotkeys in AutoHotkey to call the AutoIt scripts, that gets rid of the idea of having this be self-contained in my standard AHK script, and complicates deployment.

Any ideas? I'm open to all approaches, as long as I can make sense of the code.

Thanks in advance!

Here's the edited AutoIt code (as it stands right now):

Code: AutoIt [Select]
  1. ; baseconv.au3 -- Base conversion functions for representative strings (binary
  2. ;                 strings, decimal values, hex values).
  3.  
  4. ; ==============================================================================
  5. ; FUNCTIONS
  6. ; ==============================================================================
  7. ;
  8. ; Original code for functions by "ptrex" on AutoIt Forums
  9. ; http://www.autoitscript.com/forum/index.php?showtopic=70507
  10.  
  11. ; --------------------------------------------------------------------------
  12. ; BinStr2Dec
  13. ; --------------------------------------------------------------------------
  14. Func BinStr2Dec($strBin)
  15. Local $Return
  16. Local $lngResult
  17. Local $intIndex
  18.  
  19. If StringRegExp($strBin,'[0-1]') then
  20. $lngResult = 0
  21.   For $intIndex = StringLen($strBin) to 1 step -1
  22.     $strDigit = StringMid($strBin, $intIndex, 1)
  23.     Select
  24.       case $strDigit="0"
  25.         ; do nothing
  26.       case $strDigit="1"
  27.         $lngResult = $lngResult + (2 ^ (StringLen($strBin)-$intIndex))
  28.       case else
  29.         ; invalid binary digit, so the whole thing is invalid
  30.         $lngResult = 0
  31.         $intIndex = 0 ; stop the loop
  32.     EndSelect
  33.   Next
  34.  
  35.   $Return = $lngResult
  36.     Return $Return
  38.     MsgBox(0,"Error","Wrong input, try again ...")
  39.     Return
  42.  
  43. ; --------------------------------------------------------------------------
  44. ; Dec2BinStr
  45. ; --------------------------------------------------------------------------
  46. Func Dec2BinStr($iDec)
  47. Local $i, $sBinChar = ""
  48.  
  49. If StringRegExp($iDec,'[[:digit:]]') then
  50. $i = 1
  51.  
  53.  $x = 16^$i
  54.  $i +=1
  55.  ; Determine the Octects
  56. Until $iDec < $x
  57.  
  58. For $n = 4*($i-1) To 1 Step -1
  59.     If BitAND(2 ^ ($n-1), $iDec) Then
  60.         $sBinChar &= "1"
  61.     Else
  62.         $sBinChar &= "0"
  63.     EndIf
  65.  Return $sBinChar
  67.     MsgBox(0,"Error","Wrong input, try again ...")
  68.     Return
  71.  
  72. ; --------------------------------------------------------------------------
  73. ; Hex2Dec
  74. ; --------------------------------------------------------------------------
  75. Func Hex2Dec($Input)
  76. Local $Temp, $i, $Pos, $Ret, $Output
  77.  
  78. If StringRegExp($input,'[[:xdigit:]]') then
  79. $Temp = StringSplit($Input,"")
  80.  
  81. For $i = 1 to $Temp[0]
  82.     $Pos = $Temp[0] - $i
  83.     $Ret =  Dec (Hex ("0x" & $temp[$i] )) * 16 ^ $Pos
  84.     $Output = $Output + $Ret
  86.     return $Output
  88.     MsgBox(0,"Error","Wrong input, try again ...")
  89.     Return
  92.  
  93. ; --------------------------------------------------------------------------
  94. ; Dec2Hex
  95. ; --------------------------------------------------------------------------
  96. Func Dec2Hex($Input)
  97. local $Output, $Ret
  98.  
  99. If StringRegExp($input,'[[:digit:]]') then
  101.     $Ret = Int(mod($Input,16))
  102.     $Input = $Input/16
  103.     $Output = $Output & StringRight(Hex($Ret),1)
  104. Until Int(mod($Ret,16))= 0
  105.  
  106.     Return StringMid(_StringReverse($Output),2)
  108.     MsgBox(0,"Error","Wrong input, try again ...")
  109.     Return
  112.  
  113. ; --------------------------------------------------------------------------
  114. ; BinStr2Hex
  115. ; --------------------------------------------------------------------------
  116. Func BinStr2Hex($strBin)
  117.     Local $test, $Result = '',$numbytes,$nb
  118.  
  119. If StringRegExp($strBin,'[0-1]') then
  120.  
  121.     if $strBin = '' Then
  122.         SetError(-2)
  123.         Return
  124.     endif
  125.  
  126.     Local $bits = "0000|0001|0010|0011|0100|0101|0110|0111|1000|1001|1010|1011|1100|1101|1110|1111"
  127.     $bits = stringsplit($bits,'|')
  128.     #region check string is binary
  129.  
  130.     $test = stringreplace($strBin,'1','')
  131.     $test = stringreplace($test,'0','')
  132.     if $test <> '' Then
  133.         SetError(-1);non binary character detected
  134.         Return
  135.     endif
  136.     #endregion check string is binary
  137.  
  138.     #region make binary string an integral multiple of 4 characters
  139.     While 1
  140.         $nb = Mod(StringLen($strBin),4)
  141.         if $nb = 0 then exitloop
  142.         $strBin = '0' & $strBin
  143.     WEnd
  144.     #endregion make binary string an integral multiple of 4 characters
  145.  
  146.     $numbytes = Int(StringLen($strBin)/4);the number of bytes
  147.  
  148.     Dim $bytes[$numbytes],$Deci[$numbytes]
  149.     For $j = 0 to $numbytes - 1;for each byte
  150.     ;extract the next byte
  151.         $bytes[$j] = StringMid($strBin,1+4*$j,4)
  152.  
  153.     ;find what the dec value of the byte is
  154.         for $k = 0 to 15;for all the 16 possible hex values
  155.             if $bytes[$j] = $bits[$k+1] Then
  156.                 $Deci[$j] = $k
  157.                 ExitLoop
  158.             EndIf
  159.         next
  160.     Next
  161.  
  162. ;now we have the decimal value for each byte, so stitch the string together again
  163.     $Result = ''
  164.     for $l = 0 to $numbytes - 1
  165.         $Result &= Hex($Deci[$l],1)
  166.     Next
  167.     return $Result
  169.     MsgBox(0,"Error","Wrong input, try again ...")
  170.     Return
  173.  
  174. ; --------------------------------------------------------------------------
  175. ; Hex2BinStr
  176. ; --------------------------------------------------------------------------
  177. Func Hex2BinStr($strHex)
  178.     Local $Allowed = '0123456789ABCDEF'
  179.     Local $Test,$n
  180.     Local $Result = ''
  181.     if $strHex = '' then
  182.         SetError(-2)
  183.         Return
  184.     EndIf
  185.  
  186.     $strHex = StringSplit($strHex,'')
  187.     for $n = 1 to $strHex[0]
  188.         if not StringInStr($Allowed,$strHex[$n]) Then
  189.             SetError(-1)
  190.             return 0
  191.         EndIf
  192.     Next
  193.  
  194.     Local $bits = "0000|0001|0010|0011|0100|0101|0110|0111|1000|1001|1010|1011|1100|1101|1110|1111"
  195.     $bits = stringsplit($bits,'|')
  196.     for $n = 1 to $strHex[0]
  197.         $Result &=  $bits[Dec($strHex[$n])+1]
  198.     Next
  199.  
  200.     Return $Result
  202.  
  203.  
  204. ; ==============================================================================
  205. ; TEST CODE
  206. ; ==============================================================================
  207.  
  208. ; Quick and drity, not good test code, but works for now.
  209. ; Currently only tests Hex2BinStr.
  210.  
  211. Dim $testVal1 = "DEAD"
  212. Dim $returnVal1 = Hex2BinStr($testVal1)
  213. MsgBox(0,"Results",$returnVal1)
  214. ; Expected value: 1101111010101101
  215.  
  216. Dim $testVal2 = "2152"
  217. Dim $returnVal2 = Hex2BinStr($testVal2)
  218. MsgBox(0,"Results",$returnVal2)
  219. ; Expected value: 0010000101010010
  220.  
  221. Dim $testVal3 = "b57b"
  222. Dim $returnVal3 = Hex2BinStr($testVal3)
  223. MsgBox(0,"Results",$returnVal3)
  224. ; Expected value: 1011010101111011

5
Developer's Corner / AutoHotkey Programming Questions Megathread
« on: May 13, 2008, 06:01 PM »
I didn't see an existing thread for questions about AutoHotkey programming, so I thought I'd start a catch-all here. Mouser, feel free to move this wherever is more appropriate.

The idea is that since we have sterling AutoHotkey (AHK) programmers like skrommel and others, those of us on DonationCoder who have AHK programming questions can ask them of each other here. This isn't a replacement for the AutoHotkey Community forums, just a local thread for AHK programming questions. Deeper discussions can be taken offline, moved to another thread, or moved to the AutoHotkey Community forums.

Thanks for reading!

Pages: [1] 2 3 4 5 • next
Go to full version