Radu schreef:
> 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
awk '{ gsub(/\|/,","); print ; gsub(" \+"," "); gsub(" ,",","); print'
inputfile
--
Luuk
|
