Sign in to follow this  
Followers 0
BlueLord

Help with array

10 posts in this topic

Hy all,

I need a hint how to make a script which reade value from a file (*.csv) and create a new file with each value multiplied by x time ( in column)

Exemple:

File test.csv:

1

2

3

New file contain each value multiplied by 3 times:

1

1

1

2

2

2

3

3

3

Thanks

Share this post


Link to post
Share on other sites



Look at:

FileReadLine()

StringSplit()

For...Next

FileWriteLine or FileWrite

Read the line with filereadline, split it on the "," with StringSplit, create a loop that will write the value to a file with FileWriteLine 3 times per item in the line from the CSV file.


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites

Like this ?

$file1 = FileOpen ( "c:\test.csv", 0 )
$file2 = FileOpen ( "c:\Newtest.csv", 1 )

While 1
    $line = FileReadLine ( $file1 )
    If @error = -1 Then ExitLoop
    ConsoleWrite ( "Line read : " & $line & @Crlf )
    For $_I = 1 To 3
        FileWrite ( $file2, $line & @Crlf )
    Next
Wend

FileClose ( $file1 )
FileClose ( $file2 )
ShellExecute ( "c:\Newtest.csv" )

AutoIt 3.3.14.2 X86 - SciTE 3.6.0WIN 8.1 X64 - Other Example Scripts

Share this post


Link to post
Share on other sites

yes...

Thanks...

Share this post


Link to post
Share on other sites

Hy,

Where i'm got wrong?

I need to reset loop $i each time loop $j is incresing.

This is the result

Loopj1

......Loopi1

......Loopi2

......Loopi3

......Loopi4

......Loopi5

Loopj2

Loopj3

Loopj4

Loopj5

Loopj6

Loopj7

Loopj8

Loopj9

Loopj10

I need loop :Loopi1 to Loopi5 to appear in Loopj2 to Loopj10

I think i need to reset FileReadLine but i don't know how

$file1 = FileOpen ( "D:\test\test.csv", 0 )
$file2 = FileOpen ( "D:\test\test1.csv", 1 )

FDHYV()

Func FDHYV()


    For $j = 1 to 10

    ConsoleWrite ( "Loop" & $j & @Crlf )

                    For $i = 1 to 5
                        $line = FileReadLine ( $file1 )
                        If @error = -1 Then ExitLoop
                        ;ConsoleWrite ( "Line read : " & $line & @Crlf )
                        FileWrite ( $file2, $line & @Crlf )
                        ConsoleWrite ( "      Loop" & $i & @Crlf )
                    Next
    Next



EndFunc

FileClose ( $file1 )
FileClose ( $file2 )
ShellExecute ( "D:\test\test1.csv")

test.csv

1

2

3

4

5

Share this post


Link to post
Share on other sites

Be more clear ! Posted Image

It will be more easy if you show the new csv file content you want...


AutoIt 3.3.14.2 X86 - SciTE 3.6.0WIN 8.1 X64 - Other Example Scripts

Share this post


Link to post
Share on other sites

sorry....

i have this file test.txt with

1

2

3

in new file i need to copy the content of initial file 3 times in same order

1

2

3

1

2

3

1

2

3

Share this post


Link to post
Share on other sites

#8 ·  Posted (edited)

Your last post states something different than your first post... :unsure:

But ...

$s_orig = FileRead("input.csv")
$fh = FileOpen("output.csv", 1)
For $i = 1 To 5
    FileWrite($fh, $s_orig)
Next
FileClose($fh)

Okay?

:>

Edited by Hannes123

Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler]

Share this post


Link to post
Share on other sites

Your last post states something different than your first post... :unsure:

But ...

$s_orig = FileRead("input.csv")
$fh = FileOpen("output.csv", 1)
For $i = 1 To 5
    FileWrite($fh, $s_orig)
Next
FileClose($fh)

Okay?

:>

He said 3 times...

AutoIt 3.3.14.2 X86 - SciTE 3.6.0WIN 8.1 X64 - Other Example Scripts

Share this post


Link to post
Share on other sites

yes! it's ok

thanks.

three times was like exemple :unsure:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0