.csv data replacing

dikkill

Client
Регистрация
12.02.2013
Сообщения
52
Благодарностей
2
Баллы
8
Hi,

I have a question about .csv data scraping. I have a .csv file, and in it are 2 columns.
The fist collum is where i take the data, do some stuff and after that a number end up.
That number needs to be in the second column but in the same row as the data that was taken.

I mainly want to update the second column, and leave the first column as it is, save the file and proceed. How can i do that?

So the steps need to be done is to take the first number in this example 7247000 do the process and update the column B next to the data scraped (1).
 

Вложения

rostonix

Известная личность
Регистрация
23.12.2011
Сообщения
29 067
Благодарностей
5 715
Баллы
113
use counter as number of line and operate with actions Take line and Add row
 

dikkill

Client
Регистрация
12.02.2013
Сообщения
52
Благодарностей
2
Баллы
8
Never tried something like this, will try. How about this issue? My .csv file is comma separated, but once loaded in zenno, it doesn't form it as it should.
Any idea?
 

Вложения

rostonix

Известная личность
Регистрация
23.12.2011
Сообщения
29 067
Благодарностей
5 715
Баллы
113
Standard delimeter for excel tables is Tab.
If you use comma, you need to use "Own format"
 

dikkill

Client
Регистрация
12.02.2013
Сообщения
52
Благодарностей
2
Баллы
8

Вложения

rostonix

Известная личность
Регистрация
23.12.2011
Сообщения
29 067
Благодарностей
5 715
Баллы
113
You can store data in txt with comma as delimeter or use excel table with tabs as delimeter
 
  • Спасибо
Реакции: globalledstore

Кто просматривает тему: (Всего: 3, Пользователи: 0, Гости: 3)