hi,
i have data in column c.
I want to check if the sentences in c contains minimum three numbers continuously (0-9) without space and any special characters. it has to be clear minimum 3 digits. if it contains 3 digits, i need result in column F as the "sentence has number" Or if it does not contains the number then result should be "JUNK" '
e.g
C1 1 RENEWAL;30 OCT 2 F1 JUNK
C2 1 Renewal=240600/46/14/85dddddd96 2 F2 sentence has number
C3 1 renewal0 2 jiosaid010286 3 yashwantshah 4 prm.r.s.17967 F3 sentence has number
C4 1 RENEWAL500000, 2 F4 sentence has number
C5 1 RenewalDated 28-10-2015 2 F5 JUNK
C6 1 renewal-phase1 2 F6 JUNK
C7 1 renewal-yes 2 F7 JUNK
C8 1 Renual Nirmalaben harshadrai shah. 2 F8 JUNK
C9 1 renuwal:Nirmalaben Harshadrai shah. 2 F9 JUNK
C10 1 Renwal 2 F10 JUNK
C11 1) Floater Policy in name of Mitesh Shah renewed, 2) F11 JUNK
C12 1) I Renewal PHS ID: NA AMR 22809923 JIO 2) F12 sentence has number
C13 1) jinesh d shah F13 JUNK
C14 1) MADHUBEN S ZAVERI AGE : 77 D.O.B 15.11.1938 2) FALGUNI P SHAH AGE:50. D.O.B 09.08.1965 F14 JUNK
C15 1) MADHUBEN S ZAVERI AGE : 77 D.O.B 15.11.1938 2) FALGUNI P SHAH AGE:50. D.O.B 09.08.1965 UTR NUMBER : KCBL14527000005 F15 sentence has number
Bookmarks