Group several lines into one line

[Dirk Dre]

After sitting at this problem for hours without much progress, now is
the time that I need your help. Btw. I'm quite new to ruby.

I have a file that looks like this:

00-04-00;Austragungssystem für längliche oder
00-04-00;quadratische Lagerräume inklusive 3-
00-04-00;poligen Wielandstecker/Gegenstecker
00-04-00;Technische Daten:
00-04-00;Elektrischer Anschluss: 230V / 50Hz
00002274;Wilo Temperaturfühler TF
00002274;Temperaturschalter mit Einstellknopf
00002274;einschließlich 2 Stück Federspannbändern
00002274;zum Anlegen an Rohre bis DN 100.
00002274;Max. Betriebsspannung: 250 V
00002274;Max. Schaltleistung: 4 A
00002274;Schutzart: IP 43
00002274;Schaltbereich: 30 oC bis 90 oC
00002274;Fabrikat: WILO
00002274;Typ: Temperaturschalter TF

what i need is to group lines with the same serialnumber
(eg. 00-04-00, 00002274) into one line like this:

00-04-00;Austragungssystem für längliche oder quadratische Lagerräume
inklusive 3-poligen Wielandstecker/Gegenstecker Technische Daten:
Elektrischer Anschluss: 230V / 50Hz

I need several lines combined to one line with the matching serialnumber
in front.

I searched for several hours on the internet and in several forums.
Maybe I was looking for the wrong search terms. But I'm at a loss here.

Thanks in advance.

 

[Michael Furmaniuk]

I need several lines combined to one line with the matching serialnumber
in front.

I'm not good at coming up with the code examples off the top of my head
but maybe a regex matching the serial numbers and then a split to pull
off the portion you want then combining the matched portion.

 

[Jesús Gabriel y Galán]

After sitting at this problem for hours without much progress, now is
the time that I need your help. Btw. I'm quite new to ruby.

I have a file that looks like this:

00-04-00;Austragungssystem f=FCr l=E4ngliche oder
00-04-00;quadratische Lagerr=E4ume inklusive 3-
00-04-00;poligen Wielandstecker/Gegenstecker
00-04-00;Technische Daten:
00-04-00;Elektrischer Anschluss: 230V / 50Hz
00002274;Wilo Temperaturf=FChler TF
00002274;Temperaturschalter mit Einstellknopf
00002274;einschlie=DFlich 2 St=FCck Federspannb=E4ndern
00002274;zum Anlegen an Rohre bis DN 100.
00002274;Max. Betriebsspannung: 250 V
00002274;Max. Schaltleistung: 4 A
00002274;Schutzart: IP 43
00002274;Schaltbereich: 30 oC bis 90 oC
00002274;Fabrikat: WILO
00002274;Typ: Temperaturschalter TF

what i need is to group lines with the same serialnumber
(eg. 00-04-00, 00002274) into one line like this:

00-04-00;Austragungssystem f=FCr l=E4ngliche oder quadratische Lagerr=E4u= me
inklusive 3-poligen Wielandstecker/Gegenstecker Technische Daten:
Elektrischer Anschluss: 230V / 50Hz

Something like this (untested) might get you started:

s =3D "00-40..." #your string
h =3D Hash.new {|h,k| h[k] =3D ""}
s.each do |line|
key, value =3D line.split(";")
h[key] << value.chomp
end

This will give you a hash where the keys are the serial numbers and
the values, the concatenated parts that correspond to that serial
number.

Jesus.

 

[Joel VanderWerf]

After sitting at this problem for hours without much progress, now is
the time that I need your help. Btw. I'm quite new to ruby.

I have a file that looks like this:

00-04-00;Austragungssystem für längliche oder
00-04-00;quadratische Lagerräume inklusive 3-
00-04-00;poligen Wielandstecker/Gegenstecker
00-04-00;Technische Daten:
00-04-00;Elektrischer Anschluss: 230V / 50Hz
00002274;Wilo Temperaturfühler TF
00002274;Temperaturschalter mit Einstellknopf
00002274;einschließlich 2 Stück Federspannbändern
00002274;zum Anlegen an Rohre bis DN 100.
00002274;Max. Betriebsspannung: 250 V
00002274;Max. Schaltleistung: 4 A
00002274;Schutzart: IP 43
00002274;Schaltbereich: 30 oC bis 90 oC
00002274;Fabrikat: WILO
00002274;Typ: Temperaturschalter TF

what i need is to group lines with the same serialnumber
(eg. 00-04-00, 00002274) into one line like this:

00-04-00;Austragungssystem für längliche oder quadratische Lagerräume
inklusive 3-poligen Wielandstecker/Gegenstecker Technische Daten:
Elektrischer Anschluss: 230V / 50Hz

Something like this (untested) might get you started:

s = "00-40..." #your string
h = Hash.new {|h,k| h[k] = ""}
s.each do |line|
key, value = line.split(";")
h[key] << value.chomp
end

That won't quite work if there is a second semicolon on the line. Try:

key, value = line.scan(/([^;]*);(.*)/).first

 

[Rob Biedenharn]

After sitting at this problem for hours without much progress, now is
the time that I need your help. Btw. I'm quite new to ruby.

I have a file that looks like this:

00-04-00;Austragungssystem f=FCr l=E4ngliche oder
00-04-00;quadratische Lagerr=E4ume inklusive 3-
00-04-00;poligen Wielandstecker/Gegenstecker
00-04-00;Technische Daten:
00-04-00;Elektrischer Anschluss: 230V / 50Hz
00002274;Wilo Temperaturf=FChler TF
00002274;Temperaturschalter mit Einstellknopf
00002274;einschlie=DFlich 2 St=FCck Federspannb=E4ndern
00002274;zum Anlegen an Rohre bis DN 100.
00002274;Max. Betriebsspannung: 250 V
00002274;Max. Schaltleistung: 4 A
00002274;Schutzart: IP 43
00002274;Schaltbereich: 30 oC bis 90 oC
00002274;Fabrikat: WILO
00002274;Typ: Temperaturschalter TF

what i need is to group lines with the same serialnumber
(eg. 00-04-00, 00002274) into one line like this:

00-04-00;Austragungssystem f=FCr l=E4ngliche oder quadratische = Lagerr=E4ume
inklusive 3-poligen Wielandstecker/Gegenstecker Technische Daten:
Elektrischer Anschluss: 230V / 50Hz

Something like this (untested) might get you started:

s =3D "00-40..." #your string
h =3D Hash.new {|h,k| h[k] =3D ""}
s.each do |line|
key, value =3D line.split(";")
h[key] << value.chomp
end

This will give you a hash where the keys are the serial numbers and
the values, the concatenated parts that correspond to that serial
number.

Jesus.

current_serial =3D nil
texts =3D []
File.open(outputfilename, 'w') do |out|
File.foreach(filename) do |line|
serial, text =3D line.chomp.split(';', 2)
if current_serial && serial !=3D current_serial
out.puts "#{current_serial};#{texts.join(' ')}"
texts =3D []
end
current_serial =3D serial
texts << text
end
if current_serial
out.puts "#{current_serial};#{texts.join(' ')}"
end
end

Two things of note: The second argument to split(';', 2) limits the =20
result to 2 items so if there happens to be a ';' later in the line it =20=

isn't considered a place to split. Keeping the items in a hash =20
doesn't guarantee the order on the way back out, but I'm also assuming =20=

that all the lines with a given serial number are together.

You have to initialize your filename and outputfilename, of course.
-Rob

Rob Biedenharn http://agileconsultingllc.com
(e-mail address removed)

 

[Dirk Dre]

Thanks a lot to all.

Rob,
your solution works like a charme.

Now i'll just do some heavy commenting, to understand it all and for
reference.

 

[Robert Schaaf]

The desired output cannot be achieved unless your log preserves =20
trailing spaces. Thus:

00002274;Temperaturschalter mit Einstellknopfeinschlie=DFlich 2 St=FCck =20=

Federspannb=E4ndernzum Anlegen an Rohre bis DN 100.Max. =20
Betriebsspannung: 250 VMax. Schaltleistung: 4 ASchutzart: IP =20
43Schaltbereich: 30 oC bis 90 oCFabrikat: WILOTyp: Temperaturschalter TF

My suggestion is to pad with a space unless the line ends in a hyphen.

Picayune perhaps, but aesthetics (readability) counts.

Bob Schaaf

After sitting at this problem for hours without much progress, now =20=
is
the time that I need your help. Btw. I'm quite new to ruby.

I have a file that looks like this:

00-04-00;Austragungssystem f=FCr l=E4ngliche oder
00-04-00;quadratische Lagerr=E4ume inklusive 3-
00-04-00;poligen Wielandstecker/Gegenstecker
00-04-00;Technische Daten:
00-04-00;Elektrischer Anschluss: 230V / 50Hz
00002274;Wilo Temperaturf=FChler TF
00002274;Temperaturschalter mit Einstellknopf
00002274;einschlie=DFlich 2 St=FCck Federspannb=E4ndern
00002274;zum Anlegen an Rohre bis DN 100.
00002274;Max. Betriebsspannung: 250 V
00002274;Max. Schaltleistung: 4 A
00002274;Schutzart: IP 43
00002274;Schaltbereich: 30 oC bis 90 oC
00002274;Fabrikat: WILO
00002274;Typ: Temperaturschalter TF

what i need is to group lines with the same serialnumber
(eg. 00-04-00, 00002274) into one line like this:

00-04-00;Austragungssystem f=FCr l=E4ngliche oder quadratische =20
Lagerr=E4ume
inklusive 3-poligen Wielandstecker/Gegenstecker Technische Daten:
Elektrischer Anschluss: 230V / 50Hz

Something like this (untested) might get you started:

s =3D "00-40..." #your string
h =3D Hash.new {|h,k| h[k] =3D ""}
s.each do |line|
key, value =3D line.split(";")
h[key] << value.chomp
end

This will give you a hash where the keys are the serial numbers and
the values, the concatenated parts that correspond to that serial
number.

Jesus.

current_serial =3D nil
texts =3D []
File.open(outputfilename, 'w') do |out|
File.foreach(filename) do |line|
serial, text =3D line.chomp.split(';', 2)
if current_serial && serial !=3D current_serial
out.puts "#{current_serial};#{texts.join(' ')}"
texts =3D []
end
current_serial =3D serial
texts << text
end
if current_serial
out.puts "#{current_serial};#{texts.join(' ')}"
end
end

Two things of note: The second argument to split(';', 2) limits the =20=