Join columns of different files using notepad
-
Good evening friends, I hope you can, I need to join two columns, the first file is for example:
abdd:
125:
dfghx:
and the other file:
shaunt
peacl1
franki
and I need to join them
abdd: shaunt
125: peacl1
dfghx: franki
the archives have the same number of lines (4000), I hope they help me -
-
with code regex?
-
replace double space with single space
-
-
nothing friends
-
did you read the link I’ve posted?
And if it doesn’t work, explain what you see. -
125:fzpYeX Qs267g lbROJ lbROJ lbROJ vrQdO9 Qs267g lbROJ vrQdO9 Qs267g Qs267g lbROJ SquJi Qs267g Qs267g Qs267g lbROJ lbROJ lbROJ lbROJ lbROJ lbROJ lbROJ fzpYeX Qs267g Qs267g lbROJ lbROJ Qs267g Qs267g lbROJ lbROJ lbROJ lbROJ lbROJ
-
replace
\s
with\r\n
125:fzpYeX
Qs267g
lbROJ
lbROJ
lbROJ
vrQdO9
Qs267g
lbROJ
vrQdO9
Qs267g
Qs267g
lbROJ
SquJi
Qs267g
Qs267g
Qs267g
lbROJ
lbROJ
lbROJ
lbROJ
lbROJ
lbROJ
lbROJ
fzpYeX
Qs267g
Qs267g
lbROJ
lbROJ
Qs267g
Qs267g
lbROJ
lbROJ
lbROJ
lbROJ
lbROJ -
is an example, friend is more than 4000 lines
-
@sakijhon said:
is an example, friend is more than 4000 lines
you are just given example it will work
replace \s with \r\n -
@gurikbal-singh said:
125:fzpYeX
the lines always start with the same
125:fzpYeX
Qs267g
lbROJ
lbROJ
lbROJ
vrQdO9
Qs267g
lbROJ
vrQdO9
Qs267g
Qs267g
lbROJ
SquJi
Qs267g
Qs267g
Qs267g
lbROJ
lbROJ
lbROJ
lbROJ
lbROJ
lbROJ
lbROJ
fzpYeX
Qs267g
Qs267g
lbROJ
lbROJ
Qs267g
Qs267g
lbROJ
lbROJ
lbROJ
lbROJ
lbROJ
abdd:fzpYeX
Qs267g
lbROJ
lbROJ
lbROJ
vrQdO9
Qs267g
lbROJ
vrQdO9
Qs267g
…
…nothing friend, the same lines and the other lines nothing, well thanks anyway, I will continue to investigate
-
@sakijhon said:
125:fzpYeX
now raplace
125: with 125:/r/n
if you are use 64bit npp use big files plugin