DosTips.com

Hi Antonio, The second code that you supplied worked like a breeze. It took around 20 seconds to generate the output. However the first code didn't succeed in generating the output. It ran for around 6-7 hours but didn't generate any output. I had to break the file into several smaller files in orde...

Hi Antonio, My apologies for providing incomplete or confusing details. I have now given a better description of what I want and a link to a sample file. However the code that you supplied worked like a charm and doing exactly what I asked for. Much appreciated for this. Is it possible to modify the...

Hi guys, I have a csv/text file with a bunch of numbers ranging from 500 to 500,000 and would like to replace the matches with a and mismatches by shifting the mismatched content to right simultaneously shifting the rest of the columns to right but leaving the top row untouched and then replacing th...

Hi guys, I have a batch file that basically does the following each time: -> Types the content of file1 into a text file (say fileA) -> Then using the content of file1 performs a scan of a folder containing 900 files using an application called clamscan -> Finally it saves the result into the same t...

Hello everyone, Sorry for my delayed response. All of your codes worked perfectly as it should. I can't believe how fast all of your codes work. Just a question is it possible to use a matrix to generate the common substrings? I have an IDENTITY (scoring) matrix which could be used to generate commo...

Hello all, @DosItHelp, thank you for the link. I will give that a try. @aGerman, is there anyway a hybrid (i.e. a combination of batch script or VBScript or JScript) could resolve the string limit issue? Or by splitting the string into several smaller strings? @Aacini and @dbenham, I need your take ...

Hi guys, I am trying to find common substrings between two strings using one to one alignment. My input will be two strings coded in A-Z characters. A best example is demonstrated below: Input: String1 GIGRGRGIGRGRGGDGARGRHRGRGRHRGRQRGIGKMKMIGKMKMIGKMKMIGKMKMIGRPRGIGRHRIIGRGRGIGRGRHIGKHKIIGRHRIIGRGR...

Hello guys,

Codes from both of you work perfectly. @elzooilogico, your hybrid code is amazing. Super fast!!

Thanks, guys.

Plasma33

Hello guys, I would like to extract substrings from raw strings, please. Input text file will contain the raw strings (I have around 200,000 lines of that). Ouput text file will only have the extracted substrings. Please see below for more details: Sample input text file: ---------------------------...

Thanks guys!!

Plasma33

Hello Aacini,

Yes, it does. Thanks for the modified code. You are a life saver!!

Plasma33

@Aacini, you are a legend! Your code works like a charm. Fast and accurate!! Thanks heaps!!

Plasma33

@Aacini, thanks for your code. It works like I wanted. I love how it shows the number of lines that it has processed. Also, I love how your code divides each line into a separate text file. And on top of it, your code does the processing much faster than my one. It did the processing in under 5mins ...

Hello again, I would like to extract specific strings from a set of aligned strings. That is, I would like to extract only the aligned single string that is exactly matched to one another from several sets of aligned multiple strings avoiding gaps (i.e. hyphens). Please see below for a better pictur...

@rojo, your code works like a charm too. Thanks for a more efficient code.

Plasma33