search for: ttta

Hello I have a data frame as below V1 V2 V3 V4 V5 V6 chr1 18884 C CAAAA 2 0 chr1 135419 TATACA T 2 0 chr1 332045 T TTG 0 2 chr1 453838 T TAC 2 0 chr1 567652 T TG 1 0 chr1 602541 TTTA T 2 0 on which I want to perform complex rearrangement such that: if V3 is a string >1 (i.e line 2) then I generate 2 new columns where first new column = V2-1 & second new column = V2+(length of string in V3)+1 therefore, for line 2 output would look like: chr1 135419 TATACA...

...AA GTCAGAA GTCAGCA ACTAGCA GM930026 ACTAGAA GAGTGCA GAGTGCA ACTAGAA GM920031 GATTGCC GTCATCA GATTGCC GATTGCC GM990105 GATTGCC GATTGCC GTCAGCA GTCAGCA GM920202 GATTGCC GATTGCC GATTGCC GATTGCC GM920089 GAGTGCA GTCAGAA ACTATCA GATTGCC GM980051 ACTAGAA ACTAGAA GATAGCC GATAGCC GM930109 GTCATCA GAGTGCA GTTTTAA ACTAGAA GM940039 GTCATCA GAGTGCA GTTTGCC ACTTTCA GM050099 GAGTGCA GTCAGAA GTTATCC ACTTTCA GM050099 GAGTGCA GTCAGAA GTTATCC ACTTTCA GM030005 ACTAGAA GAGTGCA ACTAGAA ACTAGAA GM050009 ACTAGAA GATTGCC GATTGCC ACTAGAA GM990027 GATTGCC GAGTGCA GATTGCA GATTGCC GM990066 GATTGCC GTCATCA GTCATCA GATTGCC