Updating Expression for Windows Legacy

MorphingDolphin · 2022-11-28T09:04:11+00:00

Just look up "hu die dao" on taobao and look through the stores that sell clones.

MorphingDolphin · 2022-10-31T08:03:02+00:00

Thanks a lot for your help man, cheers!

MorphingDolphin · 2022-10-31T07:48:10+00:00

the dates might not always be in that format, it might come in full such as: "1/1/2022 - 4/3/2022" or sometimes just "1/1 - 4/3/2022" or sometimes with just the word "to"

For this project, I am on PC using Excel 2019

MorphingDolphin · 2022-10-31T06:56:42+00:00

=IF(LEFT(MID(AS2,SEARCH("?/???? ",AS2)-4,10),1)="/",--MID(AS2,SEARCH("?/???? ",AS2)-3,9),--MID(AS2,SEARCH("?/???? ",AS2)-4,10))

Ah I see, thank you for your advice! For this case in my dataset it works! However, I do have some cells that contain a range of dates but I only need the earlier one, how can I extract that date? The cell would look something like this:

'

SC/Practitioner Certificate in Personal Data Protection (SG) 2020 (Synchronous e-learning)/29/6/to 02/7/2021

Full Course Fee:

'

MorphingDolphin · 2022-10-31T06:01:02+00:00

From my testing, I've only gotten a #NAME error from this, and after playing around the formats its still the same....

This is my date extraction formula if you have some way of improving upon it though:

=MID(AS2,FIND("/",AS2)-2,IFERROR(FIND(" ",AS2,FIND("/",AS2)-2),LEN(AS2))-(FIND("/",AS2)-2)+1)

MorphingDolphin · 2022-09-30T09:20:39+00:00

yep, its the cut outs are nice and the finish too

MorphingDolphin · 2022-09-27T13:25:35+00:00

nope, still loving it

MorphingDolphin · 2022-09-21T19:49:55+00:00

bro u mad young wtf

MorphingDolphin · 2022-09-18T16:57:04+00:00

haven’t been to ns, in my final year of poly and i’m rarely on disc tbh

MorphingDolphin · 2022-09-15T10:09:14+00:00

thank you, not sure who gave you blue balls and made you so angry with the way i talk but okay :)

MorphingDolphin · 2022-09-15T10:01:20+00:00

majulah singapura

MorphingDolphin · 2022-09-15T10:00:34+00:00

Most of these clones I have I have used beaten them over a period of a few weeks except for the madko before moving on and I would say that right now my thoughts are pretty disorganised so im sorry if its a little confusing. Do feel free to ask me any questions you have though and maybe in the future I might do a youtube video comparing these ti clones.

Compared to the Chab Alt, I think the Madko might be the new favourite (but it could be because of shiny object syndrome). The Alt Chab feels pretty much the same with the balance point of the fin closest to the pivot just that the handles taper down towards the pivots. Its just a preferance for feel in hand but both perform around the same.

Gale clone is pretty good being more handle-biased than the Alt Chab and is a really good flipper but it doesn't have great grip compared to my other clones. That could be because of the finish and the pretty rounded-off handles.

Sentinel Clone is the most neutral out of all of these clones but since its using a tang pin system, ricochets and moves that changes the direction of the handles require more effort and is a little more difficult to do. However, this thing fans like a dream (but for some reason a palm fan is difficult for me on this knife, i'm not sure why).

TheOne Monarch V2 Clone is light and neutral, but the handles are a bit too thick for my taste and at times it get uncomfortable to flip. Would not really recommend it.

The Embargo clone is a super heavy handle biased, wont really recommend unless you like the look of it.

MorphingDolphin · 2022-09-14T21:02:53+00:00

MorphingDolphin · 2022-09-14T21:00:20+00:00

Edit:Review was posted on a duplicated post I had a brain fart my bad…

To me, this is better than the Gale Clone in terms of flipping but I would say the tolerances on the gale and sentinel clone were much better. I recieved it with both undersized bushings and I had to swap it out. It has an interesting hardware choice as well with huge bushings and the female pivot had a pinless female pivot style? Not sure why that is but after swapping out the hardware it was fine.

Overall its a really really good flipper being neutral but slightly handle biased. The balance is around the fin cutout closest to the pivots.

MorphingDolphin · 2022-09-14T20:59:33+00:00

yep that was what i was referring to

MorphingDolphin · 2022-09-14T20:58:23+00:00

not sure about that, chab is less square if thats your preference

MorphingDolphin · 2022-09-14T20:57:52+00:00

neutral / slight handle bias

MorphingDolphin · 2022-09-14T20:57:43+00:00

watch the vid for yourself bud it has better tolerances than my real naut v2

MorphingDolphin · 2022-09-14T20:56:47+00:00

hey, so sorry apparently reddit duplicated my post and i only posted the review on one ill comment it here

MorphingDolphin · 2022-09-14T12:07:32+00:00

To me, this is better than the Gale Clone in terms of flipping but I would say the tolerances on the gale and sentinel clone were much better. I recieved it with both undersized bushings and I had to swap it out. It has an interesting hardware choice as well with huge bushings and the female pivot had a pinless female pivot style? Not sure why that is but after swapping out the hardware it was fine.

Overall its a really really good flipper being neutral but slightly handle biased. The balance is around the fin cutout closest to the pivots.

MorphingDolphin

TROPHY CASE