The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Special Forums > UNIX Desktop for Dummies Questions & Answers
.
google unix.com



UNIX Desktop for Dummies Questions & Answers Discuss UNIX and Linux user interfaces like GNOME, KDE, CDE, and Open Office here. All UNIX and Linux Newbies Welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Changing particular field in fixed width file dsravan Shell Programming and Scripting 4 02-11-2008 06:08 PM
Extracting records with unique fields from a fixed width txt file sitney Shell Programming and Scripting 8 02-10-2008 03:18 AM
Converting a Delimited File to Fixed width file raghavan.aero Shell Programming and Scripting 2 06-06-2007 02:44 PM
adding delimiter to a fixed width file sumeet Shell Programming and Scripting 2 03-21-2007 10:19 AM
Fixed Width file using AWK alok.benjwal UNIX for Dummies Questions & Answers 2 12-05-2005 11:39 AM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 04-28-2008
sate911 sate911 is offline
Registered User
  
 

Join Date: Apr 2008
Posts: 1
Help with Fixed width File Parsing

I am trying to parse a Fixed width file with data as below. I am trying to assign column values from each record to variables. When I parse the data, the spaces in all coumns are dropped. I would like to retain the spaces as part of the dat stored in the variables. Any help is appreciated.

I would like to redirect this data into a csv file like below for each record
2,6138023380020080422120104828,60061395297943,0000006824, ,C, , ,POS .......etc

Input File

26138023380020080422120104828600613952979430000006824C POS13MMAHONIA NANCY 4189928286000422120104CO OP 2529 HOLIDAY FLCO-OP #2529

My Script:

while read LINE
do
a=`echo "$(echo $LINE |cut -c1-1)"`
b=`echo "$(echo $LINE |cut -c2-32)"`
c=`echo "$(echo $LINE |cut -c33-43)"`
d=`echo "$(echo $LINE |cut -c44-53)"`
e=`echo "$(echo $LINE |cut -c54-55)"`
f=`echo "$(echo $LINE |cut -c55-74)"`
#echo $a,$b,$c,$d,$e,"$f >> Int_4_final.dat
done < $1
  #2 (permalink)  
Old 05-19-2008
divh18 divh18 is offline
Registered User
  
 

Join Date: May 2008
Posts: 7
Hi,
I would put a space after each )

Quote:
Originally Posted by sate911 View Post

a=`echo "$(echo $LINE |cut -c1-1)"`
  #3 (permalink)  
Old 05-19-2008
era era is offline Forum Advisor  
Herder of Useless Cats (On Sabbatical)
  
 

Join Date: Mar 2008
Location: /there/is/only/bin/sh
Posts: 3,652
You need to use proper quoting to preserve spaces in variables. See UNIX Shell Quote
(via Answers to Frequently Asked Questions - The UNIX Forums)
  #4 (permalink)  
Old 05-19-2008
joeyg's Avatar
joeyg joeyg is offline Forum Staff  
modérateur
  
 

Join Date: Dec 2007
Location: Home of 17-time world champion Boston Celtics
Posts: 1,311
Wink Double-quote the variable

Here are a couple of examples from one of my working scripts.

Code:
   year=$(echo "$zf" | cut -c185-188)
   car=$(echo "$zf" | cut -c189-230)


The key is the variable zf is in double-quotes, and thus maintains all spacing.
  #5 (permalink)  
Old 05-19-2008
era era is offline Forum Advisor  
Herder of Useless Cats (On Sabbatical)
  
 

Join Date: Mar 2008
Location: /there/is/only/bin/sh
Posts: 3,652
If the result contains spaces, you will need to quote the backticks, too.

Code:
year="$(echo "$zf" | cut -c185-188)"
car="$(echo "$zf" | cut -c189-230)"
echo `echo` as seen above is obviously a redundant, Useless Use of Echo in Backticks.
Sponsored Links
Closed Thread

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -4. The time now is 12:39 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0