|
|
|
|
|||||||
| Forums | Portal | Register | Rules & FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| unix awk/sed program | mnnarendra | UNIX for Advanced & Expert Users | 4 | 03-26-2008 06:00 AM |
| UNIX program? | threewingedfury | UNIX for Dummies Questions & Answers | 1 | 02-05-2008 11:15 AM |
| How do i run a program while in Unix?.... | Corrail | UNIX for Dummies Questions & Answers | 4 | 10-31-2005 10:51 AM |
| looking for a unix C program...help please | richardspence2 | UNIX for Advanced & Expert Users | 3 | 03-15-2004 08:14 PM |
| running a c/c++ program in unix | kray | High Level Programming | 2 | 07-12-2002 12:25 AM |
 |
|
|
LinkBack | Thread Tools | Display Modes |
02-21-2005
|
|||
|
|||
|
Help with UNIX Program
I am trying to set up a file for someone and they have a program that was built for UNIX. I am guessing that it is running in some sort of emulator since they are on WinXP. It is a database and we are trying to get all of the addresses out of the database. I talked to the tech support for the software, and if I understood them correctly, this is all that can be done.
The data can be outputted to a file (.tmp I believe) and then the information can be saved out to something else. The problem is that it won't be delimited. It will just be one long string of text according to the tech support. Does anyone have any ideas on what I could do to get this in a usable format. The database is about 6000 names, so if you figure that by about 6 pieces of information per name, there is no way that we can go in and physically delimit it. In case your wondering, the program was written in the early 80's. The new version will output to databbase files, but the upgrade is 100,000 and they aren't willing to do that. Help. 
|
| Forum Sponsor | ||
|
|
|
02-21-2005
|
|||
|
|||
|
Well, I will know more tomorrow. I was basically asking if something like this is possible. If it is what has been explained to me, the data has a fixed number of characters for each field. It can be comma or tab delimited, but I would prefer tab. Once I actually get the file, I'll post some info.
|
|
02-25-2005
|
|||
|
|||
|
Ok. Here is a sample of the file I am working with. Turns out, it did format the text, it just isn't the format we need.
What I need is a spreadsheet with the name in one column, the address line in one column and the city, state, zip in another column. I don't think this is a Unix problem to solve, but more of an excel issue. Maybe a macro to move the information? I also need it to clean out all the blank lines. The sample is attached to this.
|
|
02-25-2005
|
||||
|
||||
|
Quote:
Assumptions:
attached is a the output based on your sample input. nawk -f brand.awk samplefile.txt brand.awk: Code:
BEGIN {
OFS="|"
CLMN=2
WDTH=34
}
#------------------------------------------------------------------------
#
function trim(str)
{
sub("^[ \t]*", "", str);
sub("[ \t]*$", "", str);
return str;
}
#------------------------------------------------------------------------
#
pivot == 3 {
for(i=1; i <= CLMN; i++)
for(j=1; j <= pivot; j++) {
split(arr[j], tmpA, SUBSEP)
printf("%s%s", tmpA[i], (j < pivot) ? OFS : "\n");
}
pivot=0
}
!NF { pivot=0; next}
{
pivot++
arr[pivot] = trim(substr($0, 1, WDTH-1)) SUBSEP trim(substr($0, WDTH))
}
|
Linear Mode
