Loading ...
Sorry, an error occurred while loading the content.

96974RE: Vim Tips wiki celebrates with a CSV tip

Expand Messages
  • nh_wzg
    Oct 11, 2008
    • 0 Attachment
      Please see the updated code:
      http://vim.wikia.com/wiki/Working_with_CSV_files

      I'm using Vim's str2float() to convert a field to a float. A field like
      "1.25junk"
      will be regarded as 1.25. A field like "junk1.25" will be regarded as a
      string and
      will sort before numbers.


      Hi John:

      With the updated code,the result of the example I post above with the ":Sort
      1 n" is:
      ===Result Begin===
      num,md51,fullpath_filename,fullname2,
      -3.45,10D0BA441255894A51C8B3308EB11638,X:\I386\0410.CS_,0410.csv,
      -1.90,45158FF10F952BCFC590ECB2C80D487E,X:\I386\0414.CS_,0414.csv,
      0.123,59D691289820021216E6CDCAD74743D4,X:\I386\0419.CS_,0419.csv,
      0.175,FF5EA7161307D7170C39D31629239CDF,X:\I386\BOPOMOFO.UC_,bopomofo.UCE,
      0.362,FF6223C000741845CE8CD0C6336021D1,X:\I386\D3DXOF.DL_,d3dxof.dll,
      -0.34,FF762A792EFCB11C917A2682352F71D1,X:\I386\HPCRDP.CA_,hpcrdp.cat,
      1.723,3ECA13B43EF48F80F0179856A73A3BA6,X:\I386\0416.CS_,0416.csv,
      2.114,FE82CCD0D5BD8F6FDE7D48252C25F271,X:\I386\CATSRVUT.DL_,catsrvut.dll,
      3.120,FE385CA3249BF6D30C031DEACE045AD3,X:\I386\DBMSRPCN.DL_,DBmsRPCn.dll,
      3.452,FF32B826D2F3C5E41DCAF8B272AB0BF3,X:\I386\INETSRV.MI_,inetsrv.mib,
      4.576,FF36362448658F15D2B6E3B593CA1B3F,X:\I386\BUSY_I.CU_,busy_i.cur,
      4.513,FE97D798B2BC6CB4306B21E078AA6214,X:\I386\C_437.NL_,c_437.nls,
      5.988,44029A87AD3484711FACB7945D242A95,X:\I386\0401.CS_,0401.csv,
      5.123,FF39047446FC1C46FC0C1FA4071063CB,X:\I386\DG18D50.IC_,Dg18d50.icm,
      6.976,FEC5273EB05873C93DA9BE16A94AEE94,X:\I386\AGT0401.DL_,Agt0401.dll,
      7.892,FF04598C86B5DF9B78F122ABCB266790,X:\I386\AGT0419.HL_,Agt0419.hlp,
      7.234,FE0399122F5DB5158E28AF73A1ED94A1,X:\I386\CDOSYS.DL_,cdosys.dll,
      8.679,FFFBC075AA7E1756E35B5AF2E8BE7DEB,X:\I386\DISK.SY_,disk.sys,
      9.123,FF9BDB807FC99B2B6156742AC2F9F2AB,X:\I386\COADMIN.DL_,coadmin.dll,
      9.772,FFF5CBFC71FB5C80AAD9F834B3FB5062,X:\I386\IMESHARE.DL_,imeshare.dll,
      10.32,FECC01645D83F150EBE2924887E30B91,X:\I386\DMUTIL.DL_,dmutil.dll,
      12.65,FFF68CFBFA883D81731A6B344A25B782,X:\I386\CGA80852.FO_,cga80852.fon,
      78.45,FFE31887684AED0F7B124378D942D3AC,X:\I386\CB32.EX_,cb32.exe,
      ===Result End===

      It seems still some bugs in the code.
      Hope the feedback is useful.

      Best regards,
      nh_wzg
      --
      View this message in context: http://www.nabble.com/Vim-Tips-wiki-celebrates-with-a-CSV-tip-tp18768619p19931031.html
      Sent from the Vim - General mailing list archive at Nabble.com.


      --~--~---------~--~----~------------~-------~--~----~
      You received this message from the "vim_use" maillist.
      For more information, visit http://www.vim.org/maillist.php
      -~----------~----~----~----~------~----~------~--~---
    • Show all 25 messages in this topic