Copy a row of csv file

Discuss RoboTask here
jee-hoon
Posts: 7
Joined: Fri Sep 08, 2006 12:58 am
Location: Canada

Copy a row of csv file

Post by jee-hoon »

Hi,
I would like to copy a row from csv file to an another csv file. I see in this forum a task to copy some lines from csv file...but anything about rows.
my task must select all the row or select a range (row) and export to another csv file.
thanks for your help
Last edited by jee-hoon on Fri Sep 08, 2006 10:20 am, edited 1 time in total.
Oleg
Site Admin
Posts: 3014
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Copy a row of csv file

Post by Oleg »

The row of CSV file is a whole line of text file. (CSV file has text format).

Or, maybe, did you mean something another?
Your original message was about columns. So, rows or columns?
jee-hoon
Posts: 7
Joined: Fri Sep 08, 2006 12:58 am
Location: Canada

Copy a row of csv file

Post by jee-hoon »

An exemple :
I would like to copy in another csv file , the column A5:A15 (first file) to F7:F17 in another file.
 
Sorry for my english...i'm quite bad...but I'll try to do my best
Last edited by jee-hoon on Mon Sep 11, 2006 6:48 am, edited 1 time in total.
jee-hoon
Posts: 7
Joined: Fri Sep 08, 2006 12:58 am
Location: Canada

Copy a row of csv file

Post by jee-hoon »

For Oleg :
Rows or columns, both interests me much
jee-hoon
Posts: 7
Joined: Fri Sep 08, 2006 12:58 am
Location: Canada

Copy a row of csv file

Post by jee-hoon »

I want to copy a range of the data being from a column and to copy them in another file.
like that : column C (file 1) to column F (file 2)
more harder : Column C3 to C13 (file 1) to Column F5 to F15 (file 2)
Thank you for people who seek a solution for me
Oleg
Site Admin
Posts: 3014
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Copy a row of csv file

Post by Oleg »

See the following example.
This task exports rectangular area from source.csv to new csv file.
Area coordinates are A5:F15 (as in Excel). In another words we should export data in lines from 4 to 14 and in columns from 0 to 5. Counter of lines and columns begins from 0

BTW: you can find more examples here.

Save the task into file and use menu "Task | Import" to import into RoboTask
Oleg
Site Admin
Posts: 3014
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Copy a row of csv file

Post by Oleg »

like that : column C (file 1) to column F (file 2)
more harder : Column C3 to C13 (file 1) to Column F5 to F15 (file 2)
Does file2 contain the some data or is it a new file? In first case you should replace data in file2.
jee-hoon
Posts: 7
Joined: Fri Sep 08, 2006 12:58 am
Location: Canada

Copy a row of csv file

Post by jee-hoon »

In the first file (contain data) and the second file is empty
jee-hoon
Posts: 7
Joined: Fri Sep 08, 2006 12:58 am
Location: Canada

Copy a row of csv file

Post by jee-hoon »

thanks for "tsk" link
Oleg
Site Admin
Posts: 3014
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Copy a row of csv file

Post by Oleg »

more harder : Column C3 to C13 (file 1) to Column F5 to F15 (file 2)
Ok, see another task. It copies data from C3:C13 to F5:F15
Post Reply