[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

I have a weird problem I need help with. I have a file with...

<< Back to: sed FAQ, version 014

Question by eduo
Submitted on 6/7/2004
Related FAQ: sed FAQ, version 014
Rating: Not yet rated Rate this question: Vote
I have a weird problem I need help with. I have a file with several thousand lines of separated data I need to convert to one data item per line. Can anyone help with a sample script?

My file has data lines of this kind:
Where SP can be either SP, AT, DE or DA and then twelve fields of data. Each of the fields has two values which need to be separated (the one before the comma is the A value and the one after the comma is the V value). I need the data to be laid out with one data field per line with an additional field for column number at the beginning and separated by tabs. The first three fields in the above line would look like this in the finished document:


Can anyone help me with this? Plis? If possible answer to eduo@mac.com, although I'll be checking back here.


Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.


FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.


<< Back to: sed FAQ, version 014

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

© 2008 FAQS.ORG. All rights reserved.