Solved

Splitting a text file into seperate text files.

Posted on 2001-06-26
5
184 Views
Last Modified: 2010-04-21
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
Comment
Question by:scuzz1
  • 3
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
mnashadka earned 100 total points
ID: 6228696
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
 

Author Comment

by:scuzz1
ID: 6228806
That looks like what I want to do but where do you tell it what file it is reading from?
0
 

Author Comment

by:scuzz1
ID: 6228825
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
 

Author Comment

by:scuzz1
ID: 6228914
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
 
LVL 8

Expert Comment

by:mnashadka
ID: 6229527
You're welcome.  Just glad I could help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (http://www.experts-exchange.com/OS/Unix/BSD/FreeBSD/A_3660-S…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

939 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now