Search results for query: *

Hi , I have a file with ',' as delmiter and structure as x,345,rty,456,yyy x,345,rty,456,yyy x,345,rty,456,yyy x,345,rty,456,yyy x,345,rty,456,yyy x,345,rty,456,yyy I need to append a sequence number as the first character of the line by line number , so that the output should look like ...

All , I have been battling with this issue since yesterday night and it seems I dont understand about BULL COLLECT completely . Attached below is a package within which a table function is created in Oracle9i .Within this Table function a dynamic SQL query gets executed the performance of...

May be I am asking for a lot , even after the solution is in my hands but I am a lil perplexed . Well , I have changed the search string which u had sent by a bit and it works (O\|([^F]| *)\|(CSFPRODLONGB|CSFPRODTOKJP|CSTOKBRTOKJP)\|([^Y]| *))\| *\|)' 1.) But does that mean that "[^Y]" would...

'(O\|[^F]\|X\|[^Y]\| *\|)' This search string is able to bring all values for which field_2<> F or field_4<> Y Yeah , its AND instead of OR . But it doesnt work either. Sac

Agreed Sir , But here we have prepared reusable shell script which accepts the file name , PATERN MATCH string etc etc to search and split the files . So , dont have much control over the type pf scripting .

Hi , I have 5 fields in a flat file named as x with a delimiter as '|' . I pass this expression as a PATTERN SEARCH string as mentioned below ; '(O\|[^F]\|X\|[^Y]\| *\|)' I intend to create a new file y out of x for those records which satisfies the above PATTERN MATCH , but it fails to...

Hi PHV, Thx once again , it is working , but could not understand why '+' is used within the search string. Chao Sachin

Thx , We have some standard UNIX scripts prepared which works only with EGREP , so I need to pass the search criterion in PATTERN MATCH. The characters like '=' & '!=' doesnt work in pattern match . Thx Sachin Rath.

Hi All, I have a file in UNIX with 3 fields in it A ,B C with their names. I would like to search for all the values in the file for which A is NULL and B is not NULL and again A is NOT NULL and B is NULL . NULL refers to a blank value within the delimiters which is '|' in this case. Any...

Yeah , I had checked the space which looks enough . Now I know how to go to a line in a file to follow up with further operations . Thx again Chao Sachin

Thx guys ...it worked . Is this advisable to find & replace in the same way for very huge files as well. Thx Sachin Rath

My file name is x.parm and the last line number of my file is 37 & I need to replace 90 with 91 so I tried sed '37s/90/91/' x.parm > x.parm . Where am I commiting a mistake ??? Sachin

I am having a huge file . I need to find a chaacter only in the last line and replace it with another characted I am not a UNIX expert , so would like do it with SED one liner . Any help is appreciated Thx Sachin Rath

Didnt work either :( I tried in this way "'^CSFPRODLONGB\|IRS\|!=(TRS|ETRS)\|C'". Sachin

Its not working . Sachin

Vowww ur fast PHV . Well! CURRENT PROBLEM ***************** The base file name is F , with 10 attributes and 100 records and delimiter as '|' . I need to split this file into 2 files , on the basis of 3 column values (c_1,c_2,c_3). File 1--> Name F.child1 , if column c_1='CSFPRODLONGB' ...

Hi All, I have a file with name F and 10 fields and 100 records . I need to create a new file name F.child out of this base file F , such that only those records come into the F.child file for which column_2 of file F not in ('AUES','ALDJ'). I am not able to acheive " NOT IN LIST " operation...