FIXIT MENU:
home about us contact us

WHAT'S AVAILABLE:
free scripts advanced scripts online tools great books web related tutorials contributed tutorials news archive geek toys!

SUPPORT:
help forum live chat help



Selected article

RSS feed   enewsbar Live Subscribe    Add to MyYahoo    Add to Google

Other HTMLfixIT articles:




by Don

This clip will take a selection of data contained in a comma separated file (without quotes) and reorder those fields in a random fashion.

; take delimited comma separated values
; highlight some of them exclusive of outside
; commas one,*two,three,four*,five,six
; it will then put those values at the end
; the file in random order
; by don at htmlfixit.com

; set list delimiter
^!SetListDelimiter ","
; set array = to selection
^!SetArray %values_current_order%=^$GetSelection$

; set new array to same ... will change later
^!SetArray %values_new_order%=^$GetSelection$
; counter to be sure we get all items
^!Set %NA%=0

; in this loop we get a random item from the array
; and check it to see if we already used it
; if not put it in the new array
:Loop
^!Set %random_digit%=^$Calc(RND(^$Calc(^%values_current_order0%-1)$)+1;0)$
; mark out already used values
^!If "^%values_current_order^%random_digit%%" = "*e*m*p*t*y*" Loop ELSE Process

:Process
; build the new array and cycle back for more
; unless done
^!Inc %NA%
^!Set %values_new_order^%NA%%=^%values_current_order^%random_digit%%
^!Set %values_current_order^%random_digit%%=*e*m*p*t*y*
^!If "^%NA%" < "^%values_current_order0%" Loop ELSE Next
^!Jump Doc_End
; you may want to do something else with the output
^!InsertText ^P^P^%values_new_order%^P

Keywords: reorder, random, csv, comma separated value, file








One Response to “Generate Random List of CSV Field Data”

  1. Kingston Lawyers Says:

    I can tell you have put a lot of work into it. Thank you for this great ideas and for sharing it to your readers.

    Kingston Lawyers







This site is totally free to use, you have absolutely no moral or legal obligations to help us continue.
There are however, some costs involved in running the site.

<random humor>
Plus sometimes Franki prefers EMU bitter to VB.
</random humor>

So if this site helped you find your way, perhaps you could consider contributing to our costs. Whatever amount you feel this site was worth to you would be just wonderful.
Use PayPal if you do decide to share and help us with the costs and in appreciation for our time and attention, or alternatively buy a book from our Bookstore..


  Time  in  Don's  part  of the world is:   March 29, 2024, 2:20 am
  Time in Franki's part of the world is:   March 29, 2024, 3:20 pm
  Don't worry neither one sleeps very long!



privacy policy :: support us :: home :: live chat help
contact us :: forum ::tutorials :: bookstore :: Site Map



      Valid XHTML 1.0!             powered by Apache Server
Pic 3 Pic 3

SEARCH:
USEFUL LINKS:

CIGHTML Firefox Thunderbird ClamWin WordPress SpyBot S&D TheGIMP Apache for Windows Registry Cleaners More cool stuff:

//-->

HTMLfixIT Site Stats.

Browser Statistics
Internet Explorer 85.88%
IE 717.63%
IE 62.3%
IE 50.00%
IE other8.6%
Moz Firefox 3.x3.03%
Moz Firefox 2.x0.18%
Moz Firefox 0.x/1.x26.65%
Netscape 8.x0.00%
NS 6+/Mozilla2.73%
Moz Seamonkey0.00%
K-meleon0.00%
Epiphany0.00%
Netscape 4.x0.00%
Opera 9.x0.00%
Opera 8.x0.00%
Opera 7.x0.42%
Opera 6.x0.00%
Opera other0.42%
Safari Mac/Intel5.21%
Safari Mac/PPC0.06%
Safari Windows25.2%
Google Chrome1.51%
Konqueror0.18%
Galeon0.00%
WebTV0.00%


Resolution Statistics
640 x 4800.25%
800 x 60026.14%
1024 x 76836.55%
1152 x 8640.25%
1280 x 80011.68%
1280 x 8540.00%
1280 x 102417.01%
1400 x 10500.00%
1600 x 12001.02%
1920 x 12007.11%
2560 x 10240.00%


OS Statistics
Windows 741.55%
Windows Vista2.4%
Windows 20033.91%
Windows XP20.86%
Windows 20000.36%
Windows NT40.05%
Windows 98/ME0.05%
Windows 950.00%
Linux/UNIX/BSD8.76%
Mac OSX8.03%
Mac Classic0.00%
Misc14.03%



New Windows Virus Alerts
also by sophos.

17 Apr 2011 Troj/Mdrop-DKE
17 Apr 2011 Troj/Sasfis-O
17 Apr 2011 Troj/Keygen-FU
17 Apr 2011 Troj/Zbot-AOY
17 Apr 2011 Troj/Zbot-AOW
17 Apr 2011 W32/Womble-E
17 Apr 2011 Troj/VB-FGD
17 Apr 2011 Troj/FakeAV-DFF
17 Apr 2011 Troj/SWFLdr-W
17 Apr 2011 W32/RorpiaMem-A

For details and removal instructions, click the virus in question.