Search Results

Hi disedorgue,

Thank you very much. It works great on my real data. :b:

Hi,

I am trying to transpose rows to columns for thousands of records. The problem is there are records that have the same lines that need to be separated. the input file as below:-

...

Hi Chubler_XL,

The codes worked perfectly on my real data!. So, split function can be used to get selected lines. Thank you very much!. :b:

Hi,

I need help on a complicated file that I am working on. I wanted to extract important info from a very huge file. It is space delimited file. I have hundred thousands of records in this file....

Hi Pravin27,

Thanks a lot! It really works perfectly on my real data. New things in the codes that interest me like asort function. I am wondering about the input file being written twice there...

Hi,

I need help to convert rows in input file into a table.

inputfile


192.98.1 192.98.192.98.17 VVC family Zorro 10
192.98.1 192.98.192.98.17 VVC...

Hi Aia,

great..thanks so much! :)

---------- Post updated at 10:04 PM ---------- Previous update was at 10:02 PM ----------



Hi disedorgue,

Thanks for the info. Just fixed the sample...

Hi Scrutinizer,

Thanks a lot! your code is a lot shorter and clean. but i have a problem with R=(S1>Q1) ? Ql/Sl : Sl/Ql . Some of the results give me negative values and i know why. So, i used my...

Hi,

The below awk script that i did is working fine. It gives me the results that i want. But, the script is not smart and very long as i have 8 conditions to meet. The sample script below only...

Hi shamrock,

It worked as expected. I just need to add OFS="\t" at the end. thanks a lot! :)

---------- Post updated at 01:12 PM ---------- Previous update was at 01:11 PM ----------



Hi...

Hi,

I am trying to extract some patterns from a line. The input file is space delimited and i could not use column to get value after "IN" or "OUT" patterns as there could be multiple white spaces...

Hi Don Crugan,

No, it is not what i meant. Actually I prefer your code the most because my results are very clean and clear and much better than what i expected to have in the beginning. Before u...

Hi Don Crugan,

This code worked awesome!! I tried on my real data and the results are perfect. Thanks so much for your detail explanation too. I was working on codes by RavinderSingh13. It worked...

Hi Don,

forgot that one. sorry bout that. it should be the second one: - Yes[/QUOTE]

thanks.

---------- Post updated at 09:23 AM ---------- Previous update was at 08:58 AM ----------

Hi...

Hi,

I need help to match two files based on two columns.

file_1


ID AA An Ca Ele Pro Su Ot Tra
g13950 No No Yes No Yes Yes Yes Yes
g05760 Yes No No No No Yes Yes Yes...

cool... thanks a bunch... now i get it ;)

Hi Scrutinizer,

It worked awesome!!! and thanks so much for your explanation. I might sound stupid, but, i don't understand why the second array (F[2]) is the first text in parenthesis? what is...

Hi,

i need help to extract certain strings/words from lines with different length. I have 3 columns separated by tab delimiter. like below


Probable arabinan endo-1,5-alpha-L-arabinosidase...

Hi R. Singh,

Yeah..it worked perfectly too. Thanks so much :b:

Yeah, it worked great too.. :b: Thanks Chubler_XL..

Yeah.. tried both and it works great too. A little bit complicated to understand compared to the first one. But I am glad that it gives something for me to think of. Thanks. :D

Hi Akshay Hegde,

Thanks a bunch! It worked great.. :)

Hi,

I need help to split any lines that contain ; or ,

input.txtAc020 Not a good chemical process
AC030 many has failed, 3 still maintained
AC040 Putative; epithelial cells
AC050 ...

I am so sorry, the code worked great! it was a typo when i write the code into my real file. So, pls ignore my previous post (will delete it though). Thanks a ton for you help.

Hi RudiC,

Thanks so much for your prompt response. The func <tab> null is always on the last occurrence for duplicate func in each record. Tried your code, but it removes func<tab>null in other...