Input txt: 16XX27300 $ name John Doe 16XX27300 $ name2 Bla Bla 16XX27300 $ name3 275 Main ST 16XX27300 $ mlact 16H27300 16XX27300 $ addr 8TH Floor 16XX27300 $ city SAN Fran 16XX27300 $ state CA 16XX27300 $ zip 94111 16XX27301 $ name Jane Doe 16XX27301 $ name2 Bla Bla 16XX27301 $ name3 276 Main ST 16XX27301 $ name4 Tower 2 16XX27301 $ mlact 16XX27301 16XX27301 $ addr 8TH Floor 16XX27301 $ city SAN Fran 16XX27301 $ state CA 16XX27301 $ zip 94111 Desired Output: 16XX27300,$,John Doe,Bla Bla,275 Main ST,16H27300,8TH Floor,SAN Fran,CA,94111 16XX27301,$,Jane Doe,Bla Bla,276 Main ST,Tower 2,16XX27301,8TH Floor,SAN Fran,CA94111 I am assuming the best way to tackle this is to use a hash, however I stink at them. Any code examples to get me started would be appreciated.