Sponsored Content
Full Discussion: Editing ascii file with gawk
Top Forums Shell Programming and Scripting Editing ascii file with gawk Post 302563675 by theflamingmoe on Wednesday 12th of October 2011 01:33:57 AM
Old 10-12-2011
Thanks rdcwayx, that works greatSmilie

Can you tell me why this code works
Code:
 
awk '{print $2","$3}' OFS="," geo_met_checks_stope.asc >> junk.csv

Yet when I want to do a print $0 all the fields are jumbled together into one column.
Code:
 
awk '{print $0}' OFS="," geo_met_checks_stope.asc >> junk.csv

What i'm really looking for is how to quickly make a .csv file from an ascii using a shell script rather than manually doing it in excel using the "text to columns" menu option.

Last edited by theflamingmoe; 10-12-2011 at 02:59 AM.. Reason: code needs tweaking.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk,gawk in bat file

Hi. I'm trying to convert bat file into shell script. Bat file invokes awk file in one section: c:\upg\exe\gawk -f c:\upg\awk\gen_sae.awk -v OP=C:\\upg\\lod\\... ...c:\upg\ref\saaxi.ref c:\upg\log\SAAEPWO.log c:\upg\ref\saaepref.log First of all I issued unix2dos command on that awk file.... (0 Replies)
Discussion started by: andrej
0 Replies

2. Shell Programming and Scripting

gawk - multiple sorting within a file

Hi, I am new shell programming and trying work on the follwoing file: 1 rs1 1 rs12 1 rs3 1 rs8 2 rs2 2 rs15 2 rs3 3 rs5 3 rs9 3 rs4 I would like to sort my 2nd column within 1, 2, and 3 separately. The output will be: 1 rs1 1 rs3 1 rs8 1 rs12 (4 Replies)
Discussion started by: ezhil01
4 Replies

3. Shell Programming and Scripting

convert ascii values into ascii characters

Hi gurus, I have a file in unix with ascii values. I need to convert all the ascii values in the file to ascii characters. File contains nearly 20000 records with ascii values. (10 Replies)
Discussion started by: sandeeppvk
10 Replies

4. Shell Programming and Scripting

gawk help for inserting a field of a .txt file in the same file

i had the following type of data file vchrdump: Vouchers For Date :05/01/2009 * ... (4 Replies)
Discussion started by: KANNI786
4 Replies

5. UNIX for Dummies Questions & Answers

Joining lines of a text file using GAWK

sir... am having a data file of customer master., containing some important fields as a set one line after another., what i want is to have one set of these fields(rows) one after another in line.........then the second set... and so on... till the last set completed. ... (0 Replies)
Discussion started by: KANNI786
0 Replies

6. Windows & DOS: Issues & Discussions

Gawk Script in Windows batch file - Help

Good morning all. I have been running into a problem running a simple gawk script that selects every third line from an input file and writes it to an output file. gawk "NR%3==0" FileIn > FileOut I am attempting to run this command from a batch file at the command line. I have several hundred... (6 Replies)
Discussion started by: 10000springs
6 Replies

7. Shell Programming and Scripting

How to remove a temporary file inside gawk

Hi- How can I make the temporary file 0 byte , created inside gawk. I am using system("rm -f temp_orders"); It seems system command is deleting file permanently and I am not able to execute below statement. print ORD_HEAD_FULL >> cFILE; (cFile is temp_orders) (2 Replies)
Discussion started by: ashish_kaithi
2 Replies

8. Shell Programming and Scripting

Gawk - to extract values from multi lined file -I

Hi, Request your help in getting help with the below text formatting using awk. I am still learning awk and your help here is appreciated. Thanks in advance. Desireoutput ---------------- Virtual Pool Destination Profile Profile Profile Profile 1. virtual-1 pool-1 212.254.110.174:https... (2 Replies)
Discussion started by: pratheeshp
2 Replies

9. UNIX for Dummies Questions & Answers

After Ftp'ing file to destination how to check the file if it is in correct ASCII and not corrupted

Hi Folks, While transferring file from FTP software like Filezilla the files gets corrupted. Is there any way I can check if the recently transferred file is in ASCII and not corrupted. I have tried using file -i filename command which does tell if the file character set is ASCII or binary... (6 Replies)
Discussion started by: Khan28
6 Replies

10. Shell Programming and Scripting

Convert Hex to Ascii in a Ascii file

Hi All, I have an ascii file in which few columns are having hex values which i need to convert into ascii. Kindly suggest me what command can be used in unix shell scripting? Thanks in Advance (2 Replies)
Discussion started by: HemaV
2 Replies
CDBS-EDIT-PATCH(1)						CDBS Documentation						CDBS-EDIT-PATCH(1)

NAME
cdbs-edit-patch - create or edit a CDBS simple-patchsys.mk patch SYNOPSIS
cdbs-edit-patch patchname DESCRIPTION
cdbs-edit-patch creates or edits patches for use by the CDBS simple-patchsys.mk patch system. For more information about CDBS please see the documentation under /usr/share/doc/cdbs/. When patchname exists, cdbs-edit-patch will set up a temporary working source tree, apply all patches up to and including patchname in lex- icographic order, and spawn an interactive shell for the developer. The developer can then edit files in this working tree. When the developer is done and exits the shell, cdbs-edit-patch updates patchname to reflect the changes made. To abort the process from the inter- active shell, exit with a nonzero exit value. When patchname does not exist, cdbs-edit-patch will assume that a new patch should be created. As with the above scenario, cdbs-edit-patch will first create a temporary working source tree and apply all patches up to the new patch in lexicographic order. When the shell is quit, cdbs-edit-patch will create patchname. AUTHOR
CDBS was written by Colin Walters and others. cdbs-edit-patch was written by Martin Pitt. This manual page was written by Peter Eisen- traut based on the dpatch-edit-patch(1) manual page. SEE ALSO
CDBS documentation in /usr/share/doc/cdbs/, /usr/share/cdbs/1/rules/simple-patchsys.mk, dpatch-edit-patch(1), quilt(1) Debian 5 Feb 2006 CDBS-EDIT-PATCH(1)
All times are GMT -4. The time now is 04:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy