Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Remove empty lines
Hi P5wizard, May I ask what you mean " by adding "od -xc" on the same excerpt of the file and post the output back here"? Sorry, I am still a green beginner in this area :) Maybe I explain a little about my files. 1)I extracted data from certain columns in Excel tables and saved it as... -
Remove empty lines
Hi PHV Your suggestions did not work either. Is it because I am using nawk on Sun OS? curious1 -
Remove empty lines
Hi Annihannic Thanks for replying. I tried your command but it did not change anything in my file either. Any alternatives :) curious1 -
Remove empty lines
Hi I am trying to remove empty lines in my file using: sed '/^$/d' file.txt However, nothing seems to be removed. Can you help me here please :) my file looks like this: 3621 PSMD5 NM_005047 23626 NELL2 NM_006159 23633 23643 CAPN2 NM_001748 23661 PIAS4 NM_015897 23684 STMN1 NM_005563... -
AWK error
Thank you Feherke and p5wizard. I 've tried both your suggestions but I still get the error message. When I execute using nawk I get error saying: syntax error at source line 1. context is awk >>> ' <<< nawk bailing out at source line 1 So does that mean single quote is an invalid char to use... -
AWK error
Hi, I am very lost with the errors I get when I execute a previously used command. Though it worked before but now a problem. Is single quote not allowed on some machines? Can anyone help me? The error message is: syntax error near line 1 bailing out near line 1 The script I used is: awk '... -
How can I manage -extract and join large datasets
Hi futurelet, Thank you for the code and solving my problems. It works fine :) have a nice day curious k -
How can I manage -extract and join large datasets
Hi futurelet, below is the sample data(tab separated): Table 1: counter N_ID S_ID value1 value2 value3 value4....valu13 4418255 n-1a b0061 NULL NULL 1013 1035 1025 1019 NULL NULL 80 115 63 102 yes 4418256 n-1a b0396 NULL NULL 420 684 388 663 NULL NULL 39 86 38 86 yes 4418257 n-1a b1620 NULL... -
How can I manage -extract and join large datasets
Hi I am writing again with regards to my previous query (Need help to extract and join...). I tried the code provided by PH, it works fine with my example. However, when I used it on my actual data tables it produced no result, although there should be matches between the 2 files. The 2 Tables... -
Need help to extract and join 2 tables with AWK script
Hello PH, Thank you for your previous code. I tried and it works fine for my example. However when I tried on larger files it always generate no results or matches although there should be matches.Could you help me again? I am pretty new with AWK and am quite lost. Appreciate it if you could... -
Need help to extract and join 2 tables with AWK script
Hi Everyone, I am new to AWK and need alittle help! I have 2 tables and I need to extract and join them to one, based on a common identifier in both tables. Example: Table 1: S/N vial_ID S_ID value_1 value_2 1 v11 f1001 567 789 2 v12 f2087 786 567 Table2: name...
