cleaning up spaces from fixed width file while converting to csv file
Open to a sed/awk/or perl alternative so that i can stick command into my bash script.
This is a problem I resolve using a combination of cut commands - but that is getting convoluted. So would really appreciate it if someone could provide a better solution which basically replaces all spaces before and prior to the | sign while keeping the spaces that is part of the data.
I have fixed width file delimted by |:
(HTML screws this up, so assume that all the pipe's are all lined up and that first name starts on 1st position, last name always starts at the 20th position, address starts at 40, State starts at 80 - sure u guys get the idea).
Since each column have varying spaces before the | delimiter, how can I quickly remove all the unnecessary spaces and make this a normal csv file instead of a fixed width file. What i want to see is:
Thanks much ... one of those problems that drive me crazy :-)
Last edited by Scott; 08-26-2010 at 03:01 PM..
Reason: Please use code tags
Hi,
I have a delimited file generated by a database and i need to convert it to fixed width file using the field length of the database. Can any body suggest me how can i proceed with it?
:confused:
Thanks
Raghavan (2 Replies)
Hi
I have a file having record as -
1,aaa,a123,a
I need this converted to as 2nd col to 5 chars wide & 3rd col to 6chars wide such as -
1,aaa ,a123 ,a
How we could achieve this? Thx in advance. (1 Reply)
Hi All,
I have created a script which generates FIXED-WIDTH file by executing Oracle query.
SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ
It generates the data file with proper alignment. But if same file i transfer to windows server or Mainframe... (5 Replies)
Hi Guys
I am checking the treads to get the answer but i am not able to get the answer for my question.
I have two files. First file is a pattern file and the second file is the file i want to search in it. Output will be the lines from file2.
File1:
P2797f12af 44751228... (10 Replies)
I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers.
awk '{print length;exit}' <File_name>
The above code gives me length 50.
wc -L <File_name>
The above code gives me length 53.
Please clarify on... (2 Replies)
Thank u so much .Its working fine as expected.
---------- Post updated at 03:41 PM ---------- Previous update was at 01:46 PM ----------
I need one more help.
I have another file(fixed length) that will get negative value (ex:-00000000003000) in postion (98 - 112) then i have to... (6 Replies)
Hello All, I'm able to achieve my goal of creating a fixed width file from a comma delimited but I know I'm not doing it as efficiently as possible.
Original File
checksab
004429876883,O,342040,981.98,10232014
004429876883,O,322389,2615.00,10232014... (6 Replies)
Hi,
I am facing a typical scenario for AWK command .
In HP- UNIX is behave as expected but in red hat linux same awk code is not give the same result.
The below code is for convert the fixed width file to pipe delimiter file in HP-unix server.
awk code:
#!/bin/awk -f
NR!=1... (11 Replies)
Hi - this is a generic question .... is there any utility which can convert a fixed width file format to a delimited file (any given character delimited) ? (5 Replies)
Discussion started by: i4ismail
5 Replies
LEARN ABOUT DEBIAN
viewperl
VIEWPERL(1) User Commands VIEWPERL(1)NAME
viewperl - quickly view syntax highlighted Perl code
SYNOPSIS
viewperl [OPTION]... FILE...
DESCRIPTION
View a Perl source code file, syntax highlighted.
-c, --code=CODE
view CODE, syntax highlighted
-l, --lines
display line numbers
-L, --no-lines
supress display of line numbers (default)
-m, --module=FILE
consider FILE the name of a module, not a file name
-n, --name
display the name of each file (default)
-N, --no-name
supress display of file names (implied by --no-reset)
-p, --pod
display inline POD documentation (default)
-P, --no-pod
hide POD documentation (line numbers still increment)
-r, --reset
reset formatting and line numbers each file (default)
-R, --no-reset
supress resetting of formatting and line numbers
-s, --shift=WIDTH
set tab width (default is 4)
-t, --tabs
translate tabs into spaces (default)
-T, --no-tabs
supress translating of tabs into spaces
--help display this help and exit
Note that module names should be given as they would appear after a Perl `use' or `require' statement. `Getopt::Long', for example.
Each string given using -c is considered a different file, so line number and formatting resets will apply.
View a Perl source code file, syntax highlighted.
-c, --code=CODE
view CODE, syntax highlighted
-l, --lines
display line numbers
-L, --no-lines
supress display of line numbers (default)
-m, --module=FILE
consider FILE the name of a module, not a file name
-n, --name
display the name of each file (default)
-N, --no-name
supress display of file names (implied by --no-reset)
-p, --pod
display inline POD documentation (default)
-P, --no-pod
hide POD documentation (line numbers still increment)
-r, --reset
reset formatting and line numbers each file (default)
-R, --no-reset
supress resetting of formatting and line numbers
-s, --shift=WIDTH
set tab width (default is 4)
-t, --tabs
translate tabs into spaces (default)
-T, --no-tabs
supress translating of tabs into spaces
--help display this help and exit
Note that module names should be given as they would appear after a Perl `use' or `require' statement. `Getopt::Long', for example.
Each string given using -c is considered a different file, so line number and formatting resets will apply.
viewperl August 2007 VIEWPERL(1)