Hi everybody,
Input file:
ID |First name |Last name |Address |
Phone |
--------------------------------------------------------------------------------------------------------------
<--10-->|<----15----->|<----20----->|
<--------30------------------------>|<---14------------->|
--------------------------------------------------------------------------------------------------------------
4568 |Michael |Moore |350 Kensington Rd. |
(514) 567-1234 |
63542 |James |Joyce |220 London Blv. |
(450) 234-1456 |
I need to trim all blanks of each fixed-length field (notice there are
blanks within each field that may be seen as field separators by awk
if not treated correctly). The output file I'm looking for (a CSV
file) would be like:
4568,Michael,Moore, 350 Kensington Rd.,(514) 567-1234
63542,James,Joyce,220 London Blv.,(450) 234-1456
Thanks,
Radu


|