Arrange and Extract from .txt/.csv

Machariel · Post by **Machariel** » Tue Mar 18, 2008 12:56 pm

Hi.

How to first arrange colums from a .csv file (it is saved as a .txt) and then extract an area of data (not all data) from a from .txt/.csv to then place in another application. I will prefer to avoid Excel being used as is has to be done multiple times per minute.

It has to take the lowest of "price" in only lines with 'False'

Then add -1 to the number.

Then extract the new number, for it to be paste with the mouse in another application.

The number that comes out has to be witout decimal, (has to be deleted somehow) before it can be 'paste' in another application.

Thanks

Code: Select all

price,vol,ID,place,order,Entered,Volume,biding,is,dur,IDS,ggd,System,label,
137328740.0,1.0,10209,32767,681613326,1,1,False,2008-03-17,90,60011740,10000064,30004969,5,
137328740.98,1.0,10209,32767,680988764,1,1,False,2008-03-17,90,60011740,10000064,30004969,5,
137330000.0,1.0,10209,32767,678119340,1,1,False,2008-03-17,90,60011740,10000064,30004969,5,
139999999.0,1.0,10209,32767,678227205,1,1,False,2008-03-15,90,60011740,10000064,30004969,5,
140000000.0,1.0,10209,32767,678865577,1,1,False,2008-03-15,30,60011749,10000064,30004967,6,
145899999.0,2.0,10209,32767,676540077,3,1,False,2008-03-14,90,60011740,10000064,30004969,5,
148000000.0,1.0,10209,32767,671947905,1,1,False,2008-03-08,90,60010162,10000064,30005010,8,
103324000.0,1.0,10209,3,674347859,1,1,True,2008-03-17,90,60011740,10000064,30004969,5,
103323000.08,3.0,10209,2,639464711,3,1,True,2008-03-17,90,60011740,10000064,30004969,5,
103321000.0,1.0,10209,30,680572404,1,1,True,2008-03-16,90,60011740,10000064,30004969,5,
103311010.01,2.0,10209,3,672554135,2,1,True,2008-03-16,90,60011740,10000064,30004969,5,
102003000.01,1.0,10209,32767,644024111,1,1,True,2008-03-14,90,60011740,10000064,30004969,5,
95219001.0,1.0,10209,5,660986360,1,1,True,2008-03-05,90,60011740,10000064,30004969,5,
93500000.0,1.0,10209,0,640616983,1,1,True,2008-03-03,90,60011740,10000064,30004969,5,
93210545.0,1.0,10209,-1,652165119,1,1,True,2008-03-01,90,60011740,10000064,30004969,5,
93000010.0,1.0,10209,4,655677857,1,1,True,2008-02-19,90,60011740,10000064,30004969,5,

[/b]

________
GSX-R1000

Bob Hansen · Post by **Bob Hansen** » Wed Mar 19, 2008 12:46 am

I would probably use VB Script Regular Expression to get the three values per False line out as variables. Separate the values, then use a compare process to get the lowest value, than Add -1 and save as final value to be pasted.

Machariel · Post by **Machariel** » Wed Mar 19, 2008 11:29 am

Thanks

I will try this out..
________
herbal shop