Sponsored Content
Full Discussion: File Manipulation
Top Forums UNIX for Advanced & Expert Users File Manipulation Post 302087409 by vgersh99 on Thursday 31st of August 2006 02:55:52 PM
Old 08-31-2006
Quote:
Originally Posted by kris01752
i have a CSV file with 2 columns
Fund,Shares
1,100
2,150
3,190

The file is named as AccountNumber.txt(14888.txt,189879.txt...)
That files shows the funds in that account
I want to create a flat file with accountnumber as one more column since i need accountnumber also.The accoutnnumber is in the name of the file

Can some one help me in this


Thanks
Code:
nawk -F=',' -v OFS='.' '
FNR == 1 {
   act=substr(FILENAME, 1, index(FILENAME, ".")-1)
}
{ print act, $0 }
' [0-9][0-9]*.txt > myNewFile.txt

 

10 More Discussions You Might Find Interesting

1. Programming

need help with file manipulation

I've been able to open and write data to files but I need to know how to search a file for a hex string and replace it. (2 Replies)
Discussion started by: angelfly
2 Replies

2. Shell Programming and Scripting

file manipulation best way ?

Hi , i would convert the following file V M BOURSE EMPLOI mail/mail-03/dfr-dc.nsf V M DelSpam mail/mail-04/celine_bet.nsf like that : mail/mail-03/dfr-dc.nsf;BOURSE EMPLOI mail/mail-20/celine_bet.nsf;DelSpam the second field ( ex:... (2 Replies)
Discussion started by: Nicol
2 Replies

3. Shell Programming and Scripting

Help with file manipulation

I need help manipulating text in a file. I am wanting to know a way to shell (ksh)script-edit a file by having a script that searches for a specific string, and then input lines of text in the file before that specific string, without deleting any of the other text in the file. I got this... (2 Replies)
Discussion started by: LinuxRacr
2 Replies

4. Shell Programming and Scripting

File Manipulation

Hi, i have a file with fixed record length with the following content (only one sentence) 12345678901234567890123456789012345678901234567890 12345678 87654321 hugo meyer friedhofpaul the numbers above are only the column-positions and not part of the file! Now i want... (2 Replies)
Discussion started by: FranzB
2 Replies

5. UNIX for Dummies Questions & Answers

file manipulation help please

Hi there, I've trawled all over the web for help, and although seen some examples of what i want to do, I cannot seem to get it to work. I need to have this as a script. If anyone can help, I would like to do the following: I have 2 files, File A and File B. I would like to keep file A but... (5 Replies)
Discussion started by: lazerlyte
5 Replies

6. Shell Programming and Scripting

File manipulation

Legends, Please help me to get the following I have a file abc.txt with the following contents 12 13 14 15 And, i want to get the output to a variable like below 12,13,14,15 .... How do i do this? Regards, san Please use code tags when posting data and code samples! (5 Replies)
Discussion started by: sdosanjh
5 Replies

7. Shell Programming and Scripting

value in file - manipulation

Hi Forum. I have the following 2 files: edw_mf_bypass_msg.txt and EDW_server.cfg. edw_mf_bypass_msg.txt - File#1 contains the following text To EDW Support: This is an automatic email sent from var_hostname. Please note that the Mutual Fund load did not run today due to previous... (2 Replies)
Discussion started by: pchang
2 Replies

8. UNIX for Dummies Questions & Answers

Filtering records from 1 file based on some manipulation doen on second file

Hi, I am looking for an awk script which should help me to meet the following requirement: File1 has records in following format INF: FAILEd RECORD AB1234 INF: FAILEd RECORD PQ1145 INF: FAILEd RECORD AB3215 INF: FAILEd RECORD AB6114 ............................ (2 Replies)
Discussion started by: mintu41
2 Replies

9. Shell Programming and Scripting

Awk to convert a text file to CSV file with some string manipulation

Hi , I have a simple text file with contents as below: 12345678900 971,76 4234560890 22345678900 5971,72 5234560990 32345678900 71,12 6234560190 the new csv-file should be like: Column1;Column2;Column3;Column4;Column5 123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies

10. Shell Programming and Scripting

Populating File data with custom manipulation on file names

Hi, I am confused how to proceed firther please find the problem below: Input Files: DCIA_GEOG_DATA_OCEAN.TXT DCIA_GEOG_DATA_MCRO.TXT DCIA_GEOG_DATA_CVAS.TXT DCIA_GEOG_DATA_MCR.TXT Output File Name: MMA_RFC_GEOG_NAM_DIM_LOD.txt Sample Record(DCIA_GEOG_DATA_OCEAN.TXT):(Layout same for... (4 Replies)
Discussion started by: Arun Mishra
4 Replies
gedit(1)							   User Commands							  gedit(1)

NAME
gnome-text-editor, gedit - Text Editor for the GNOME desktop. SYNOPSIS
gnome-text-editor | gedit [--encoding=encoding] [--new-document] [--new-window] [+[num]] [gnome-std-options] [filename] DESCRIPTION
gedit or gnome-text-editor is the official text editor of the GNOME desktop environment. While aiming at simplicity and ease of use, gedit is a powerful general purpose text editor. It can be used to create and edit all kinds of text files. Multiple documents can be edited at the same time. Each document resides in a specific tabbed section of the application win- dow. gedit features a flexible plugin system which can be used to dynamically add new advanced features to gedit itself. OPTIONS
The following options are supported: --encoding=encoding Set the character encoding to be used to open the files listed on the command line. --new-document Create a new top-level document or tabbed section in an existing instance of gedit. --new-window Create a new top-level window in an existing instance of gedit. +[num] For the first file, go to the line specified by num (do not insert a space between the "+" sign and the number). If num is missing, go to the last line. gnome-std-options Standard options available for use with most GNOME applications. See gnome-std-options(5) for more information. OPERANDS
The following operands are supported: filename The name of the image file to edit. EXTENDED DESCRIPTION
The gedit application accepts pipes, so you can specify a pipe after another command, to load the output of the command into gedit. For example: example% ls -l | gedit EXAMPLES
Example 1: To Edit an ASCII File Named document.txt example% gedit document.txt Example 2: To Add a New Tab That Contains an ASCII File Named book.txt example% gedit --new-document book.txt Example 3: To Add a New Top-Level Window That Contains an ASCII File Named testfile.txt example% gedit --new-window testfile.txt EXIT STATUS
The following exit values are returned: 0 Application exited successfully. >0 An error occurred. FILES
The following files are used by this application: /usr/bin/gedit The executable file for the gnome-text-editor application. /usr/bin/gnome-text-editor A symbolic link to the gedit executable file. /usr/lib/gedit/plugins Location of gedit plugins. /usr/share/gtk-doc/html/gedit Location of developer documentation for writing a gedit plugin. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWgnome-text-editor | +-----------------------------+-----------------------------+ |Interface stability |Volatile | +-----------------------------+-----------------------------+ SEE ALSO
libgtksourceview-1.0(3), attributes(5), gnome-std-options(5) Online Help gedit manual. NOTES
This man page was written by the following people: Paolo Maggi, Paolo Borelli, Chema Celorio, James Willcox, Federico Mena Quintero. Updated by Brian Cameron, Sun Microsystems Inc., 2003, 2004, 2006. SunOS 5.11 31 Aug 2004 gedit(1)
All times are GMT -4. The time now is 12:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy