Search found 763 matches

by Albireo
25 Jun 2019, 18:04
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

Thank you for all the ideas and opinions. (Now it works as desired) interesting if new thoughts appear on the subject And the var result should be different only if inside the quotation marks are present valid delimiters. What do you mean by that? (I have no problem with "19,90",Emelie,302,"Row 1" )...
by Albireo
25 Jun 2019, 06:50
Forum: Ask For Help
Topic: keyboard key
Replies: 5
Views: 180

Re: keyboard key

I don't understand what you want to do! In the first example, you want to do something every hour (is it your desire?) Is it not better to use Windows Scheduler? (else you must build your own with SetTimer or ...) In the next example (wait for a key) In this example the AHK-program is wait to you pr...
by Albireo
25 Jun 2019, 06:10
Forum: Ask For Help
Topic: ; How to Split 78 sets of combined coordinates into separated x y and save to ini file Topic is solved
Replies: 6
Views: 117

Re: ; How to Split 78 sets of combined coordinates into separated x y and save to ini file Topic is solved

just me wrote:
25 Jun 2019, 05:51
@Albireo:
In the settings GUI, X and Y values are combined as X, Y in edit fields. In the INI file, they are stored as Coordn in two sections [X_Coord] and [Y_Coord.
Thanks! Now I see the problem... (but I don't have a solution)
by Albireo
25 Jun 2019, 05:18
Forum: Ask For Help
Topic: ; How to Split 78 sets of combined coordinates into separated x y and save to ini file Topic is solved
Replies: 6
Views: 117

Re: ; How to Split 78 sets of combined coordinates into separated x y and save to ini file Topic is solved

OCP wrote:
24 Jun 2019, 18:12
... initially when my coordinates get saved it is still in a split state (separated x and y) but when i load a new set in my variables they are combined...
I don't understand! give some example.
by Albireo
25 Jun 2019, 05:12
Forum: Ask For Help
Topic: Use data from clipboard Topic is solved
Replies: 4
Views: 78

Re: Use data from clipboard Topic is solved

or #NoEnv #SingleInstance Force Clipboard = (LTrim 23.10.2018 5701849 5838131 Manfred Weisel 0,01 24.10.2018 5701913 20007546 Melanie Gießler 0,01 24.10.2018 5701921 6206676 Prodius Ltd. & Co. KG 0,01 26.10.2018 5701983 20004996 Andre Uzulis 0,01 26.10.2018 5701985 4672598 Knauf Gips KG 0,01 26.10.2...
by Albireo
25 Jun 2019, 03:18
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

Thanks for your information! ... the "text delimiter" is usually " or ` . So you could usually ignore anything between this... In the CSV files I intend to handle, there is only " as text delimiter. ...The "separator delimiter", is usually "comma", "tab", "semicolon", or "space"... In the files I co...
by Albireo
24 Jun 2019, 16:49
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

...I would start with ComObjCreate("Excel.Application") in a AHK-script. requirement for this to work is an installed Excel version. I can only test with old version called "OFFICE11"... OK! I tell you what: I will write a test and come back with the result Great! Do you need to open Excel with the...
by Albireo
24 Jun 2019, 16:31
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

I've played a bit with the possible solutions and I want to add my contribute tho this thread. Some comments in the script. You can give it a try... I have try to run your script, with a CSV-file like this (with 65 rows) "100";"Test ";"200";"abcdef";"0";"0";"0";"9";"100";"0";;"0";"20170401";"0" "10...
by Albireo
24 Jun 2019, 14:12
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

...What is your threshold? how quickly do you need 35.000 x 72 cells? converted to Albireo's format and then converted to AHK-object? I could do some tests with some mock up data if you want. I suppose 2.5 million fields processed at 1 million per minute would be 2 and a half minutes? I have not do...
by Albireo
24 Jun 2019, 13:08
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

Thanks! StrVar = 302`t"Emelie" 125 "Erica"`t"174,50"`t"asd""`t""asd" ; StrVar = 302`t"Erica"`t"174,50"`t"asd" ; StrVar := "1,5;2,5;3,5;4,5;5,5;6,5;7,5;8,5;9" ; StrVar = 0,001; 0,002; 0,003; 0,004; 0,005; 0,006; 0,007; 0,008; 0,009 Delim := mostLikelyDelimiter(StrVar) MsgBox ,, Row %A_LineNumber% -> ...
by Albireo
24 Jun 2019, 13:05
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

how is this thought implemented, in my case? You can go back to the original data and try to find a way to produce consistent output from it, rejecting the "rumors" which do not pass the "entry-exam" to Albireo 's approved format. For example: suppose you have data in *.xls format. You would write ...
by Albireo
24 Jun 2019, 09:58
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

... that can produce rumours about Data . Those rumours are useless /difficult to process. Excuse me, but I still do not understand how to implement your ideas in my wish. Do you have access to the real/useful/original data ? I think so (what do you mean by "original data")? Some data comes from di...
by Albireo
23 Jun 2019, 16:45
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

...Do you have access to the original data? If so, and you can not force your program to use a consistent data-format, use some way of auto-identifying when saving... yes (or no) When data comes from one program, it is always delimited with comma, when data comes from another program it is always d...
by Albireo
23 Jun 2019, 09:50
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

My wish remains to be able to analyze the delimiter in CSV files. I think the structure/strategy of the PowerShell program would work well for me. It is right that today there are about 10 CSV files that are affected. These come from four different sources (some "," and some ";"). But if the handlin...
by Albireo
23 Jun 2019, 08:53
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

example for escaping the escape character: here I choose \ as escape character. To use it for User[3] see example: user, number, address James Bond, 007, London John\c the baptist, 001, Jerusalem Jack\c the ripper (\\Cartman), 666, Southpark Is the escape characters used in Excel / Calc? (and then ...
by Albireo
23 Jun 2019, 08:29
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

0,001; 0,002; 0,003 0,004; 0,005; 0,006 0,007; 0,008; 0,009 How do you decide? comma or semicolon? How do you decide automatically, when there is 3 sets of data one way, and 4 sets the other way? There is no automatic fool-proof way, as just me pointed out. I reply the same thing to you, as to just...
by Albireo
23 Jun 2019, 08:12
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

This is a valid CSV line: Line := "1,5;2,5;3,5;4,5;5,5;6,5;7,5;8,5;9" The field separator is semicolon ; and therefore commas , don't need to be "escaped". Which separator will your 'automatic analyzer' choose? Nice example ;) I have never encountered this type of information in my CSV-file (but it...
by Albireo
23 Jun 2019, 07:38
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

Thanks for your time! ... 1) every table is saved in Albireo 's approved format: The hardest thing to handle is, exported CSV files from Excel or Calc. Some of these files have come " , " as delimiters others have semicolon " ; " ... (something I can't change) Some field have have quotation marks an...
by Albireo
23 Jun 2019, 05:23
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Re: Translate PowerShell to AHK - possible?

... I don't think it will save you from "manual" reviewing the results.... why? (explain) My problem is to automatically analyze CSV files. The most of my CSV-files have the delimiter ";" or "," (but it happens the delimiter is a TAB) Managing a CSV file in AHK is much easier with "," as delimiter ...
by Albireo
22 Jun 2019, 17:22
Forum: Ask For Help
Topic: Translate PowerShell to AHK - possible?
Replies: 33
Views: 684

Translate PowerShell to AHK - possible?

Is it possible / complicated to translate a PowerShell script to AHK? I found a PowerShell function that automatic analyze which delimiter a CSV-file have, and my desire is to translate this program to AHK. (or write an AHK program that does the same) Some instructions do not seem so difficult to tr...

Go to advanced search