• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

Splitting a text file into seperate text files.

I get a text file with a long list of filenames that looks like this:

a52372,CH-A-00-00-02-00A-040A-A
a58758,CH-A-00-00-03-00A-012B-A
a58759,CH-A-00-00-03-00A-012B-A
a58760,CH-A-00-00-03-00A-012B-A
a65855,CH-A-06-40-00-00A-010A-A
a58883,CH-A-06-40-01-00A-540A-A
a58884,CH-A-06-40-01-00A-540A-A
a65855,CH-A-06-40-01-00A-540A-A
a62128,CH-A-06-40-01-00A-540A-A
a65817,CH-A-08-40-00-00A-030A-A
a65818,CH-A-08-40-00-00A-030A-A
a53077,CH-A-08-40-00-00A-030A-A

I need to be able to send all the files with CH-A-00 to one file and CH-A-06 to another and CH-A-08 to another and so on. The number in the 13th and 14th position determines what file they need to go. I can't grep those positions because they change and I never know what they're going to be. The letters in front of those postions change to.

Is there a way to cut that number out and save it to a variable then use the variable in a for loop or if statement then goto the next line?

jas
0
scuzz1
Asked:
scuzz1
  • 3
  • 2
1 Solution
 
mnashadkaCommented:
Maybe you could try a ksh script something like this:

#!/bin/ksh

while read line ; do
  print $line
  file=`print $line | awk '{ print substr($0,13,2) }'`
  print $file
  print $line >> $file
 done<file.txt
0
 
scuzz1Author Commented:
That looks like what I want to do but where do you tell it what file it is reading from?
0
 
scuzz1Author Commented:
Never mind the last comment. I figured it out. I'm going to try to work in the textfiles I need. I think this will work.
0
 
scuzz1Author Commented:
Excellent. I was really stuck. I couldn't get the thing to slow down and read the file one line at a time.

Thanks much,

jas
0
 
mnashadkaCommented:
You're welcome.  Just glad I could help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now