Sponsored Content
Top Forums Shell Programming and Scripting Reformatting single column text file starting new line when finding particular string Post 302566952 by vgersh99 on Friday 21st of October 2011 01:44:58 PM
Old 10-21-2011
given myFile:
Code:
172.xx.xx.xx
 gwpusprdrp02_pv
 seinwnprd03
10.xx.xx.xx
 imauditorsql
 seinwnprd06
172.xx.xx.xx
 invtsql01
 seinwnprd02
172.xx.xx.xx
 itcnetlog1
 seinwnprd02
172.xx.xx.xx
 itcsql04
 seinwnprd02
10.xx.xx.xx
 oaksdag01.corp.seic.com
 seinwnprd06, nsrserverhost

running nawk '{printf("%c%s", ((/^[0-9]+/&&FNR!=1)?ORS:""), $0)}END{print ""}' myFile produces:
Code:
172.xx.xx.xx gwpusprdrp02_pv seinwnprd03
10.xx.xx.xx imauditorsql seinwnprd06
172.xx.xx.xx invtsql01 seinwnprd02
172.xx.xx.xx itcnetlog1 seinwnprd02
172.xx.xx.xx itcsql04 seinwnprd02
10.xx.xx.xx oaksdag01.corp.seic.com seinwnprd06, nsrserverhost

Check your myFile input file. Make sure it doesn't contain any ^M-s. Post the output of:
Code:
cat -vet myFile

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding a certain string on each line in a file

Hi, I need a script to get every line from a file where there are less then 17 ; on a line. Thank's (5 Replies)
Discussion started by: VODAFUN
5 Replies

2. Shell Programming and Scripting

Finding a string in a text file and posting part of the line

What would be the most succinct way of doing this (preferably in 1 line, maybe 2): searching the first 10 characters of every line in a text file for a specific string, and if it was found, print out characters 11-20 of the line on which the string was found. In this case, it's known that there... (13 Replies)
Discussion started by: busdude
13 Replies

3. Shell Programming and Scripting

Finding the last column value from a text file

Hi, I need to find out the last column value from a text file which is delimited by a tab. The issue here is the last column# for each record can be different i.,e, 1st record can have the last column as 15 and the second record can have the last column as "17". I have to search a string... (3 Replies)
Discussion started by: naveen_sangam
3 Replies

4. Shell Programming and Scripting

Finding the second last column value from a text file

Can any one tell me how to get the second last column value from the text file, which has different record size for each record. I know how to get the last column using awk and print statements, but I am unable to get the second last column value from the file. (4 Replies)
Discussion started by: naveen_sangam
4 Replies

5. Shell Programming and Scripting

replace (sed?) a single line/string in file with multiple lines (string) from another file??

Can someone tell me how I can do this? e.g: Say file1.txt contains: today is monday the 22 of NOVEMBER 2010 and file2.txt contains: the 11th month of How do i replace the word NOVEMBER with (5 Replies)
Discussion started by: tuathan
5 Replies

6. Shell Programming and Scripting

Help for reformatting text file and creating new format

Hi all, I have an input file like 1,date,company,, 1,date,comapny,, 2,000,,,567,ACT,00,,,,KKG,M1,D45,,67J,+4500000000 2,000,,,567,ACT,00,,,,KKG,M6,D49,,56J,+6000 2,000,,,567,ACT,00,,7,,KKG,M3,D58,,68h,-70000 2,000,,,567,ACT,00,,,,KKG,M9,D95,,34m,0.00 3,total what i require is 1.I... (2 Replies)
Discussion started by: selvankj
2 Replies

7. UNIX for Dummies Questions & Answers

Sort text file starting at column X

Hello everyone! As the heading reads, I would like to sort the lines of a text file, starting at a specific column (i.e. skip the first X characters of each line). What I’m actually trying to sort is the md5 sums file of a directory. Every time I copy a new file to that directory, I perform... (3 Replies)
Discussion started by: iznogoud
3 Replies

8. Shell Programming and Scripting

Multiple lines in a single column to be merged as a single line for a record

Hi, I have a requirement with, No~Dt~Notes 1~2011/08/1~"aaa bbb ccc ddd eee fff ggg hhh" Single column alone got splitted into multiple lines. I require the output as No~Dt~Notes 1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh" mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies

9. Shell Programming and Scripting

search a string in a particular column of file and return the line number of the line

Hi All, Can you please guide me to search a string in a particular column of file and return the line number of the line where it was found using awk. As an example : abc.txt 7000,john,2,1,0,1,6 7001,elen,2,2,0,1,7 7002,sami,2,3,0,1,6 7003,mike,1,4,0,2,1 8001,nike,1,5,0,1,8... (3 Replies)
Discussion started by: arunshankar.c
3 Replies

10. UNIX for Dummies Questions & Answers

Append a line to single column text file

I would like to add a line to the end of a single column text file. How do I go about doing that? Input: BEGIN 1 2 3 Output: BEGIN 1 2 3 END Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies
GETFILEINFO(1)						    BSD General Commands Manual 					    GETFILEINFO(1)

NAME
/usr/bin/GetFileInfo -- get attributes of files and directories SYNOPSIS
/usr/bin/GetFileInfo [-P -a[<attribute-letter>] | -c | -d | -m | -t] file ... DESCRIPTION
/usr/bin/GetFileInfo is a tool to get the file attributes. With no flags, GetFileInfo retrieves all information about the file. If exactly one option is provided, GetFileInfo retrieves and displays just that information; supplying more than one is an error. Flags: -P Acts on a symlink file instead of the file the symlink resolves to. -a[<attribute-letter>] Gets a file's attribute bits where <attribute-letter> is one of the following: a Alias file b Has bundle c Custom icon (allowed on folders) d Located on the desktop (allowed on folders) e Extension is hidden (allowed on folders) i Inited - Finder is aware of this file and has given it a location in a window. (allowed on folders) l Locked m Shared (can run multiple times) n File has no INIT resource s System file (name locked) t "Stationery Pad" file v Invisible (allowed on folders) z Busy (allowed on folders) The value of a single attribute is printed as 0 for off or false, 1 for on or true. If no attribute letter is specified, the value of all attributes is returned, with lowercase letters representing off or false, and uppercase representing on or true. -t Gets the file type, a string of exactly four characters. If the type is not set, these will display as an empty pair of quo- tation marks. Directories do not have types, so the type will be skipped if all information is being displayed; specifying -t for a directory is an error. -c Gets the file's creator, a string of four characters enclosed in quotation marks. If the creator is not set, these will dis- play as an empty pair of quotation marks. Directories do not have creators, so the creator will be skipped if all information is being displayed; specifying -c for a directory is an error. -d Gets the creation date, a string of the form "mm/dd/yyyy hh:mm:ss" in 24-hour clock format. -m Gets the modification date, a string of the form "mm/dd/yyyy hh:mm:ss" in 24-hour clock format. RETURN VALUES
0 success 1 syntax error 2 any other error SEE ALSO
SetFile(1) EXAMPLES
The following command line gets and prints the creator for the "Late Breaking News" file: /Developer/Tools/GetFileInfo -c "Late Breaking News" This command line prints the modification date of "myFile": /Developer/Tools/GetFileInfo -m myFile Mac OS X September 27, 2005 Mac OS X
All times are GMT -4. The time now is 05:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy