[ale] swap 2 fields (in a tabbed file)?

John Wells jb at sourceillustrated.com
Wed Jan 29 12:51:20 EST 2003


Chris,

You mentioned sorting on the second field?

sort --key=2.1 <file>

should do it.

John

Christopher Bergeron said:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Well, ultimately I'd like to do it on the command line using existing
> utilities or possibly regexp's.
>
>
>
>
> Denny Chambers wrote:
>
> | You did not specifiy a language in which to do this in, so I will |
> offer up Java, and it's StringTokenizer class
> | (java.util.StringTokenizer). You should be able to do this with just a
> | couple of lines of code.
> |
> | Denny
> |
> | 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+OBN1TKCy0t3zQgURAiWoAJ9bhqltt5avQGd/pQNwasBHcaOZwACeJ/a8
> +0VSfdWIlqRQkNaTgfXSmYg=
> =mVkJ
> -----END PGP SIGNATURE-----
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale



_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale






More information about the Ale mailing list