07-12-2005
how to include field separator if there are blank fields?
Hi,
I have the following data in the format as shown (note: there are more than 1 blank spaces between each field and the spaces are not uniform, meaning there can be one blank space between field1 and field2 and 3 spaces between field3 and field4, in this example, # are the spaces in between the fields):
________________________________________
num1a###num2a#num3a#####num4a##num5a
num1b###num2b##########num4b#######
#######num2c#num3c#####num4c##num5c
#######num2d#num3d#####num4d##num5d
num1e###num2e#num3e#####num4e##num5e
num1f########################num5f
________________________________________
i need to include ; as the field delimiter and the required output is:
________________________________________
num1a;num2a;num3a;num4a;num5a
num1b;num2b;;num4b;
;num2c;num3c;num4c;num5c
;num2d;num3d;num4d;num5d
num1e;num2e;num3e;num4e;num5e
num1f;;;;num5f
________________________________________
I tried using
sed -e 's/ */;/g'
but it will take consecutive blank fields as one blank field. Can anyone help?
Last edited by ReV; 07-12-2005 at 08:45 AM..
10 More Discussions You Might Find Interesting
1. AIX
Hi,
I experience some issues with my new print queues that I created in AIX (smitty). This following print queue is dedicated to print on tray 1 and the user have to put the paper manually, the jobs should be executed without separator page.
But when we print on this queue, the job is executed... (1 Reply)
Discussion started by: imad77
1 Replies
2. Shell Programming and Scripting
Hi, all
I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes.
sample input:
for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies
3. Shell Programming and Scripting
Hi,
I have a flat file with fields separated by a X'1F'
i have to fetch 4th field from second line.
please help me how to achieve it.
I tried with below command and its not working.
cut -f4 -d`echo -e '\x1f'` filename.txt
I am using SunOS.
Thanks in advance. (2 Replies)
Discussion started by: rohan10k
2 Replies
4. UNIX for Dummies Questions & Answers
Hi !
input:
111|222|333|aaa|bbb|ccc
999|888|777|nnn|kkk
444|666|555|eee|ttt|ooo|ppp
With awk, I am trying to change the FS "|" to "; " only from the 4th field until the end (the number of fields vary between records).
In order to get:
111|222|333|aaa; bbb; ccc
999|888|777|nnn; kkk... (1 Reply)
Discussion started by: beca123456
1 Replies
5. Shell Programming and Scripting
Hi All,
I'm trying to view data using cut command for a fixed length file using the below command:
cut -c 1-3,4-5 FALCON_PIS_00000000.dat
I want to mention a separator say | (pipe) in between 1-3 and 4-5.
Please let me know how to achieve this.
Thanks in Advance, (3 Replies)
Discussion started by: HemaV
3 Replies
6. Shell Programming and Scripting
Hi guys I am trying to figure out how to match a pattern with a regex up to a full blank line. I will show you what I mean with this example:
example A
movie name: ted
movie name: TMNT
movie name: Jinxed
example B
movie names:
Gravity
Faster
Turbo
song titles:
dont
hello
problem (8 Replies)
Discussion started by: acoding
8 Replies
7. Shell Programming and Scripting
Hello All,
I have a file, but I want to separate the file at a particular record with comma"," in the line
Input file
APPLE6SSAMSUNGS5PRICEPERPIECEDOLLAR600EACH010020340URX581949695US
to
Output file
APPLE6S,SAMSUNGS5,PRICEPERPIECE,DOLLAR600EACH,010020340URX581949695,US
This is for... (11 Replies)
Discussion started by: m6248m
11 Replies
8. Shell Programming and Scripting
I am trying to parse the input in awk to include the |gc= in $4 but am not able to. The below is close:
awk so far:
awk '{sub(/\|]+]++/, ""); print }' input.txt Input
chr1 955543 955763 AGRN-6|pr=2|gc=75 0 +
chr1 957571 957852 AGRN-7|pr=3|gc=61.2 0 +
chr1 970621 ... (7 Replies)
Discussion started by: cmccabe
7 Replies
9. Shell Programming and Scripting
Hi All,
I have the input as below:
cat input
032016002 2.891 97.109 16.605 27.172 24.017 32.207 0.233 0.021 39.810 0.077 0.026 19.644 13.882 0.131 11.646 0.102 11.449 76.265 23.735 16.991 83.009 8.840 91.160 0.020 99.980 52.102 47.898 44.004 55.996 39.963 18.625 0.121 1.126 40.189... (15 Replies)
Discussion started by: am24
15 Replies
10. Shell Programming and Scripting
The below code works great, kindly provided by @Don Cragun, the lines in bold print the current output. Since some of the fields printed can be blank some of the fields are shifted. I can not seem too add . to the blank fields like in the desired output. Basically, if there is nothing in the field... (10 Replies)
Discussion started by: cmccabe
10 Replies
LEARN ABOUT DEBIAN
lltag_formats
lltag_formats(5) File Formats Manual lltag_formats(5)
NAME
formats - Internal formats database file for lltag
DESCRIPTION
The internal format database is usually stored in /etc/lltag/formats. The user may override this file by defining a $HOME/.lltag/formats.
If this file exists, the system-wide one is ignored.
These files contain entries starting with a line such as:
[%n - %a - %t]
A title between bracket that will be displayed at runtime.
Then, the following 3 lines must be given to explain how the format is actually used to parse filenames:
type = basename
The type is either basename (to parse the last part of the path to a file) or path (to parse the directory part of the path to a
file). When actually parsing the path to target files, basename and path parsers will be assembled. All possible combination will
be tried.
regexp = %L%N%S-%S%A%S-%S%A%L
A string composed of any characters, with the following special fields:
%L for delimiter (empty by default, multiple spaces if --spaces was given)
%S for a space (or multiple spaces if --spaces was given)
%N for numbers
%A for an alphanumeric string without /
%P for any path (alphanumeric string with /)
%% for %
indices = NUMBER,ARTIST,TITLE
A list of fields to match (either given by their full name or associated letter) corresponding to each %N or %A field in the previ-
ous format. It may be AUTHOR (or a), ALBUM (A), GENRE (g), NUMBER (n), TITLE (t), DATE (d), COMMENT (c) or IGNORE (i). See also
FORMAT in the manpage of lltag for details about these fields.
SEE ALSO
lltag(1)
AUTHOR
Brice Goglin
NOVEMBER 2006 lltag_formats(5)