Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Split long record into csv file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Split long record into csv file
# 8  
Old 05-07-2009
I'm on AIX, so don't have the xpg4/awk version available. nawk seems to have the same 399 character limit.
Would it be possible to set up FIELDWIDTHS as an array? (in other words, set up the FWS variable directly instead of through split). Are there limits to array sizes as well?
# 9  
Old 05-07-2009
Quote:
Originally Posted by wvdeijk
I'm on AIX, so don't have the xpg4/awk version available. nawk seems to have the same 399 character limit.
Would it be possible to set up FIELDWIDTHS as an array? (in other words, set up the FWS variable directly instead of through split). Are there limits to array sizes as well?
Hm.......hate those artificial limits.
Sure, you can set the array directly, it's just tedious and not very nice to look at.
Code:
FIELDWIDTHS="1 3 8 8 5 9 1 9" # for example

#would translate into

FWS[1]=1
FWS[1]=3
FWS[1]=8
FWS[1]=8
FWS[1]=5
FWS[1]=9
FWS[1]=1
FWS[1]=9

Another thing you can try is pass the FIELDWIDTH verable on the 'awk command line (commenting out the hard-coded one in the script) - like so
Code:
awk -v FIELDWIDTH='1 3 8 8 5 9 1 9' -f myAWKscript myFile2process

but I bet the result will be the same - doesn't hurt to try.
# 10  
Old 05-07-2009
Thanks. As you say, that wouldn't look very nice. I tried to be a bit creative, and it actually workedSmilie

Code:
  
FIELDWIDTHS1="8 8 18 1 15 6 10 1 8 1 1 3 12 7 9 10 8 2 2 4 8 10 3 2 1 3 3 2 2 3 2 5 1 2 2 1 9 2 3 12 1 1 12 1 2 3 7 2 8 1 2 8 4 6 4 4 4 4 4 4 4 4 4 4 4 4 9 12 9 10 1 8 1 2 2 2 1 1 1 1 1 4 2 5 8 1 2 1 1 1 4 12 12 13 1 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 3 3 3 3 3 3 3 8 10 14 12 8 2 2 13 8 8 12 12 12 12 12 1 6 12 12 12 10 3 2 11 10 1 13 10"
  FIELDWIDTHS2=" 1 2 6 6 6 5 5 5 1 13 1 1 1 7 9 13 13 29" # for example

This created 2 variables, both under the 399 character limit.

Then, in the setFieldsBy Width function
Code:
  n = split(FIELDWIDTHS1 FIELDWIDTHS2,FWS)

Thanks for your help.
# 11  
Old 05-07-2009
Quote:
Originally Posted by wvdeijk
Thanks. As you say, that wouldn't look very nice. I tried to be a bit creative, and it actually workedSmilie

Code:
  
FIELDWIDTHS1="8 8 18 1 15 6 10 1 8 1 1 3 12 7 9 10 8 2 2 4 8 10 3 2 1 3 3 2 2 3 2 5 1 2 2 1 9 2 3 12 1 1 12 1 2 3 7 2 8 1 2 8 4 6 4 4 4 4 4 4 4 4 4 4 4 4 9 12 9 10 1 8 1 2 2 2 1 1 1 1 1 4 2 5 8 1 2 1 1 1 4 12 12 13 1 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 4 13 12 3 3 3 3 3 3 3 8 10 14 12 8 2 2 13 8 8 12 12 12 12 12 1 6 12 12 12 10 3 2 11 10 1 13 10"
  FIELDWIDTHS2=" 1 2 6 6 6 5 5 5 1 13 1 1 1 7 9 13 13 29" # for example

This created 2 variables, both under the 399 character limit.

Then, in the setFieldsBy Width function
Code:
  n = split(FIELDWIDTHS1 FIELDWIDTHS2,FWS)

Thanks for your help.
Ah........ that's a GREAT idea - it totally escaped my mind.
Good thinking!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

How to split large file with different record delimiter?

Hi, I have received a file which is 20 GB. We would like to split the file into 4 equal parts and process it to avoid memory issues. If the record delimiter is unix new line, I could use split command either with option l or b. The problem is that the line terminator is |##| How to use... (5 Replies)
Discussion started by: Ravi.K
5 Replies

2. Shell Programming and Scripting

EBCDIC File Split Based On Record Key

I was wondering if anyone could explain to me how to split a variable length EBCDIC file into seperate files based on the record key. I have the COBOL layout, and so I need to split the file into 13 different EBCDIC files so that I can run each one through a C++ converter I have, and get the... (11 Replies)
Discussion started by: hanshot1stx
11 Replies

3. Shell Programming and Scripting

Long file record

riends I have the following problem: test.txt I have a file that has the following contents: is a fixed-length file to the end of the number 12 has spaces, so that it is fixed length 123456789 123456789 123456789 12 This code shows me the length of each record, but in... (2 Replies)
Discussion started by: tricampeon81
2 Replies

4. Shell Programming and Scripting

Output first unique record in csv file

Hi, I have to output a new csv file from an input csv file with first unique value in the first column. input csv file color product id status green 102 pass yellow 201 hold yellow 202 keep green 101 ok green 103 hold yellow 203 ... (5 Replies)
Discussion started by: Chris LAU
5 Replies

5. Shell Programming and Scripting

Split a large file in n records and skip a particular record

Hello All, I have a large file, more than 50,000 lines, and I want to split it in even 5000 records. Which I can do using sed '1d;$d;' <filename> | awk 'NR%5000==1{x="F"++i;}{print > x}'Now I need to add one more condition that is not to break the file at 5000th record if the 5000th record... (20 Replies)
Discussion started by: ibmtech
20 Replies

6. Shell Programming and Scripting

csv file - adding total to a trailer record

Hi, I have a script which creates and modifies a csv file. I have managed to do everything I need to do apart from 1 thing. I need to append a trailer record to the file. I need this line to hold the total of an entire column of the csv file (skipping the 1st line which is a header). Can... (2 Replies)
Discussion started by: mcclunyboy
2 Replies

7. Shell Programming and Scripting

Record count of a csv file

Hello Gurus, We have a requirement to count the valid number of records in a comma delimited file with double quotes. The catch here is..few records have a new line carriage within the double quotes,,say for ex:we have a file called accounts the record count is 4827..but the actual valid count... (5 Replies)
Discussion started by: ajaykk
5 Replies

8. Shell Programming and Scripting

How to split a file record

-Hi, I have a problem with parcing/spliting a file record into two parts and assigning the split parts to two viriables. The record is as follows: ftrn facc ttrd feed xref fsdb fcp ruldb csdb omom fordr ftxn fodb fsdc texc oxox reng ttrn ttxn fqdb ... (5 Replies)
Discussion started by: aoussenko
5 Replies

9. UNIX for Dummies Questions & Answers

how to get a file name & record count of csv file

HI , I am new to shell scripting , I have a requirement that I send a file for data quality ( original.csv) & i will be getting 4 files daily into a particular directory in return with cleansed data . the files may be clean.csv, unclean.csv , ... (2 Replies)
Discussion started by: sirik
2 Replies

10. UNIX for Dummies Questions & Answers

How to delete a record from a csv file

Hi Guys I have downloaded a table from oracle database in .csv format. it has many fields as Title, First Name, Last Name etc. I have to download distinct titles from database and now i have to check all those titles from data of First Name one by one. and then i have to delete matched record.... (1 Reply)
Discussion started by: Rajeev Agrawal
1 Replies
Login or Register to Ask a Question