Summary: I'm assuming you meant to say that after parsing the data into 2 columns by pipe symbol that the second column was then parsed by commas. Maybe the sc...
Summary: Hi, How do I append the filename to the end of every rows in a text file? my filename is ABC exiting lines CUPD|0|20205|FALSE|FALSE|International CUPD...
Summary: Hi Bill, this is easy in sed just sed -n '3p' fileA But it didn't realy delete the rows in fileA just print's the 3 row. So a redirection of the out p...
Summary: Hi - How can I use awk to take names (i.e. D,Liz W,Frank) listed in one row and display in a column? First and Last Name are seperated by a "," and a ...
Summary: Hi , Can any one of you tell me how to find the 5 characters after the 5th occurance of a ","(comma) in a data file for all the rows of the file. As ...
Summary: Hi all, I have written one shell script. The output file of this script is having sql output. In that file, I want to extract the rows which are havin...
Summary: We are facing peculiar problem in a PRO*C program. We have following environment. Operating System : SUN SPARC SOLARIS 2.6 ORACLE Enterprise Server v...
Summary: Hi there I have a file which I wish to sort the rows in and then remove lines that are a subset of other lines. For example, in the text file conta...
Summary: relatively new to this. Hope someone can help me. I need to read from a file. 11 columns, each column is separated by a space. contains numercial valu...
Summary: Thanks for all your help. I tried to run it on one file but the rows that satisfy the condition are not deleted. Any suggestion or how to use the sh...
Summary: Just return the row count from sqlplus. Then the while-loop can break out of the loop when the count is zero or when it determines that it is after 0...
Summary: Back from weekend .. with Problems Now a script that shows the problem precise, I hope. If I use only echo the result is who I need the row. In the ot...
Summary: To all unix expert, I need your help to write a script that will identify and delete duplicate records. Examples: File 1 (comma separated) contains: ...
Summary: HI , I have input like this A B C 104|1|1 101|1|2 103|1|2 100|1|3 102|1|3 107|2|1 100|2|3 106|2|3 108|3|1 103|3|3 102|3|6 I need to compare all...
Summary: -- while read LINE do #tempvar=`echo $LINE` var=`echo $LINE|cut -c 2-4` echo $var sum=`expr $sum + $var` done<$FN -- This script is to cut values ...
Summary: hi, I have a table containinng around 70,000 rows and 2 coloumns. the table is updated every day.(new rows will be added and some rows will be deleted...
Summary: Hi, How would you do the above with a file that has a variable number of columns? Actually, the rows on the file are keyed, that's why I thought to u...
Summary: Hello Everybody!!!!!!!!! Request you to help me with the below mentioned issue: I have 2 files say, File 1: a|4|7 b|3|2 c|8|8 d|8|9 File 2: a|4|6 b|2|...
Summary: hi, sorry for alway post the question, my question is that i want to searh a record in the table. But i don't want to display out the entire row or c...
Summary: Hi, I have a text file with the data in rows the data file has specfic pattern of rows I need to convert first 3 lines of rows into columns by doing a...
Summary: I need a script to uodate the entries, there are 5 entries per row, the script needs to be able to edit an individuak entry, add/del a whole row. Cons...
Summary: Hi! How to extract and separate multiple rows result from a query? I know how to do it for multiple columns, as we can specify the separator and use...
Summary: Hi. I would like to be able to update only one line in a file that matches a key using sed, but I can't seem to get this (the key is right at the begi...