Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Count specific character of a file in each line and delete this character in a specific position
Top Forums Shell Programming and Scripting Count specific character of a file in each line and delete this character in a specific position Post 303021379 by MadeInGermany on Wednesday 8th of August 2018 04:30:45 PM
Old 08-08-2018
Deleting an input field in awk might not be portable.
Even this rmcol() function is not portable.
The following should work with Posix-compatible awk and sed. On Solaris requires the /usr/xpg4/bin/ versions.
Code:
#!/bin/bash
PATH=/usr/xpg4/bin:/bin:/usr/bin
awk 'NR==FNR { K[$1]; next } ($2 in K)' file1 FS="|" file2 |
sed '/\([^|]*|\)\{65\}/ s/|//61'

It uses a pipe between awk and sed.
Of course you can have an intermediate file as you stated in post #1
Code:
awk 'NR==FNR { K[$1]; next } ($2 in K)' file1 FS="|" file2 > newfile
sed '/\([^|]*|\)\{65\}/ s/|//61' newfile

Last edited by MadeInGermany; 08-08-2018 at 05:44 PM..
This User Gave Thanks to MadeInGermany For This Post:
teokon90
 

10 More Discussions You Might Find Interesting

1. HP-UX

count occurences of specific character in the file

For counting the occurences of specific character in the file I am issuing the command grep -o 'character' filename | wc -w It works in other shells but not in HP-UX as there is no option -o for grep. What do I do now? (9 Replies)
Discussion started by: superprogrammer
9 Replies

2. Shell Programming and Scripting

Count specific character(s) very large file

I'm trying to count the number of 2 specific characters in a very large file. I'd like to avoid using gsub because its taking too long. I was thinking something like: awk '-F' { t += NF - 1 } END {print t}' infile > outfile which isn't working Any ideas would be great. (3 Replies)
Discussion started by: dcfargo
3 Replies

3. Shell Programming and Scripting

Print lines with specific character at nth position in a file

I need to print lines with character S at nth position in a file...can someone pl help me with appropriate awk command for this (2 Replies)
Discussion started by: manaswinig
2 Replies

4. Shell Programming and Scripting

Print lines with specific character at nth position in a file

I need to print lines with character S at nth position in a file...can someone pl help me with appropriate awk command for this (1 Reply)
Discussion started by: manaswinig
1 Replies

5. Shell Programming and Scripting

Insert character in a specific position of a file

Hi, I need to add Pipe (|) at 5th and 18th position of all records a file. How can I do this? I tried to add it at 5th position using the below code. It didnt work. Please help!!! awk '{substr($0,5,1) ~ /|/}{print}' $input_file > $temp_file (1 Reply)
Discussion started by: gpaulose
1 Replies

6. Shell Programming and Scripting

Using sed to replace specific character and specific position

I am trying to use sed to replace specific characters at a specific position in the file with a different value... can this be done? Example: File: A0199999123 A0199999124 A0199999125 Need to replace 99999 in positions 3-7 with 88888. Any help is appreciated. (5 Replies)
Discussion started by: programmer22
5 Replies

7. UNIX for Advanced & Expert Users

Count specific word or character per line

Hi, I need help regarding counting specific word or character per line and validate it against a specific number i.e 10. And if number of character equals the specific number then that line will be part of the output. Specific number = 6 Specific word or char = || Sample data:... (1 Reply)
Discussion started by: janzper
1 Replies

8. Shell Programming and Scripting

Delete line based on count of specific character

I'm looking for what I hope might be a one liner along these lines: sed '/a line with more than 3 pipes in it/d' I know how to get the pipe count in a string and store it in a variable, but I'm greedy enough to hope that it's possible via regex in the /.../d context. Am I asking too much? ... (5 Replies)
Discussion started by: tiggyboo
5 Replies

9. Shell Programming and Scripting

Delete character on specific position

Hi, im still new in unix. i want to ask how to delete character on specific position in line, lets say i want to remove 5 character from position 1000, so characters from position 1000-1005 will be deleted. i found this sed command can delete 4 characters from position 10, but i dont know if... (7 Replies)
Discussion started by: bluesue
7 Replies

10. Post Here to Contact Site Administrators and Moderators

Search for a pattern and replace a space at specific position with a Character in File

In file, we have millions of records each of 1000 in length. And at specific position say 800 there is a space, we need to replace it with Character X if the ID in that row starts with 123. So far i have used the below which is replacing space at that position to X but its not checking for... (3 Replies)
Discussion started by: Jagmeet Singh
3 Replies

LEARN ABOUT DEBIAN

bnftp

BNFTP(1)							BNETD User's Manual							  BNFTP(1)

NAME

       bnftp - Battle.net file transfer client

SYNOPSIS

       bnftp [options] [servername [serverport]]

DESCRIPTION

       bnftp  is  a simple program for downloading data files from a bnetd server.  These files include tos.txt, upgrade MPQ archives, and ad ban-
       ners.

       If no servername is specified, localhost is assumed.  If no serverport is specified, 6112 is assumed.

       After the program is started it will connect to the server and then prompt for the filename to download.  No directory  components  may	be
       used in the filename.  The file is copied to a file with the same name in the current directory.

OPTIONS

       -b     Causes bnftp to emulate a Brood Wars client.

       --client
	      Causes  bnftp  to  emulate  a  specific client.  The following client tags are recognized: DRTL DSHR STAR SSHR SEXP W2BN.  There are
	      short options which may be used instead for the common clients.

       -d     Causes bnftp to emulate a Diablo client.

       -h --help --usage
	      Print usage information and exit.

       -s     Causes bnftp to emulate a Starcraft client.

       -v --version
	      Print its version number and exit.

       -w     Causes bnftp to emulate a Warcraft II BNE client.

NOTES

       The current version is available with the bnetd distribution at:

	      http://www.bnetd.org/

BUGS

       This program assumes that the terminal will move to the beginning of the current line when the carriage return character (^M)  is  printed.
       It  also assumes the backspace character (^H) will move one column to the left that character printed after that will replace those already
       on the screen.

       The terminal settings are not consulted for keybindings.  The following are assumed:

       ^H     delete the character to the left of the cursor

       ^J     accept current line

       ^M (return)
	      accept current line

       ^T     transpose the last two characters

       ^W     delete word to the left of the cursor

       ^U     delete the whole input line

       ^[ (escape)
	      cancel the current input line

       ^? (delete)
	      delete the character to the left of the cursor

SEE ALSO

       bnetd(1)

AUTHOR

       Ross Combs (ross@bnetd.org)

BNETD
								   11 June, 2000							  BNFTP(1)
All times are GMT -4. The time now is 08:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy