How to remove a char before a pattern?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove char if not a number

I need to write a BASH script that takes a 2 character string and removes the second character if it is not a digit e.g. If the string is numberical value >9 e.g. string1 = '34' then leave string1 = '34'. However if the string is <10 e.g. string1 = '3X' then remove the second char (which...

2. UNIX for Dummies Questions & Answers

Remove newline char from variable

I have a file ABC.DAT with 2 columns avaialble Data format : XYZ!$#$!120 XXZ!$#$!1000 YYZ!$#$!104 While running the following code : FILE_COUNTER=1; RECORD_CN_FILE_COUNT=$((`wc -l ABC.DAT| cut -f1 -d' '`)); while do FILE_NAME=`cat ABC.DAT.DAT| head -$FILE_COUNTER |tail -1 | awk -F...

3. Shell Programming and Scripting

To get char between pattern

hi, this my text ...................... Read 21 physical / 21 logical HMMs Read lattice with 16 nodes / 36 arcs Created network with 53 nodes / 73 links File: speech.mfc !sil two eight six nine six eight !sil == -68.5133 (Act=50.4)...................... i need to extract output text...

4. Shell Programming and Scripting

How to remove the # char form a line?

Hi, my file has below details and I want remove the # char from only specific line. #TEST:00:START #TEST1:01:INPROCESS #TEST2:02:ABOUTTO #TEST3:03:COMP i.e if want remove the # from 2nd line then file to be updated as #TEST:00:START TEST1:01:INPROCESS #TEST2:02:ABOUTTO...

5. Red Hat

How to remove a special char using sed

consider this is my sample file format. in this i want to remove ^@ with space . please help me in this problm 7305,1310184890,0,0,12,201370,FCASTBHBR0 ,XX ,2,1,2,0,^@,1,1,0,3,1303862400,0,1577923199,1,10,FCASTOR SEED EX-BHABHAR ...

6. UNIX Desktop Questions & Answers

Help me to remove junk char

I wanted to remove junk char in my csv. :mad: Input file format: "17","9986782190","0","D","2" "17","9900918331","0","D","2" "13","9986782194","0","A","2" Output file format 9986782190 9900918331 9986782194 And one more thing all the time "13"," this will be different Ex: .

7. Shell Programming and Scripting

Remove char after Colon

Hi guys, This is my input 2735:<7001> 34 789 701 2 2774:<7001> 34 789 701 2 How to delete characters after colon : Including colon : too ? My output should...

8. Shell Programming and Scripting

can I remove the first char using AWK?

Hi everyone, suppose that I have the following line: #test your knowledge can I use AWK to print the word "test" only? without the #? what should I change to this: awk '{print $1}' thanks in advance guys

9. Shell Programming and Scripting

Help needed to remove a char from a specified sub-string

Hi! I'm having trouble usind sed to remove the char ' from within a database's varchar register's sql. For example, on the following sql: INSERT INTO patrimonio_municipal.patrimonio_municipal_airc_tmp Values('|Esta��o Elevat�ria|',|16723|,'|Grandes Repara��es|', '|2010-03-26...

10. Shell Programming and Scripting

How to remove new line char from a string

Hi Can anyone tell me how can i remove new line character from a string. My requirement is to read a line from a file and store it to a string. read line string1=$line read line string2=$line echo $string1$string2 The result i am getting in different line. i want the output in the same...

LEARN ABOUT REDHAT

select_into

SELECT 
INTO(7)							   SQL Commands 						    SELECT INTO(7)

NAME

       SELECT INTO - create a new table from the results of a query

SYNOPSIS

       SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
	   * | expression [ AS output_name ] [, ...]
	   INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
	   [ FROM from_item [, ...] ]
	   [ WHERE condition ]
	   [ GROUP BY expression [, ...] ]
	   [ HAVING condition [, ...] ]
	   [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
	   [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
	   [ LIMIT { count | ALL } ]
	   [ OFFSET start ]
	   [ FOR UPDATE [ OF tablename [, ...] ] ]

   INPUTS
       TEMPORARY

       TEMP   If specified, the table is created as a temporary table.	Refer to CREATE TABLE [create_table(7)] for details.

       new_table
	      The name (optionally schema-qualified) of the table to be created.

       All other inputs are described in detail for SELECT [select(7)].

   OUTPUTS
       Refer to CREATE TABLE [create_table(7)] and SELECT [select(7)] for a summary of possible output messages.

DESCRIPTION

       SELECT  INTO creates a new table and fills it with data computed by a query. The data is not returned to the client, as it is with a normal
       SELECT. The new table's columns have the names and data types associated with the output columns of the SELECT.

	      Note: CREATE TABLE AS [create_table_as(7)] is functionally equivalent to SELECT INTO.  CREATE TABLE AS is  the  recommended  syntax,
	      since SELECT INTO is not standard. In fact, this form of SELECT INTO is not available in PL/pgSQL or ecpg(1), because they interpret
	      the INTO clause differently.

COMPATIBILITY

       SQL92 uses SELECT ... INTO to represent selecting values into scalar variables of a host program, rather than creating a  new  table.  This
       indeed  is  the	usage  found in PL/pgSQL and ecpg(1).  The PostgreSQL usage of SELECT INTO to represent table creation is historical. It's
       best to use CREATE TABLE AS for this purpose in new code.  (CREATE TABLE AS isn't standard either, but it's less  likely  to  cause  confu-
       sion.)

SQL - Language Statements					    2002-11-22							    SELECT INTO(7)

UNIX for Advanced & Expert Users