combine 2 csv files

[rice1973]

Hi Oleg,

I have to csv files.

Example;

file1.csv;

"12323","nice","good",
"31245","not nice,""not good",

file2.csv;

"weather","water","fire"
"nice weahter","dry","wet"

output must be like;

"12323","nice","good","weather","water","fire"
"31245","not nice,""not good","nice weahter","dry","wet"

[userXXX]

Maybe this works for you:

Code: Select all

;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
 
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|347244376
Comment=STRINGLIST
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task37"
Hide=INTEGER|0
ID=INTEGER|1278379756
LocalVariables=STRING|"L_FILE1=,L_FILE2=,L_OUT=,L_ROW_FILE1=,L_ROW_FILE2=,L_ROWCNT=,L_ROWNUM=1,L_TMP_DIR=C:\temp"
LogOnAsUser=INTEGER|1
Name=STRING|"combine 2 csv files"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
WriteGeneralLog=INTEGER|0

[Actions]
Action1=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
Action5=FOLDER
Action6=FOLDER
Action7=FOLDER
Action8=FOLDER
Action9=FOLDER

[Actions\Action1]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""L_FILE1"" with value ""{L_TMP_DIR}\file1.csv"""
Params=FOLDER

[Actions\Action1\Params]
expand=STRING|"1"
varname=STRING|"L_FILE1"
varvalue=STRING|"{L_TMP_DIR}\file1.csv"

[Actions\Action2]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""L_FILE2"" with value ""{L_TMP_DIR}\file2.csv"""
Params=FOLDER

[Actions\Action2\Params]
expand=STRING|"1"
varname=STRING|"L_FILE2"
varvalue=STRING|"{L_TMP_DIR}\file2.csv"

[Actions\Action3]
ActionID=STRING|"A_TXT_NUMBEROFLINES"
Enabled=INTEGER|-1
Name=STRING|"TXT Number of Lines"
Params=FOLDER

[Actions\Action3\Params]
external=STRING|"1"
filename=STRING|"{L_FILE1}"
linecount=STRING|"0"
variable=STRING|"L_ROWCNT"

[Actions\Action4]
ActionID=STRING|"A_LOOP_SIMPLE"
Enabled=INTEGER|-1
Name=STRING|"Simple Loop"
Params=FOLDER

[Actions\Action4\Params]
begin=STRING|"1"
end=STRING|"{L_ROWCNT}"
variable=STRING|"L_ROWNUM"

[Actions\Action5]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER

[Actions\Action5\Params]
external=STRING|"1"
filename=STRING|"{L_FILE1}"
linecount=STRING|"0"
linenum=STRING|"{L_ROWNUM}"
variable=STRING|"L_ROW_FILE1"

[Actions\Action6]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER

[Actions\Action6\Params]
external=STRING|"1"
filename=STRING|"{L_FILE2}"
linecount=STRING|"0"
linenum=STRING|"{L_ROWNUM}"
variable=STRING|"L_ROW_FILE2"

[Actions\Action7]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""L_OUT"" with value ""{L_OUT}{L_ROW_FILE1}{L_ROW_FILE2}{EOL}"""
Params=FOLDER

[Actions\Action7\Params]
expand=STRING|"1"
varname=STRING|"L_OUT"
varvalue=STRING|"{L_OUT}{L_ROW_FILE1}{L_ROW_FILE2}{EOL}"

[Actions\Action8]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"

[Actions\Action9]
ActionID=STRING|"A_FILE_TEXTWRITE"
Enabled=INTEGER|-1
Name=STRING|"Create text file {L_TMP_DIR}\combination.csv"
Params=FOLDER

[Actions\Action9\Params]
encode=STRING|"0"
fileexists=STRING|"0"
filname=STRING|"{L_TMP_DIR}\combination.csv"
line0=STRING|"{L_OUT}"
linecount=STRING|"1"
suppress=STRING|"1"

[Oleg]

You forgot the comma in the step #7
you have to use expression:
{L_OUT}{L_ROW_FILE1},{L_ROW_FILE2}{EOL}

[userXXX]

You forgot the comma in the step #7

Yes, because it's already included in file1.csv of his example.

[Oleg]

Yes, because it's already included in file1.csv of his example.

Exactly