Hello
I was trying out the roo gem and encountered this issue. when i do a
object.sheets, it seems to spit out the array and adds \000 for every
letter of the sheet name
for eg.
currentTrade becomes c\000u\000r\000r\000e\000n\000t\000T\000r\000a
\000d\000e\000
which is the fastest way to remove \000 from the array.
irb(main):005:0> ss=Excel.new(“E:\Documents and Settings\TTSSR0149
\Desktop\orderingsystem.xls”)
Hello
I was trying out the roo gem and encountered this issue. when i do a
object.sheets, it seems to spit out the array and adds \000 for every
letter of the sheet name
for eg.
currentTrade becomes c\000u\000r\000r\000e\000n\000t\000T\000r\000a
\000d\000e\000
which is the fastest way to remove \000 from the array.
irb> s = “c\000u\000r\000r\000e\000n\000t\000T\000r\000a\000d\000e\000”
irb> n = “”
irb> s.unpack(“S*”).each {|c| n << c.chr}
=> [99, 117, 114, 114, 101, 110, 116, 84, 114, 97, 100, 101]
irb> n
=> “currentTrade”
irb(main):004:0>
It’s unicode - so you may use iconv to convert to whatever 8-bit
encoding you want.
If you want to have the ‘fastest’ one - compare it to other approaches
with Benchmark.
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.