|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Changing one column of delimited file column to fixed width column
Post 302210441 by zaxxon on Tuesday 1st of July 2008 03:04:45 AM
07-01-2008
|
|
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I have two input files.
File1:
ID Name Place
1-234~name1~Newyork
1-34~name2~Boston
1-2345~name3~Hungary
File1 is a variable length file where each column is seperated by delimitter "~".
File2:
ID Country
1-34<<11 SPACES>>USA<<7 spaces>>
1-234<<10 SPACES>>UK<<8... (5 Replies)
Discussion started by: manneni prakash
5 Replies
2. Shell Programming and Scripting
Col1 Col2 Col3 Col4
12 Completed 08 0830
12 In Progress 09 0829
11 For F U 07 0828
Considering the file above, how could i replace the third column the most efficient way? The actual file size is almost 1G. I am... (10 Replies)
Discussion started by: tamahomekarasu
10 Replies
3. Shell Programming and Scripting
Dear friends,
Below is my program and current output. I wish to have 3 or 4 column output in order to accomodate in single page. i do have subsequent command to process after user enter the number.
Program
COUNT=1
for MYDIR in `ls /`
do
VOBS=${MYDIR}
echo "${COUNT}. ${MYDIR}"
... (4 Replies)
Discussion started by: baluchen
4 Replies
4. UNIX for Dummies Questions & Answers
Hi,
How to output the duplicate record to another file. We say the record is duplicate based on a column whose position is from 2 and its length is 11 characters.
The file is a fixed width file.
ex of Record:
DTYU12333567opert tjhi kkklTRG9012
The data in bold is the key on which... (1 Reply)
Discussion started by: Qwerty123
1 Replies
5. Shell Programming and Scripting
Hi,
I have a fixed width text file without any header row. One of the columns contains a date in YYYYMMDD format.
If the original file contains 3 dates, I want my shell script to split the file into 3 small files with data for each date.
I am a newbie and need help doing this. (14 Replies)
Discussion started by: bhanja_trinanja
14 Replies
6. Shell Programming and Scripting
I have a fixed with file with header & trailer length having the same length of the detail record file.
The details record length of this file is 24, for Header and Trailer the records will be padded with spaces to match the record length of the file
Currently I am adding 3 spaces in header... (14 Replies)
Discussion started by: ginrkf
14 Replies
7. Shell Programming and Scripting
hi,
i have a fixed width file with multiple columns and need to print data using awk command.
i use: awk -F "|" '($5 == BH) {print $1,$2,$3}' <non_AIM target>.txt for a delimiter file.
but now i have a fixed width file like below:
7518 8269511BH 20141224951050N8262
11148 8269511BH... (5 Replies)
Discussion started by: kcdg859
5 Replies
8. Shell Programming and Scripting
Hi All,
I am trying to select the rows in a fixed width file based on values in the columns.
I want to select only the rows if column position 3-4 has the value AB
I am using cut command to get the column values. Is it possible to check if cut -c3-4 = AB is true then select only that... (2 Replies)
Discussion started by: ashok.k
2 Replies
9. UNIX for Beginners Questions & Answers
Hello Everyone..
I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files
FileP.txt
... (2 Replies)
Discussion started by: YogeshG
2 Replies
LEARN ABOUT SUSE
id3
ID3(1) General Commands Manual ID3(1) NAME
id3 - an ID3 tag editor. SYNOPSIS
id3 [-tTaAycg newdata] file1 [file2 [file3...]] id3 -l file1 [file2 [file3...]] id3 -d file1 [file2 [file3...]] id3 -L DESCRIPTION
id3 is an ID3 v1.1 tag editor. ID3 tags are traditionally put at the end of compressed streamed audio files to denote information about the audio contents. Up to thirty characters of Title, Artist, and Album information can be stored, as well as a 28-character comment, four- digit year, track number up to 255, and an enumerated genre. OPTIONS
-t title Sets the title tag to the first 28 characters of title. -T track Sets the track tag to a number between 0 and 255. -a artist Sets the artist tag to the first 28 characters of artist. -A album Sets the album tag to the first 28 characters of album. -y year Sets the year tag to the first 4 characters of year. -c comment Sets the comment tag to the first 28 characters of comment. -g genre Sets the genre number tag using a genre number or predefined genre label. -l List/view the ID3 tag. -L List all genre tags. -R Use rfc822-style output for tag printout. -d Delete the ID3 tag. BUGS
The ID3 format has some shortcomings. There is a 1 in 16777216 chance of your mp3 having a certain bit-pattern, causing id3 to write over the last 128 bytes of your mp3 upon tag creation. If you add a track number to an ID3 v1.0 tag, the last two characters of the comment string will be truncated. Any bugs found in id3 should be forwarded to the author, Robert Woodcock <rcw@debian.org>. ID3(1)