[ale] swap 2 fields (in a tabbed file)?
Christopher Bergeron
christopher at bergeron.com
Wed Jan 29 13:20:15 EST 2003
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Thanks Geoffrey! I think I've almost got it, but my output is appearing
like this:
GE CAPITAL CONSUMER LEND\n\tAFS74
GEWARDS\n\tAFS75
Instead of:
GE CAPITAL CONSUMER LEND\tAFS74\n
GEWARDS\tAFS75\n
I have a feeling it's a simple change, but since I'm new to awk I'm a
slow learner...
Thanks again for any leads,
- -CB
Geoffrey wrote:
| Use awk:
|
| awk -F '\t' '{printf "%s\t%s\n", $2, $1}'
|
| Christopher Bergeron wrote:
|
|> -----BEGIN PGP SIGNED MESSAGE-----
|> Hash: SHA1
|>
|> Does anyone know how I can swap 2 fields in a tab delimited file
|> containing 2 fields?
|>
|> Here's an example of my data:
|> ~ <TAB>WOODSTOCK OUTLET<CR>
|> AF100<TAB>METRO AUDIO DYNAMI<CR>
|>
|> What I'd like to do is swap the 2 fields (or do a `sort` based on the
|> second field!) such that I end up with this:
|> WOODSTOCK OUTLET<TAB> <CR>
|> METRO AUDIO DYNAMICS<TAB>AF100<CR>
|>
|> Does anyone know of a way I can accomplish this? I tried using cut
|> - -f2,1 -d"\t" but no adeu...
|>
|> As always, much thanks in advance!
|> - -CB
|> -----BEGIN PGP SIGNATURE-----
|> Version: GnuPG v1.2.1 (MingW32)
|> Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org
|>
|> iD8DBQE+OBDCTKCy0t3zQgURAjNTAJ4+scGLwJ68zyWNCQi3zOioVQHYSgCgsbsd
|> OQXrEikvL57cV8/Tj1vuqLg=
|> =3GQm
|> -----END PGP SIGNATURE-----
|>
|>
|> _______________________________________________
|> Ale mailing list
|> Ale at ale.org
|> http://www.ale.org/mailman/listinfo/ale
|>
|>
|
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org
iD8DBQE+OBtfTKCy0t3zQgURAghVAKDGTNNK40g+4Jdl39eDsVPAeAgiZQCdF4Gg
kncmOklKRZ00rGmPskLaj5Y=
=577v
-----END PGP SIGNATURE-----
_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale
More information about the Ale
mailing list