01-24-2017
File formating help
Hi all,
I am having the file below
Quote:
"NOT APPLICABLE","0000103","NOT APPLICABLE","Y"
"NOT APPLICABLE","0000109","NOT APPLICABLE","Y"
"NOT APPLICABLE","0005004","NOT APPLICABLE","Y"
"NOT APPLICABLE","0000001","NOT APPLICABLE","Y"
"NOT APPLICABLE","0000002","NOT APPLICABLE","Y"
I need that as below
Quote:
"NOT APPLICABLE","0000103","1","Y"
"NOT APPLICABLE","0000109","1","Y"
"NOT APPLICABLE","0005004","1","Y"
"NOT APPLICABLE","0000001","1","Y"
"NOT APPLICABLE","0000002","1","Y"
Thanks,
Arun
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have two files file1 and file2 as shown below:
file1:
name
nameabc
bcd
nameabcdefg
file2:
age
age1111
age2345
age6743
I have pasted one file on the other with the delimiter "|" and the resulttant file is:
name|age
nameabc|age1111
bcd|age2345
nameabcdefg|age6743 (1 Reply)
Discussion started by: udiptya
1 Replies
2. Shell Programming and Scripting
Hi,
I have a file with only data 1 row:
AA#?BB#?CC#?DD
Assume '#?' is the delimiter, i want the output in another file to be:
AA
BB
CC
DD
Pls let me know if this is possible by sed ?
Thanks in advance. (3 Replies)
Discussion started by: smc3
3 Replies
3. Shell Programming and Scripting
Hi,
I am new to unix , I have a requirement for formating the input file and generate the output file as per the downstream requirement ..
My application receiving a text input file having 4 field and my application need to check each field and if some value of a field is blank ..then it need... (1 Reply)
Discussion started by: julirani
1 Replies
4. UNIX for Dummies Questions & Answers
I have a file called vm.cfg .
content of file.
acpi = 1
apic = 1
builder = 'hvm'
How would i write a script which will add
boot = 'd' at 3rd line.
For example.
after running the script the file should be like below.
acpi = 1
apic = 1
boot = 'd'
builder = 'hvm'
I dont want to... (3 Replies)
Discussion started by: pinga123
3 Replies
5. Shell Programming and Scripting
I am new ot unix. Is there one or two lines of command (sed may be) to format a file.
My source is..
<tag1>
<tag2>
<datatag1>
data1
</datatag1>
<datatag2>
data2
</datatag2>
<datatag3>
data3
</datatag3>
<datatag4>
data1
</datatag3>
</tag2>
</tag1> (2 Replies)
Discussion started by: reachsam11
2 Replies
6. Shell Programming and Scripting
Pls help in formatting a txt file using shell scripting
Input file format:
Name priya 2010-09-21 10:43:49
TEXT ID 1
hi
TEXT ID 2
how
TEXT ID 3
r
TEXT ID 4
u
Output required:
name priya hi how r u (4 Replies)
Discussion started by: bha148
4 Replies
7. Shell Programming and Scripting
hi thanks a lot
But pls help me if my input file is the below format:
Name priya 2010-09-21 10:43:49
TEXT ID 1
hi
TEXT ID 2
how
TEXT ID 3
r
TEXT ID 4
u
Name2 priya2 2010-09-21 10:43:49
TEXT ID 1
hi1
TEXT ID 2
how1
TEXT ID 3
r1 (4 Replies)
Discussion started by: bha148
4 Replies
8. UNIX for Beginners Questions & Answers
Hi All,
Need to modify a file basically join the extra line to one I am having a file like below
And would like to make it as below . (4 Replies)
Discussion started by: arunkumar_mca
4 Replies
9. Shell Programming and Scripting
I need to create a fixed width file based on the column lengths.
lets assume I have six(this may be dynamic) fields each are of different length
column1=6 #size of the column
column2=3
column3=2
column4=3
column5=4
column6=5
I tried below code snippet but it is not working
echo... (4 Replies)
Discussion started by: gvkumar25
4 Replies
10. Shell Programming and Scripting
I have a file like below
position1 0 7802 7802 0 client1 - -
position1 8 8032 8032 0 client1 ... (7 Replies)
Discussion started by: manas_ranjan
7 Replies
LEARN ABOUT DEBIAN
contextual::return::failure
Contextual::Return::Failure(3pm) User Contributed Perl Documentation Contextual::Return::Failure(3pm)
NAME
Contextual::Return::Failure - Utility module for Contextual::Return
NOTE
Contains no user serviceable parts. See Contextual::Return instead.
AUTHOR
Damian Conway "<DCONWAY@cpan.org>"
LICENCE AND COPYRIGHT
Copyright (c) 2006, Damian Conway "<DCONWAY@cpan.org>". All rights reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
DISCLAIMER OF WARRANTY
BECAUSE THIS SOFTWARE IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE SOFTWARE, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT
WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE SOFTWARE "AS IS" WITHOUT WARRANTY OF ANY KIND,
EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE IS WITH YOU. SHOULD THE SOFTWARE PROVE DEFECTIVE, YOU ASSUME THE COST OF
ALL NECESSARY SERVICING, REPAIR, OR CORRECTION.
IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR
REDISTRIBUTE THE SOFTWARE AS PERMITTED BY THE ABOVE LICENCE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL, OR
CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE SOFTWARE (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING
RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE SOFTWARE TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF
SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
perl v5.14.2 2012-04-13 Contextual::Return::Failure(3pm)