3 small systems
$10-30 USD
착불
System A
I have this db:
|column1 |column2 |column3 |column4 |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|K |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
|somedata|G |somedata| |
etc.
And this list of words:
word1
word2
word3
etc...
word50
word51
word52
I need a script that change data from column4 to words from list (ordered) of words as follows:
Wrote first word1 from list each time on column2 has first data unchanged.
When data on column2 changes system will wrote on column4 word2 while data on column2 unchanged.
Thus when dta on colum2 again changes system will wrote column4 with word3 while data on column2 unchanged.
Data on column2 ony has two possible data, K and G sometimes alternating.
System will continue writting data on column2 till the end of list of words, thus will begin list of words again and again, every time taking words on list ordered.
---
System B
I have this db:
|column1 |column2 |column3 |column4 |
|somedata|somedata|data4 | |
|somedata|somedata|data5 | |
|somedata|somedata|data6 | |
etc...
|somedata|somedata|data28 | |
|somedata|somedata|data29 | |
|somedata|somedata|data29 | Si|
|somedata|somedata|data30 | |
|somedata|somedata|data1 | |
|somedata|somedata|data2 | |
|somedata|somedata|data3 | |
|somedata|somedata|data4 | Si|
|somedata|somedata|data6 | |
|somedata|somedata|data7 | |
|somedata|somedata|data8 | |
|somedata|somedata|data9 | |
etc...
and this list of data sequence:
data1
data2
data3
etc...
data28
data29
data30
I need a script that compare data sequence with column3, when one dataN is missed need to save on column4 the word "Si".
Also when on column3 data repeats on inmediate row word "Si" on second row, column4 will be added.
as example on column4.
data11 and data26 could be named in 2 different ways, when no repeat will be used second listed way to name it.
data11 and data26 could be named in 2 different ways, when repeats usually first way is used on first row ant the other on second row.
When data sequence finishes, it will begin again, and again, till finish analysis of database entries.
---
System C
I have this db:
|column1 |column2 |column3 |
|somedata|somedata|data4 |
|somedata|somedata|data5 |
|somedata|somedata|data6 |
etc...
|somedata|somedata|data28 |
|somedata|somedata|data29 |
|somedata|Fast |data29 |
|somedata|somedata|data30 |
|somedata|somedata|data1 |
|somedata|somedata|data2 |
|somedata|somedata|data3 |
|somedata|somedata|data4 |
|somedata|somedata|data6 |
|somedata|Fast |data7 |
|somedata|somedata|data8 |
|somedata|somedata|data9 |
I need a script that each time column2 has word "Fast", nex row entry on same column2 need to be changed to "Breakfast".
That's all.
---
프로젝트 ID: #30249325
프로젝트 소개
수상자:
I have checked 3 scenarios which you mentioned. I will do this task surely. Give me chance. I will show you good result. Thanks
이 일자리에 대한 프리랜서 6 명의 평균 입찰가: $32
HELLO DEAR I am Mithlesh Mandal I am not alone here we work as a team so no worries about submission date. After looking my profile if you think I am capable to work with your project then text me down.
I will summarize all the requirements and provide you with clear, concise notes. I am a post graduated student. can deliver quality work to tight deadlines. I can generally compile up to 10 pages of lecture notes p 기타
