T
toomanyjoes
Hi,
I just posted a message on deleting newline characters in perl.
I used this code to do that:
perl -pe "chomp;print $/ if $.>1 and /^\d/" file1 > file2
I ended up with a new text file in this format:
1sampletextsampletextsamplet22tsampletextsampletextsampletext
2sampletextsampletextsampletextsam56etextsampletextsampletext
3sampletextsampletextsampletextsampletextsampletextsampletext
8sampletextsampletextsampletex765mpletextsampletextsampletext
9sampletextsampletextsampletextsampletextsampletextsampletext
15sampletextsampletextsampletextsampletextsampletextsampletextsampletextsampletextsampletextsample324tsampletextsampletext
....
Now what I want is to add a delimiter inbetween the number at the
beginning of the line and the text. The number however could be any
number of digits long. So for instance if I use a "/" as a delimiter
the text would look like this.
1/sampletextsampletextsamplet22tsampletextsampletextsampletext
2/sampletextsampletextsampletextsam56etextsampletextsampletext
3/sampletextsampletextsampletextsampletextsampletextsampletext
8/sampletextsampletextsampletex765mpletextsampletextsampletext
9/sampletextsampletextsampletextsampletextsampletextsampletext
15/sampletextsampletextsampletextsampletextsampletextsampletextsampletextsampletextsampletextsample324tsampletextsampletext
This way I can go from a text file to Excel and then into a database.
Could anyone help me with this?
Thanks,
Joe
I just posted a message on deleting newline characters in perl.
I used this code to do that:
perl -pe "chomp;print $/ if $.>1 and /^\d/" file1 > file2
I ended up with a new text file in this format:
1sampletextsampletextsamplet22tsampletextsampletextsampletext
2sampletextsampletextsampletextsam56etextsampletextsampletext
3sampletextsampletextsampletextsampletextsampletextsampletext
8sampletextsampletextsampletex765mpletextsampletextsampletext
9sampletextsampletextsampletextsampletextsampletextsampletext
15sampletextsampletextsampletextsampletextsampletextsampletextsampletextsampletextsampletextsample324tsampletextsampletext
....
Now what I want is to add a delimiter inbetween the number at the
beginning of the line and the text. The number however could be any
number of digits long. So for instance if I use a "/" as a delimiter
the text would look like this.
1/sampletextsampletextsamplet22tsampletextsampletextsampletext
2/sampletextsampletextsampletextsam56etextsampletextsampletext
3/sampletextsampletextsampletextsampletextsampletextsampletext
8/sampletextsampletextsampletex765mpletextsampletextsampletext
9/sampletextsampletextsampletextsampletextsampletextsampletext
15/sampletextsampletextsampletextsampletextsampletextsampletextsampletextsampletextsampletextsample324tsampletextsampletext
This way I can go from a text file to Excel and then into a database.
Could anyone help me with this?
Thanks,
Joe