Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Removing a character at specific position in a column
Operating Systems Linux Removing a character at specific position in a column Post 302957565 by RavinderSingh13 on Tuesday 13th of October 2015 01:45:08 AM
Old 10-13-2015
Hello Syeda,

If you want to only substitute $2's _ present at last of $2then following may help you. As you had mentioned in first post that you need to substitute other columns _ too so I have taken POST#2 example, please try following and let me know if this helps you.
Input_file:
Code:
cat Input_file
Ravinder gi_49482297_ref_YP_039521.1_ TESTing test123 sizth_column_ seventh eight_column_test
TEST121 gi_49482297_ref_YP_039521.1_ TESTing test123 sizth_column_ seventh eight_column_test
TEST1211 gi_49482315_ref_YP_039539.1_ TESTing test123 sizth_column_ seventh eight_column_test
TEST12134 gi_49482315_ref_YP_039539.1_ TESTing test123 sizth_column_ seventh eight_column_test

Code:
awk '{sub(/\_$/,X,$2);print}'  Input_file

Output will be as follows.
Code:
Ravinder gi_49482297_ref_YP_039521.1 TESTing test123 sizth_column_ seventh eight_column_test
TEST121 gi_49482297_ref_YP_039521.1 TESTing test123 sizth_column_ seventh eight_column_test
TEST1211 gi_49482315_ref_YP_039539.1 TESTing test123 sizth_column_ seventh eight_column_test
TEST12134 gi_49482315_ref_YP_039539.1 TESTing test123 sizth_column_ seventh eight_column_test

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
Syeda Sumayya
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to add character in specific position of a string?

Hi All, I would like to use sed to add "-" between the following string: Value: 20060830 Result: 2006-08-30 Pls advice. Thx a lot Victor (5 Replies)
Discussion started by: victorlung
5 Replies

2. 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

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 (1 Reply)
Discussion started by: manaswinig
1 Replies

4. 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

5. 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

6. Shell Programming and Scripting

using awk removing newline and specific position

Hello Friends, Input File looks as follows: >FASTA Header1 line1 line2 line3 linen >FASTA Header2 Line1 Line2 linen >FASTA Header3 and so on ....... Output: Want something as: >FASTA Header1 line1line2line3linen >FASTA Header2 (5 Replies)
Discussion started by: Deep9000
5 Replies

7. Shell Programming and Scripting

Removing 0 from a specific position - if it exists

I have a file that I need to parse using a script. The dates in the file are displayed in the format: Mar 2, 2011 9:09:31 PM I have tried using the date command %e and %l but it pads an extra space for the day and hour if they are single digits. So this I used a normal date command: ... (6 Replies)
Discussion started by: crazyideas
6 Replies

8. 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

9. 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

10. Shell Programming and Scripting

Count specific character of a file in each line and delete this character in a specific position

I will appreciate if you help me here in this script in Solaris Enviroment. Scenario: i have 2 files : 1) /tmp/TRANSACTIONS_DAILY_20180730.txt: 201807300000000004 201807300000000005 201807300000000006 201807300000000007 201807300000000008 2)... (10 Replies)
Discussion started by: teokon90
10 Replies

LEARN ABOUT OPENSOLARIS

langinfo

langinfo.h(3HEAD)						      Headers							 langinfo.h(3HEAD)

NAME

       langinfo.h, langinfo - language information constants

SYNOPSIS

       #include <langinfo.h>

DESCRIPTION

       The  <langinfo.h>  header  contains  the constants used to identify items of langinfo data (see nl_langinfo(3C)). The type of the constant,
       nl_item, is defined as described in <nl_types.h>.

       The following constants are defined. The entries under Category indicate in which setlocale(3C) category each item is defined.

		       |		|
	  Constant     |   Category	|		 Meaning
       ----------------+----------------+----------------------------------------
       CODESET	       |LC_CTYPE	|codeset name
       ----------------+----------------+----------------------------------------
       D_T_FMT	       |LC_TIME 	|string for formatting date and time
       ----------------+----------------+----------------------------------------
       D_FMT	       |LC_TIME 	|date format string
       ----------------+----------------+----------------------------------------
       T_FMT	       |LC_TIME 	|time format string
       ----------------+----------------+----------------------------------------
       T_FMT_AMPM      |LC_TIME 	|a.m. or p.m. time format string
       ----------------+----------------+----------------------------------------
       AM_STR	       |LC_TIME 	|ante-meridiem affix
       ----------------+----------------+----------------------------------------
       PM_STR	       |LC_TIME 	|post-meridiem affix
       ----------------+----------------+----------------------------------------
       DAY_1	       |LC_TIME 	|name of the first day of the week  (for
		       |		|example, Sunday)
       ----------------+----------------+----------------------------------------
       DAY_2	       |LC_TIME 	|name of the second day of the week (for
		       |		|example, Monday)
       ----------------+----------------+----------------------------------------
       DAY_3	       |LC_TIME 	|name of the third day of the week  (for
		       |		|example, Tuesday)
       ----------------+----------------+----------------------------------------
       DAY_4	       |LC_TIME 	|name of the fourth day of the week (for
		       |		|example, Wednesday)
       ----------------+----------------+----------------------------------------
       DAY_5	       |LC_TIME 	|name of the fifth day of the week  (for
		       |		|example, Thursday)
       ----------------+----------------+----------------------------------------
       DAY_6	       |LC_TIME 	|name  of the sixth day of the week (for
		       |		|example, Friday)
       ----------------+----------------+----------------------------------------
       DAY_7	       |LC_TIME 	|name of the seventh  day  of  the  week
		       |		|(for example, Saturday)
       ----------------+----------------+----------------------------------------
       ABDAY_1	       |LC_TIME 	|abbreviated  name  of	the first day of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_2	       |LC_TIME 	|abbreviated name of the second  day  of
		       |		|the week
       ----------------+----------------+----------------------------------------

       ABDAY_3	       |LC_TIME 	|abbreviated  name  of	the third day of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_4	       |LC_TIME 	|abbreviated name of the fourth  day  of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_5	       |LC_TIME 	|abbreviated  name  of	the fifth day of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_6	       |LC_TIME 	|abbreviated name of the seventh day  of
		       |		|the week
       ----------------+----------------+----------------------------------------
       ABDAY_7	       |LC_TIME 	|abbreviated  name of the seventh day of
		       |		|the week
       ----------------+----------------+----------------------------------------
       MON_1	       |LC_TIME 	|name of the first month of the year
       ----------------+----------------+----------------------------------------
       MON_2	       |LC_TIME 	|name of the second month
       ----------------+----------------+----------------------------------------
       MON_3	       |LC_TIME 	|name of the third month
       ----------------+----------------+----------------------------------------
       MON_4	       |LC_TIME 	|name of the fourth month
       ----------------+----------------+----------------------------------------
       MON_5	       |LC_TIME 	|name of the fifth month
       ----------------+----------------+----------------------------------------
       MON_6	       |LC_TIME 	|name of the sixth month
       ----------------+----------------+----------------------------------------
       MON_7	       |LC_TIME 	|name of the seventh month
       ----------------+----------------+----------------------------------------
       MON_8	       |LC_TIME 	|name of the eighth month
       ----------------+----------------+----------------------------------------
       MON_9	       |LC_TIME 	|name of the ninth month
       ----------------+----------------+----------------------------------------
       MON_10	       |LC_TIME 	|name of the tenth month
       ----------------+----------------+----------------------------------------
       MON_11	       |LC_TIME 	|name of the eleventh month
       ----------------+----------------+----------------------------------------
       MON_12	       |LC_TIME 	|name of the twelfth month
       ----------------+----------------+----------------------------------------
       ABMON_1	       |LC_TIME 	|abbreviated name of the first month
       ----------------+----------------+----------------------------------------
       ABMON_2	       |LC_TIME 	|abbreviated name of the second month
       ----------------+----------------+----------------------------------------
       ABMON_3	       |LC_TIME 	|abbreviated name of the third month
       ----------------+----------------+----------------------------------------
       ABMON_4	       |LC_TIME 	|abbreviated name of the fourth month
       ----------------+----------------+----------------------------------------
       ABMON_5	       |LC_TIME 	|abbreviated name of the fifth month
       ----------------+----------------+----------------------------------------
       ABMON_6	       |LC_TIME 	|abbreviated name of the sixth month
       ----------------+----------------+----------------------------------------
       ABMON_7	       |LC_TIME 	|abbreviated name of the seventh month
       ----------------+----------------+----------------------------------------
       ABMON_8	       |LC_TIME 	|abbreviated name of the eighth month
       ----------------+----------------+----------------------------------------
       ABMON_9	       |LC_TIME 	|abbreviated name of the ninth month
       ----------------+----------------+----------------------------------------
       ABMON_10        |LC_TIME 	|abbreviated name of the tenth month
       ----------------+----------------+----------------------------------------
       ABMON_11        |LC_TIME 	|abbreviated name of the eleventh month
       ----------------+----------------+----------------------------------------
       ABMON_12        | LC_TIME	|abbreviated name of the twelfth month
       ----------------+----------------+----------------------------------------
       ERA	       |LC_TIME 	|era description segments
       ----------------+----------------+----------------------------------------

       ERA_D_FMT       |LC_TIME 	|era date format string
       ----------------+----------------+----------------------------------------
       ERA_D_T_FMT     |LC_TIME 	|era date and time format string
       ----------------+----------------+----------------------------------------
       ERA_T_FMT       |LC_TIME 	|era time format string
       ----------------+----------------+----------------------------------------
       ALT_DIGITS      |LC_TIME 	|alternative symbols for digits
       ----------------+----------------+----------------------------------------
       RADIXCHAR       |LC_NUMERIC	|radix character
       ----------------+----------------+----------------------------------------
       THOUSEP	       |LC_NUMERIC	|separator for thousands
       ----------------+----------------+----------------------------------------
       YESEXPR	       |LC_MESSAGES	|affirmative response expression
       ----------------+----------------+----------------------------------------
       NOEXPR	       |LC_MESSAGES	|negative response expression
       ----------------+----------------+----------------------------------------
       YESSTR	       |LC_MESSAGES	|affirmative response for yes/no queries
       ----------------+----------------+----------------------------------------
       NOSTR	       |LC_MESSAGES	|negative response ro yes/no queries
       ----------------+----------------+----------------------------------------
       CRNCYSTR        |LC_MONETARY	|local currency symbol, preceded by  '-'
		       |		|if  the  symbol sould appear before the
		       |		|value, '+' if the symbol should  appear
		       |		|after	the  value, or '.' if the symbol
		       |		|should replace the radix character

       If the locale's values for p_cs_precedes and n_cs_precedes do not match, the value of nl_langinfo(CRNCYSTR) is unspecified.

       The <langinfo.h> header declares the following as a function:

	 char *nl_langinfo(nl_item);

       Inclusion of <langinfo.h> header may also make visible all symbols from <nl_types.h>.

USAGE

       Wherever possible, users are advised to use functions compatible with those in the ISO C standard to access items of langinfo data. In par-
       ticular, the strftime(3C) function should be used to access date and time information defined in category LC_TIME. The localeconv(3C) func-
       tion should be used to access information corresponding to RADIXCHAR, THOUSEP, and CRNCYSTR.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Standard			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mkmsgs(1), localeconv(3C), nl_langinfo(3C), nl_types.h(3HEAD), setlocale(3C), strftime(3C), attributes(5), standards(5)

SunOS 5.11							    30 Aug 2002 						 langinfo.h(3HEAD)
All times are GMT -4. The time now is 01:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy