extracting expesific data from prodoct list

xsessive · Apr 6, 2013

hi,

I work for a hardware distributrand i recently got a list of products from a new supplier. The data came in a sheet so i used an ocr sofware (abby fine reader) to transfer it to excel.

But like aways it was not 100% accurate and left a lot dots and symbols 1 or 2 infront of the product names. While a minor anoance , i would like to know of a way to extrack that just the names on the description ,which may be hard cause they have specs like size on the description as well.

"1/2X1/2 SHARK BITE STRGHT COUP

**PVC TOILET 3/8COMPX7/8BC X16

■VINYL TUBE 3/4ID 1 OD X50FT

♦SEAL FOR FLUIDMASTER 242

-the underlined items are the ones im refering to

i will include the full list below- note not all rows have the issue ,thanks in advance, love the helpfull videos

Product Description

"1/2X1/2 SHARK BITE STRGHT COUP

"1G STD BLANK PLATE IVORY

"2G STD DOUBLE DUPLEX PLATE WHITE

"9V DC ION SMOKE ALRAM 1PK

"BONE TOILET SEAT PLASTIC - ROUND

"BONE TOILET SEAT WOOD - EL

"BONE TOILET SEAT WOOD - ROUND

"BRASS FLARE TEE 1/2

"COMPRESSION NEEDLE VALVE 1/4

"COMPRESSION TEE 3/8

"CP ABS SHWR HD W/BR B/JOINT

"CPVCTRANS ADPT 1/2 SOCXMIP

"GRAB BAR EXP SCREW 1-1/2”X36"

"GRAB BAR EXP SCREW 1-1/2X18

"MALE ADAPT 3/8 FLAREX3/8 MIP

"MAPP/PROPANE SELF LIGHT TRDSMN

"MASKING TAPE 2 X 60

"MASSAGE SHOWER HEAD

"PLB PFT CLST BLTS 5/16 REG

"PREMIER FLEX COUPLING 2X2

"PREMIER FLEX COUPLING 3X3

"PREMIER FLEX COUPLING 4X3

"PREMIER FLEX COUPLING 4X4

"PREMIER PIPE DOPE 8 OZ

"PREMR FLEX COUP 1-1/2X1-1/2

"PROPANE FUEL CYLINDR 14.1 OZ

"PVC LAV 3/8COMP X 1/2FIP X16

"SHOWER HEAD CP ABS BOX

"SHOWER ROD POL ALUM 6 FT

"SUBMERSIBLE UTILITY PUMP

"UPPER T/STAT HI LIMIT

"WALLPLT, 1G, 1.40 OPNG, IV

"WHT TOILET SEAT PLASTIC

"YELLOW TEFLON TAPE 1/2X260

#308433 Map/Pro Gas Cylinder 14.1 oz.

#6 REG LOCK WASHER ZINC

*#2 CUT CASE BOTTOM BOX

**1/2 X 1/2 FNPT SHARK BITE STRGHT CONN

**1/2X1 /2 SHARK BITE STRGHT COUP

**1G STD DUPLEX RECEPTACLE PLATE WHITE

**2" DAL-CAP

**30 AMP TYPE TL TIME DELAY FUSE

**45* ELBOWCXC 1/2

**50" TALL STEEL HAND TRUCK

**62" ADJUST SHWR ROD WHITE

**BONE TOILET SEAT PLASTIC - ROUND

**CLOG BUSTER 1-1/2 TO 3 DRAIN

**CPVC 90* ELL S X S 1/2

**DIAPHRAM WELL TANK 20 GAL

**DWV PVC TEST TEE C/O W/PLG 2

**FGG CPVC 90* ELL 1/2

**FILL PRO FILL VALVE REG

**GALV 90* ELBOW 1/2

**ICE MAKER KIT 15FT COPR TUBE

**MOP/BUCKET WRINGER 32 QT

**PLAS SEAT WHT OPN FRT ELONG

**POLY TUBE 11/64ID 1/40DX100

**PVC TOILET 3/8COMPX7/8BC X16

**ROMEX CONNECTOR 3/8

**SS HOSE CLAMP 13/16 TO 1-1/2

**SS LAV 1/2FIP X 1/2 FIP X 20

**TOWEL BAR CP EXP SCREW 24

**WHT TOILET SEAT PLASTIC

**WHT TOILET SEAT PLASTIC-ELNG

*’ICE MAKER KIT 25FT POLY TUBE X

*’SS HOSE CLAMP 11/16 TO 1-1/4

*1-1/2X60 YD BLUE TAPE

*12"X9" SHELF BRACKET

*2" INDUSTRIAL SWIVEL CASTER

*2" LAM PIN TUMBLER PADLOCK

*3PR FOAM EAR PLUG DISP BAG

*40Z TURBINE OIL

*50 FT COAX CABLE W/F CON BLK

*6 PC SCREWDRIVER SET W/ RAC

*60"WOOD MOP HANDLE W/WINGNUT

*62" ADJUST SHWR ROD BONE

*BR COMPRESSION SLEEVE 3/8

*BRASS FLARE UNION 3/8

*CART FITS DELTA/DELEX (BLK)

*CPVC 90* ST ELBOW 1/2

*CPVC COUPLING 1/2

*CPVC SLIP CAP 1/2

*CPVC SLIP TEE 1/2

*CPVC SLIP TEE 3/4

*CPVC UNION 1/2

*DR REINFORCER 1-3/4 4X4-1/2

*DWV PVC DBL SANITARY TEE 2

*DWV PVC DBL SANITARY TEE 3

*DWV PVC RECSSD HD C/O PLUG 2

*DWV PVC RECSSD HD C/O PLUG 4

*EMT COUPLING SET SCREW 1/2

*FEM ADAPT 3/8 COMP X 1/2 FIP

*FEM ADAPT 3/8 FLARE X3/8 FIP

*FGG CPVC FEMALE ADPT 1/2

*FGG CPVC MALE ADPT 1/2

*FLEX CPLG 2X2

*GALV 90* ELBOW 1

*GALV 90* ELBOW 1-1/2

*GALV 90’ ELBOW 1-1/2

*GALV CAP 3/4

*GALV COMP COUP 1/2

*GALV COUPLING 3/4

*GALV FLOOR FLANGE 1

*GALV FLOOR FLANGE 1-1/4

*GALV FLOOR FLANGE 2

*GALV FLOOR FLANGE 3/4

*GALV NIPPLE 3/4 X 2

*GALV NIPPLE 3/4 X 6

*GALV NIPPLE 3/4 X 8

*HOSE ADAPT 3/4 MHT X 1/2 MIP

*PLAS TOILET SEAT BONE ELONG

*PREM FFG CPVC CEMENT 1/4PT

*PVC SLIP BUSHING 1 X 3/4

*SS HOSE CLAMP 13/16 TO 1-3/4

*SS HOSE CLAMP 7/32 TO 5/8

*SS LAV 1/2FIP X 1/2 FIP X 16

*THINWALL CONDUIT STRAP 1/2

*WHT GRAB BAR 1-1/4 X 24

.095 x 40' Trim Line

’’PREMR STAINLESS PUTTY 14 OZ

’•EXHAUST FAN 50 CFM

’•RANGE HOOD WHT 30" DUCTLESS

’CHECK VALVE IN LINE 1 FIP

’GALV 90* ELBOW 2

’GARDEN HOSE 3-PLY 5/8X50FT ”CA

’MARKING TAPE 3/4X66 FT GREEN

’PREMR ALL-PURPOSE CLNR 1/4PT

’PVC BALL VALVE 1/2 FIP

’WALLBOARD JOINT TAPE 2 X 250

“#(6-24) 2 LT ALZACK/BAFFLE

“50" TALL STEEL HAND TRUCK

“62" ADJUST SHWR ROD WHITE

“BRASS COMPRESSION UNION 1/4

“BRASS COMPRESSION UNION 3/8

“BRASS COMPRESSION UNION 5/8

“COUPLING C X C 1/4

“ELECTRICAL TAPE VINYL 3/4X60

“EXT CORD 16/3 SJTW 50 FT UL

“FLEX CPLG 4X4

“FLUIDMASTER BALLCOCK (EXPORT ONLY)

“GALV 90* ELBOW 1/2

“GALV 90* ELBOW 3/4

“GRAB BAR EXP SCREW 1-1/2"X36"

“HANGER STRAP GALV 24GA 10FT

“HANGER STRAP METAL 30GA 10FT

“HOSE BIBB 3/4 MIP

“MALE ADAPT 3/8 COMPX1/2 MIP

“MALE ADAPT 3/8 FLAREX1/2 MIP

“MALE ADAPT 3/8 FLAREX3/8 MIP

“MAPP/PROPANE SELF LIGHT TRDSMN

“PLAS SEAT WHT OPN FRT ELONG

“PREMIER FLEX COUPLING 4X3

“PREMIER PIPE DOPE 1/4 PT

“PREMIER PIPE DOPE 8 OZ

“PREMR FLEX COUP 1-1/2X1-1/2

“PREMR LATEX CAULK 10.3 OZ

“PREMR SILICONE SEALANT CLEAR

“ROMEX CONNECTOR 3/8

“SHOWER ROD POL ALUM 5 FT

“SMOKE ALARM AC/DC

“SMOKE ALARM DC 9 VOLT

“SUBMERSIBLE UTILITY PUMP

“WALL SCONCE - BRUSH STEEL 13"

■BRASS FLARE NUT 1/2

■HANGER STRAP GALV 1/2

■HOSEBRB 3/8B X3/8 MIP 4-BRB

■VINYL TUBE 3/4ID 1 OD X50FT

♦SEAL FOR FLUIDMASTER 242

•*1/2 X 1/2 MNPT SHARK BITE STRGHT CONN.

•‘DIAPHRAM WELL TANK 20 GAL

•’PVC LAV 3/8COMP X 1/2FIP X12

••CLOG BUSTER 3 TO 6 DRAIN

••ELBOW 3/8 COMP X 3/8 MIP

••GRAB BAR EXP SCREW 1-1/2"X24"

••HANGER STRAP METAL 30GA 10FT

••LEVER HDL HOSE BIBB 1/2

••LONG 90*ELBOW C X C 1/4

••MALE ADAPT 5/8 COMPX1/2 MIP

••SHOWER ROD POL ALUM 5 FT

••SMOKE ALARM AC 120 VOLT

••VESSEL POP UP ASSEM CHROME

•500W ROUGH SERV BULB

•APPLIANCE CORD UL 9FT

•BEIGE WOOD TOILET SEAT

•BOILER DRAIN 1/2MIP & 1/2SWT

•BRASS 90* ELBOW 1/2

•BRASS BUSHING 1/2 X 3/8

•BRASS BUSHING 3/4 X 1/2

•BRASS BUSHING 3/8 X 1/4

•BRASS COMP UNION 3/8 X 1/4

•BRASS COMPRESSION ELBOW 5/8

•BRASS COMPRESSION NUT 1/4

•BRASS COMPRESSION SLEEVE 1/4

•BRASS COUPLING 1/2

•BRASS COUPLING 1/4

•BRASS COUPLING 1/8

•BRASS FLARE TEE 3/8

•BRASS FLARE UNION 1/2

•BRASS FOOT VALVE 1

•BRASS FOOT VALVE 1 X 1-1/4

•BRASS FOOT VALVE 1-1/4

•BRASS INSERT 1/4

•BRASS NIPPLE 1/2 X 1-1/2

•BRASS NIPPLE 1/2X2

•BRASS NIPPLE 3/4 X 1-1/2

•CANISTER AUGER 1/4 X 15 FT X

•CANISTER AUGER 1/4 X 25 FT

•CANISTER W/TORQUE 1/4X15

•CANISTER W/TORQUE 1/4X25

•CAUTIONTAPE YELLOW 3X1000FT

•CELCON HOSE BIBB 1/2 MIP

•CELCON HOSE BIBB 3/4 MIP

•CHECK VALVE IN LINE 1 FIP

•CHECK VALVE IN LINE 1/2 FIP

•CHECK VALVE IN LINE 3/4 FIP

•CLOG BUSTER 1 TO 2 DRAIN

•CLOSET AUGER 3 FT

•CLOSET AUGER 6 FT

•COMPRESSION NEEDLE VALVE 3/8

•COMPRESSION TEE 1/2

•CORNER BRACE 1-1/2 ZP

•COUPLING C X C 3/8

•COUPLING C X C LESS STOP 1/2

•DOOR VIEWER 160*

•DRAIN AUGER 1/4 X 25 FT

•DRYER CORD 4-PRONG 4-#10W30A

•DRYER RECPT 30AMP/250V 3-P&W

•DUAL THREAD AERATOR 2.2 GPM

•DWVPVC TEST T C/O W/PLG 1-1/2

•ELBOW 3/8 COMP X 1/2 MIP

•ELBOW 3/8 FLARE X 1/2 MIP

•ELBOW 3/8 FLARE X 3/8 MIP

•ELEMENT SCREW IN 2000/120

•ELEMENT SCREW IN 2500/240

•EXT CORD 14-3 SJT 100 FT UL

•FIBERGLASS MESH 2 X 75

•FILL & SEAL 20 OZ

•FLAT SEWER ROD 1/2 X 100 FT

•FLAT SEWER ROD 1/2 X 25 FT

•FLAT SEWER ROD 1/2 X 50 FT

•FLEX CPLG 3X3

•FLEXIBLE SJ EXTTUBE 1-1/2X12

•GALV 90* ELBOW 2

•GALV BUSHING 1 X 3/4

•GALV BUSHING 1/2 X 1/4

•GALV BUSHING 1-1/4 X 1

•GALV BUSHING 3/4 X 1/2

•GALV CAP 1/2

•GALV CAP 3/4

•GALV COUPLING 1/2

•GALV COUPLING 3/4 X 1/2

•GALV FLOOR FLANGE 1

•GALV FLOOR FLANGE 1-1/2

•GALV FLOOR FLANGE 1-1/4

•GALV FLOOR FLANGE 2

•GALV NIPPLE 1 X 4

•GALV NIPPLE 1 X CLOSE

•GALV NIPPLE 1/2 X 1-1/2

•GALV NIPPLE 1/2 X 2

•GALV NIPPLE 1/2 X 2-1/2

•GALV NIPPLE 1/2 X 5

•GALV NIPPLE 1/2 X 6

•GALV NIPPLE 1/2 X CLOSE

•GALV NIPPLE 1/2X2

•GALV NIPPLE 1/2X3

•GALV NIPPLE 1/2X4

•GALV NIPPLE 1-1/2 X 6

•GALV NIPPLE 2X6

•GALV NIPPLE 3/4 X 1-1/2

•GALV NIPPLE 3/4 X 4

•GALV NIPPLE 3/4 X CLOSE

•GALV NIPPLE 3/4X3

•GALV PLUG 1/2

•GALV TEE 1/2

•GALV TEE 1-1/4

•GALV TEE 2

•GALV TEE 3/4

•GARDEN HOSE 3-PLY 5/8X50FT **CA

•GERBER LAV HANGER

•GERBER LAV HANGERS PAIR

•GRAB BAR EXP SCREW 1-1/2X48

•HAL QURTZ BULB 300T3Q/CL130V

•HAL QURTZ BULB 500T3Q/CL130V

•HAMMOND BALL VLV FP 1/4IPS

•HAMMOND BALL VLV FP 3/8IPS

•HAMMOND HOSE BIBB 3/4 MIP

•HANGER STRAP GALV 2

•HANGER STRAP GALV 3/4

•HEAVYWALL CONDUIT STRAP 1/2

•HEAVYWALL CONDUIT STRAP 3/4

•HOSE ADAP SWIV 3/4FHTX1/2FIP

•HOSE ADAP SWIV 3/4FHTX3/4FHT

•HOSE ADAP SWIV 3/4FHTX3/4FIP

•HOSE ADAPT 3/4 MHT X 1/2 MIP

•HOSE ADAPT MALE X MALE 3/4

•HOSEBRB 1/4B X1/4 MIP 4-BRB

•HOSEBRB 3/8B X1/2 MIP 4-BRB

•HOSEBRB 3/8B X1/4 MIP 4-BRB

•KIT FOR DELT SG HDL OLD/NE

•LEGEND 5-IN-1 TOOL

•LEGEND PADLK W/BUMPER 1-1/2

•LEGEND PADLK W/BUMPER 1-1/4

•LEGEND PADLK W/BUMPER 1-3/4

•LEGEND PADLK W/BUMPER 2

•LIQUID SOAP DISPENSER-PLAS

•'LONG 90*ELBOW C X C 1/4

•MALE ADAPT 1/2 COMPX1/2 MIP

•MALE ADAPT 1/2 FLAREX3/8 MIP

•MALE ADAPT 1/4 COMPX1/2 MIP

•MALE ADAPT 1/4 COMPX1/4 MIP

•MALE ADAPT 3/8 COMPX1/4 MIP

•MALE ADAPT 3/8 COMPX3/8 MIP

•MALE ADAPT 3/8 FLAREX1/4 MIP

•MARKING TAPE 3/4X66 FT RED

•MARKING TAPE 3/4X66 FT WHITE

•O RING KIT 200 PC

•OUTDR DIE CST WLL WH 17"H

•PENCIL CARPENTER MED LEAD

•PINK TEFLON TAPE 1/2X260

•PLAS TOILET SEAT BONE ELONG

•'PLASTIC SLEEVE 3/8

•PLASTIC TOILET TANK FLOAT

•POLY TUBE 1/4ID 3/80D X 100

•POWER TAPE CHROME 1 X 25 FT

•PREMIER FLEX COUPLING 3X2

•PREMIER FLEX COUPLING 6X6

•PREMIER H.D HOSE BIBB 3/4

•PREMIER H.D. HOSE BIBB 3/4

•PREMIER PIPE DOPE 1 OZ

•PREMR FLEX COUPLNG 2 X 1-1/2

'•PROPLUS ROUND FRNT WOOD SEAT

•PULL CHAIN CURRENT TAP IVORY

•PVC COMPRESSION COUPLING 1/2

•PVC COMPRESSION COUPLING 2

•PVC SPRING CHECK VLV 1 S X S

•PVC TOILET 3/8COMPX7/8BC X20

•ROD & SHELF SUPPORT 10X12

•ROMEX CONNECTOR 3/4

•RUBBER TAPE 30 MIL 3/4X22FT

•SEATS/SPRNGS FOR DEL NEW

•SELF-TAPPING SADDLE VALVE

•SHOWER STALL DRAIN 1-1/2

•SIDEMOUNT TANK LVR FOR ELJER

•SILLCOCK 3/4 FIP

•SINGLE HANDLE COVER PLATE

•SNAPADPT DUAL 15/16

•SS LAV 1/2FIPX 1/2 FIP X 16

•STAPLES 3/8"

•STEEL CONDUIT LOCKNUT 2

•STEEL CONDUIT LOCKNUT 3/4

•STOP VALVE 7/8COMP X 7/8COMP

•TAPE YELLOW CAUTION 3X300FT ROLL

•TEECXCXC 1/4

•THINWALL CONDUIT STRAP 1/2

•TOILET BOLT CAPS RD WHT PLAS

•TOILET SEAT BOLTS PLASTIC PR

•TOILT SEAT BLTS PLASTIC PR

•TROUBLE LIGHT 16-3 SJT 25 FT

•VINYL TUBE 1/2ID 3/40D X100

•WET/DRY ROOF CEMENT 11 OZ TUBE

1 "BASIN/LAVATORY CRUMB CUP

1 PAINTERS GRADE MSK TAPE

1/2" 2-HOLE EMT STRAP

1/4 X 1 1/2 FENDER WASHER

1/4 X 3 CLOSE EYE SCREW HK

1/4" QUICK LINK

1/4X5-1/4 EYE X HK TURNBKLE

1-1/2 PAINTERS GRADE MSK TAPE

1-1/2" 2-HOLE EMT STRAP

1-1/2" CRUMB CUP LESS POST

1-1/2" CRUMB CUP W/POST

13IN GL HDL VESSEL LAV CHRM

150W HPS LAMP MEDIUM

150WHPS LAMP MEDIUM

16"X11" SHELF BRACKET

2 X12' PARTS BIN

2" 2-HOLE EMT STRAP

2" INDUSTRIAL RIDGID CASTER

20"X13" SHELF BRACKET

2-1/2 INDUSTRL SWIVEL CASTER

2-1/2" INDUST RIDGID CASTER

3/16" QUICK LINK

3/16X1 FENDER WASHER

3/4 PAINTERS GRADE MSK TAPE

3/8 X 8 EYE X HK TURNBKLE

4"X5“ LINT TRAP KIT W/ CLAMPS

5 GAL. ENVIRO-FLO PLUS GAS CAN

'ACTUATOR FOR AMER STD #5

'ALL PURPOSE STAPLE GUN

ALUM RURAL MAILBOX 1-1

AVACADO WOOD TOILET SEAT

BAYBERRY GRN WD TOILET SEAT

BEVELED WASHER 1/4L

BONDO SPREADER 3 PAK SALMON

BR COMPRESSION SLEEVE 3/16

BRASS BALL FOR DELTA 212

BRASS BUSHING 1/2 X 1/8

BRASS BUSHING 1/4 X 1/8

BRASS BUSHING 3/8 X 1/8

BRASS CAP 1/8

BRASS CAP 3/8

BRASS COMP UNION 3/16

BRASS COMP UNION 5/16

BRASS COMPRESSION CAP 1/2

BRASS COMPRESSION CAP 1/4

BRASS COMPRESSION CAP 3/8

BRASS COMPRESSION CAP 5/8

BRASS COMPRESSION ELBOW 1/2

BRASS COMPRESSION ELBOW 1/4

BRASS COMPRESSION ELBOW 3/8

BRASS COMPRESSION NUT 1/2

BRASS COMPRESSION NUT 5/16

BRASS COMPRESSION NUT 5/8

'BRASS COMPRESSION SLEEVE 1/4

BRASS COMPRESSION SLEEVE 1/8

BRASS COMPRESSION SLEEVE 5/8

BRASS COMPRESSION UNION 1/8

'BRASS FLARE ELBOW 3/8

BRASS FOOT VALVE 3/4

BRASS HOSE BARB 1/2 4-BARB

BRASS HOSE BARB 1/4 4-BARB

BRASS HOSE BARB 1/8 4-BARB

BRASS HOSE BARB 3/16 4-BARB

BRASS HOSE BARB 3/8 4-BARB

BRASS HOSE BARB 5/16 4-BARB

BRASS HOSEBRB TEE 1/4 3-BARB

'BRASS HOSEBRB TEE 3/8 3-BRB

BRASS INSERT 1/2

BRASS INSERT 3/8

BRASS INSERT 5/16

BRASS NIPPLE 1/4 X 1-1/2

BRASS NIPPLE 1/4X2

BRASS NIPPLE 1/4X3

BRASS NIPPLE 1/4X4

BRASS NIPPLE 1/8 X CLOSE

BRASS NIPPLE 1/8X3

BRASS SWEEPER NOZZLE

CART FOR DELTA/DELEX/PEERLES

CLOSET ROD SOCKET PLASTIC

'COMPRESSION TEE 5/8

'COPPER CLAD STRAP 1/2 ID

COPPER CLAD STRAP 3/8 ID

CORNER BRACE 3 ZP

CPVC/BRASS DROP EAR ELBOW 1/2"

CPVC/BRASS TRANSITION ADAPTER 1/2 CPVC S

CRUMB CUP 1

CRYSTAL LAV HDL FOR DELTA

DANGERTAPE BLK/RED 3X300FT

DEL CP PULL DOWN DIV-S

DELTA SEATS/SPRNGS OLD LNG

DOUBLE BOWL SS SINK - 4 HOLE

DR REINFORCER 1-3/8 4X4-1/2

DRAIN AUGER 1/4X15 FT

DRESDEN BLUE WOOD TOILETSEAT

-DUAL THREAD AERATOR 2.0 GPM

DWVPVC DB SANITRY TEE1-1/2

'ELBOW 1/2 COMP X 3/8 MIP

ESCUTCHEON WHT 1-1/4 IPS

FEM ADAPT 1/2 COMP X 3/8 FIP

FEM ADAPT 1/2 FLARE X3/8 FIP

FEM ADAPT 1/4 COMP X 1/2 FIP

FEM ADAPT 1/4 COMP X 1/4 FIP

FEM ADAPT 5/8 COMP X 3/4 FIP

FILTER HOSE WASHERS

FLAPPER DELTA PRO

FLAT WASHER 1/2

FLAT WASHER 3/8

FLAT WASHER 3/8L

FLEX CPLG 2 X 1-1/2

FLEX CPLG 6X6

FLEXIBLE COUPLER SJ 1-1/2

FLOOR&CEILING PLATE 1-1/4IPS

'FLUIDMASTER SEAL BULK

FU\T WASHER 1/2

GALV 45* ELBOW 2

GALV 45* ELBOW 3/4

GALV 45* STREET ELBOW 1/2

GALV 45’ ELBOW 1/2

GALV 90* ELBOW 1/4

GALV 90* ELBOW 1-1/4

GALV 90* ELBOW 3/4 X 1/2

GALV 90* ELBOW 3/8

GALV 90* STREET ELBOW 1

GALV 90* STREET ELBOW 1/2

GALV 90* STREET ELBOW 3/8

GALV 90’ ELBOW 1/2 X 3/8

GALV BUSHING 1/2 X 1/8

GALV BUSHING 1/2 X 3/8

GALV BUSHING 1/4 X 1/8

GALV BUSHING 1-1/2 X 1-1/4

GALV BUSHING 1-1/4 X 1/2

GALV BUSHING 1-1/4 X 3/4

GALV BUSHING 2 X 1-1/4

GALV BUSHING 3/4 X 3/8

GALV BUSHING 3/8 X 1/4

GALV BUSHING 3/8 X 1/8

GALV CAP 1

GALV CAP 1/4

GALV CAP 1/8

GALV CAP 1-1/2

GALV CAP 1-1/4

GALV CAP 2

GALV CAP 3/8

GALV COMP COUP 1-1/4

GALV COUPLING 1

GALV COUPLING 1 X 1/2

GALV COUPLING 1 X 3/4

GALV COUPLING 1/2 X 1/4

GALV COUPLING 1/4

GALV COUPLING 1/8

GALV COUPLING 1-1/2 X 1-1/4

GALV COUPLING 1-1/4

GALV COUPLING 1-1/4 X 1

GALV COUPLING 2 X 1

GALV COUPLING 2 X 3/4

GALV COUPLING 3/4 X 3/8

GALV COUPLING 3/8

GALV COUPLING 3/8 X 1/4

GALV FLOOR FLANGE 1/2

'GALV FLOOR FLANGE 3/4

GALV MERCHANT COUPLING 2

GALV NIPPLE 1 X 10

GALV NIPPLE 1 X 2

GALV NIPPLE 1 X 2-1/2

GALV NIPPLE 1 X 3

GALV NIPPLE 1 X 3-1/2

GALV NIPPLE 1 X 5

GALV NIPPLE 1/2 X 10

GALV NIPPLE 1/2 X 3-1/2

GALV NIPPLE 1/2 X 4-1/2

GALV NIPPLE 1/2 X 5-1/2

GALV NIPPLE 1/2 X 7

'GALV NIPPLE 1/2 X 8

GALV NIPPLE 1/4 X 1-1/2

GALV NIPPLE 1/4 X 2-1/2

GALV NIPPLE 1/4 X 3

GALV NIPPLE 1/4 X CLOSE

GALV NIPPLE 1/4X2

GALV NIPPLE 1/4X4

GALV NIPPLE 1/4X5

GALV NIPPLE 1/8 X 1-1/2

GALV NIPPLE 1/8 X 2-1/2

GALV NIPPLE 1/8 X CLOSE

GALV NIPPLE 1/8X2

GALV NIPPLE 1/8X3

GALV NIPPLE 1/8X6

GALV NIPPLE 1-1/2 X 2

GALV NIPPLE 1-1/2 X 2-1/2

GALV NIPPLE 1-1/2 X 4

GALV NIPPLE 1-1/2 X 5

GALV NIPPLE 1-1/2 X CLOSE

GALV NIPPLE 1-1/4 X 2

GALV NIPPLE 1-1/4 X 3

GALV NIPPLE 1-1/4 X 3-1/2

GALV NIPPLE 1-1/4 X 4

GALV NIPPLE 1-1/4 X 6

GALV NIPPLE 1-1/4 X CLOSE

GALV NIPPLE 2 X CLOSE

GALV NIPPLE 2X3

GALV NIPPLE 2X4

'GALV NIPPLE 3/4 X 2-1/2

GALV NIPPLE 3/4 X 4-1/2

GALV NIPPLE 3/4 X 9

GALV NIPPLE 3/4X10

GALV NIPPLE 3/8 X 1-1/2

GALV NIPPLE 3/8 X 2

GALV NIPPLE 3/8 X 3

GALV NIPPLE 3/8 X CLOSE

GALV NIPPLE 3/8X4

GALV NIPPLE 3/8X5

GALV PLUG 1/4

GALV PLUG 1/8

GALV PLUG 2

'GALV PLUG 3/4

GALV PLUG 3/8

GALV TEE 1/2 X 1/2 X 3/4

GALV TEE 1/4

GALV TEE 1/8

'GALV UNION 1

'GALV UNION 1/2

'GALV UNION 1-1/2

'GALV UNION 1-1/4

GARDEN HOSE 3-PLY 1/2X50FT **CA

GARDEN HOSE 3-PLY 5/8X75FT **CA

GARDEN HOSE WASHER BULK (EACH)

HAL QRTZ BULB 1500T3Q/CL240V

HAL QUARTZ BULB 150T3Q/CL/S

HALOGEN 300 T3Q/CL/120V

HD GALV REPAIR CLAMP 1/2

HD GALV REPAIR CLAMP 3/4

HD. HUDSON 2 LITER HAND SPRAYER

HEAVYWALL CONDUIT STRAP 1

HEAVYWALL CONDUIT STRAP 2

HOSE ADAPT 3/4 FHT X 1/2 MIP

HOSE ADAPT 3/4 FHT X 3/4 MIP

HOSE CAP BRASS

'HOSE FOR PERS SHWR CHROME 59

HOSEBRB 1/2B X 3/8 FIP 4-BRB

HOSEBRB 1/2B X 3/8 MIP 4-BRB

HOSEBRB 1/4B X 1/4 FIP 4-BRB

HOSEBRB 1/4B X 3/8 MIP 4-BRB

HOSEBRB 1/4B X1/8 FIP 4-BARB

HOSEBRB 1/8B X 1/8 MIP 4-BRB

HOSEBRB 3/16B X1/8 MIP 4-BRB

HOSEBRB 3/8B X 1/2 FIP 4-BRB

HOSEBRB 3/8B X 1/4 FIP 4-BRB

HOSEBRB 3/8B X 1/8 MIP 4-BRB

HOSEBRB 3/8B X 3/8 FIP 4-BRB

HOSEBRB 5/16B X1/4 MIP 4-BRB

HSBRB 3/16B X 1/4 MIP 4-BARB

HVYWALL CONDUIT STRAP 1-1/2

KEY FOR LOOSE KEY SILLCOCKS

KIT FOR AMER STD CADET

LGND 1-1/2 PLAS PUTTY KNIF

LGND 2 PLASTIC PUTTY KNIFE

LGND 3 PLASTIC PUTTY KNIFE

LGND 4 PLAST DRYWLL KNIFE

MALE ADAPT 1/2 COMPX1/4 MIP

MALE ADAPT 1/2 COMPX3/8 MIP

MALE ADAPT 1/4 COMPX3/8 MIP

MALE ADAPT 1/8 COMPX1/8 MIP

MALE AERATOR 13/16 2.2 GPM

MALE AERATOR 13/16 SLOTLESS

MARKING TAPE 3/4X66FT YELLOW

N2917 NEW 1.75 GPM EARTH SHOWERHEAD

N2925N NEW EARTH SHWRHD;WHITE;2.5GPM

N3104T DUAL THREAD AERATR 1.5 GPM MAX

NAVAL JELLY 8 OZ BOTTLE

NEEDLE VALVE 1/4 MIP

NEOPERL BN REG FEMALE AERTR 1.5GPM

NEOPERL DUAL THREAD AERATOR 2.2GPM

NEOPERL PC REG DUAL AERATOR 1.0GPM

NEOPERL REG FEMALE AERATOR 1.5GPM

NEOPERL REG MALE AERATOR 1.5GPM

NEOPERL SMALL MALE AERATOR 1.5GPM

NEW 1 HP SHALLOW WELL JET PUMP

NEW 16.4 OZ DISPOSABLE PROPANE 2PK

NEW 3/4 HP SHALLOW WELL JET PUMP

NEW FLAPPER FOR TOTO G-MAX

NEW FLAPPER TOTO POWER GRAVITY

NEW HORIZONTAL 7 GAL PRECHARGED TANK

NEW PERS SHWR W/ MASSAGE HD CHROME

NEW PERS SHWR W/ MASSAGE HD WHITE

NEW WHT ELONG WOOD TOILET SEAT

PERSONAL SHWR BRACKET CHROME

PINK WOOD TOILET SEAT

'PLASTIC SLEEVE 1/4

PLASTIC SLEEVE 5/8

PLASTIC TOILET SEAT BONE

POLY MAILBX SLEEVE BLK PX-1B

POLY MAILBX SLEEVE WHT PX-1W

'POWER TAPE CHROME 1 X 25 FT

PREM ELITE PULL-OUT SPRAY HD

'PREMIER FLEX COUPLING 6X6

'PREMR CONN 1-1/2X1-1/2*1-1/4

-PREMR SILICONE SEALANT CLEAR

'PUSHBUTTON TANK LVR SIDE MT

'PVC 90* EL 1-1/2 SJ-BAG

PVC COMPRESSION COUPLING 3

PVC COMPRESSION COUPLING 4

PVC FIP X FIP COUPLING 1/2

'PVC GEN PURPOSE HY DTY DRAIN

PVC SLIP BUSHING 1 X 1/2

PVC SLIP BUSHING 1-1/2 X 1

PVC SLIP BUSHING 2 X 1-1/4

PVC SLIP BUSHING 2 X 3/4

PVC SLIP CROSS 1/2

PVC SLIP CROSS 3/4

PVC SLIP TEE 1 X 1 X 3/4

PVC SLIP TEE 3/4 X 3/4 X 1/2

PVC SLIP X FIP BUSH 1 X 1/2

PVC SLIP X FIP BUSH 3/4X1/2

PVC SLIP X MIP ADPTR 3/4X1/2

PVC SLIPXMIP 90 ST ELBOW 1

PVC SLIPXMIP 90 ST ELBOW 1/2

'PVC SLIPXMIP 90 ST ELBOW 3/4

PVC SLP X FIP BUSH 1-1/4X3/4

PVC SPRING CHECK VALVE 1 FIP

PVC SXSXFIP TEE 1/2

QWIK ELBOW W/SS CLMPS 1-1/2

REGENCY BLUE WOOD TOILET SEAT

SCH 80 PVC THRD UNION 1/2

SCH 80 PVC THRD UNION 3/4

SCREEN CLIP

SEAL FOR FLUIDMASTER 242

SEAT DISC SNAP ON FOR AM STD

SEAT FOR AMER STD 7/16-24

SEAT FOR STERLING 1/2-24

SEATS & SPRINGS FOR VALLEY

SEATS FOR DELTA NEW/SHORT

'SELF-IGNT TRCH KIT-140Z PRPN

SHORT 90 ELBOW C X C 3/8

SHOWER DIVERTER VALVE

SHWR DR ROLLER OVAL 3/4

SHWR ROD FLANGE CP W/SCREWS

'SHWR ROD FLANGE CP W/SCREWS

'SIDEMOUNT TANK LVR FOR ELJER

SILLCOCK HANDLE SQUARE HOLE

SILLCOCK HDLE 12 BROACH RD

SILVER WOOD TOILET SEAT

SLOAN 110-XL REGAL FLU

SMOKE ALARM 120V ONLY SENTINEL

SMOKE ALARM 9V SENTINEL

SPLIT PLSTC ESCUT 1-1/4IPS

SS HOSE CLAMP 2-1/16 TO 3

STAPLES 1/2"

STAPLES 1/4"

STAPLES 5/16"

STEEL CONDUIT LOCKNUT 1

'STEEL CONDUIT LOCKNUT 1/2

STEM & BON FOR HARCRAFT H/C

STOP VALVE 1/2 COMP X 1/2 COMP (5/8 ID)

TANK LEVER CHROME PLATE ABS

TANK LEVER FOR AM STD CADET

'TANK LEVER W/METAL SPUD/NUT

'TANK LEVER WHITE ABS

TANK LVR FOR ELJER TOUCHFLSH

TAPE MEASURE 12 FT

TEE HANDLE FOR HOSE BIBB

THINWALL CONDUIT STRAP 1

THINWALL CONDUIT STRAP 1-1/2

THINWALL CONDUIT STRAP 1-1/4

THINWALL CONDUIT STRAP 2

TOILET BLT CAPS RD WHT PLAS

TOILET BOWL CAPS OVAL

TOILET FLAPPER WHITE

TOILET PAPER ROLLER CP PLAS

TOILET SEAT ROUND MOLDED WOOD BONE

TOILET SEAT ROUND MOLDED WOOD WHITE

TOILT BLT CAPS RD WHT PLAS

'TOWEL BAR CP EXP SCREW 18

'TOWEL BAR ONLY CLEAR 24

TRANSIT UNION CPVC/M COP 3/4

WALL MT MAILBOX BK 3100W-10PK

'WALLBOARD JOINT TAPE 2 X 250

WALLBOARD JOINT TAPE 75 FT

WALLBOARD SAW 6 INCH BLADE

'WHT GRAB BAR 1-1/4 X 24

WIRE NUT GREY BOX 100

YELLOW WOOD TOILET SEAT

Akashwani · Apr 6, 2013

Hi,

I don't have a solution for you, sorry, I do however have an "idea", but my lack of Excel skills and knowledge prevent me from constructing the answer you require.

Here's my idea...

Create a List of ALL the ASCII characters except for 0-9 and A-Z, eg....

This is an edited List

Excel Workbook

A

B

C

D

1

Code

Character

2

1

3

32

4

33

!

5

34

"

6

35

#

7

36

$

8

37

%

9

38

&

10

39

'

11

40

(

12

41

)

13

42

*

14

43

+

15

44

,

16

45

-

17

46

.

18

47

/

19

58

:

20

59

;

21

60

22

61

=

23

62

>

24

63

?

25

64

@

26

91

[

27

92

\

28

93

]

29

94

^

Sheet3

I have Named this list Code2.

I then tried the following formula to extract all data from the Right of the text IF the characters on the Left were in List Code2. I can only get it to work for one character, and also it fails unexpectedly at times (see bold text)....

Edited results....

Excel Workbook

A

B

C

1

Data

Test 1

2

"1/2X1/2 SHARK BITE STRGHT COUP

1/2X1/2 SHARK BITE STRGHT COUP

3

"1G STD BLANK PLATE IVORY

1G STD BLANK PLATE IVORY

40

*#2 CUT CASE BOTTOM BOX

#2 CUT CASE BOTTOM BOX

41

*#2 CUT CASE BOTTOM BOX

#2 CUT CASE BOTTOM BOX

136

RANGE HOOD WHT 30" DUCTLESS

417

WET/DRY ROOF CEMENT 11 OZ TUBE

418

1 "BASIN/LAVATORY CRUMB CUP

419

1 PAINTERS GRADE MSK TAPE

422

2-1/2" INDUST RIDGID CASTER

423

3/16" QUICK LINK

/16" QUICK LINK

424

3/16X1 FENDER WASHER

/16X1 FENDER WASHER

425

3/16X1 FENDER WASHER

/16X1 FENDER WASHER

426

3/4 PAINTERS GRADE MSK TAPE

/4 PAINTERS GRADE MSK TAPE

427

3/8 X 8 EYE X HK TURNBKLE

/8 X 8 EYE X HK TURNBKLE

428

4"X5 LINT TRAP KIT W/ CLAMPS

531

'FLUIDMASTER SEAL BULK

FLUIDMASTER SEAL BULK

532

FU\T WASHER 1/2

533

GALV 45* ELBOW 2

ALV 45* ELBOW 2

560

GALV CAP 1

ALV CAP 1

561

GALV CAP 1/4

ALV CAP 1/4

562

GALV CAP 1/8

ALV CAP 1/8

563

GALV CAP 1-1/2

ALV CAP 1-1/2

564

GALV CAP 1-1/4

ALV CAP 1-1/4

565

GALV CAP 2

ALV CAP 2

566

GALV CAP 2

ALV CAP 2

567

GALV CAP 3/8

ALV CAP 3/8

568

GALV COMP COUP 1-1/4

ALV COMP COUP 1-1/4

569

GALV COUPLING 1

ALV COUPLING 1

570

GALV COUPLING 1 X 1/2

ALV COUPLING 1 X 1/2

585

'GALV FLOOR FLANGE 3/4

GALV FLOOR FLANGE 3/4

586

GALV MERCHANT COUPLING 2

ALV MERCHANT COUPLING 2

648

GARDEN HOSE 3-PLY 1/2X50FT **CA

ARDEN HOSE 3-PLY 1/2X50FT **CA

651

GARDEN HOSE WASHER BULK (EACH)

ARDEN HOSE WASHER BULK (EACH)

652

HAL QRTZ BULB 1500T3Q/CL240V

653

HAL QUARTZ BULB 150T3Q/CL/S

654

HALOGEN 300 T3Q/CL/120V

818

TOILET PAPER ROLLER CP PLAS

819

TOILET SEAT ROUND MOLDED WOOD BONE

829

'WHT GRAB BAR 1-1/4 X 24

WHT GRAB BAR 1-1/4 X 24

830

WIRE NUT GREY BOX 100

831

YELLOW WOOD TOILET SEAT

832

YELLOW WOOD TOILET SEAT

Sheet1

The formula in B2 needs to be copied down.
I'm sure this method will work, but I cannot get the construction right, there is probably a VBA solution to this, but I do not write or understand VBA, so I cannot help you with that, sorry.

Hopefully now this has been bumped up, someone with the skills and knowledge will jump in and solve this for you.

Good luck.

Ak

Akashwani · Apr 7, 2013

Hi,

The best I can come up with is the following.........

Excel Workbook

A

B

C

D

1

Data

Test 1

Final Result

*

2

"1/2X1/2 SHARK BITE STRGHT COUP

1/2X1/2 SHARK BITE STRGHT COUP

*

38

#308433 Map/Pro Gas Cylinder 14.1 oz.

308433 Map/Pro Gas Cylinder 14.1 oz.

*

39

#6 REG LOCK WASHER ZINC

6 REG LOCK WASHER ZINC

*

40

*#2 CUT CASE BOTTOM BOX

#2 CUT CASE BOTTOM BOX

2 CUT CASE BOTTOM BOX

*

69

**WHT TOILET SEAT PLASTIC-ELNG

*WHT TOILET SEAT PLASTIC-ELNG

WHT TOILET SEAT PLASTIC-ELNG

*

70

*ICE MAKER KIT 25FT POLY TUBE X

ICE MAKER KIT 25FT POLY TUBE X

*

71

*SS HOSE CLAMP 11/16 TO 1-1/4

SS HOSE CLAMP 11/16 TO 1-1/4

*

184

WALL SCONCE - BRUSH STEEL 13"

*

188

VINYL TUBE 3/4ID 1 OD X50FT

*

189

?SEAL FOR FLUIDMASTER 242

SEAL FOR FLUIDMASTER 242

*

190

*1/2 X 1/2 MNPT SHARK BITE STRGHT CONN.

1/2 X 1/2 MNPT SHARK BITE STRGHT CONN.

*

202

VESSEL POP UP ASSEM CHROME

*

203

500W ROUGH SERV BULB

*

489

BRASS SWEEPER NOZZLE

*

832

YELLOW WOOD TOILET SEAT

*

833

*

Sheet1

The formula in B2 needs to be copied across to C2 and down to the last row.
If you want, you can have these 2 columns anywhere on your worksheet and you can also hide the first one.
You will still need to create a list and Named Range of the ASCII characters, but this can also be hidden away.

I'm sure there is a way to do this in one column, but I don't know how.

I hope this helps.

Ak

Akashwani · Apr 7, 2013

Hi,

Here's a one column formula that appears to work based on no more that 2 unwanted characters at the start of the text string....

=TRIM(IF(SUMPRODUCT(--(CODE(LEFT(A2,1))=Code2))+SUMPRODUCT(--(CODE(MID(A2,2,1))=Code2))=2,RIGHT(A2,LEN(A2)-2),IF(COUNTIF(Code2,CODE(LEFT(A2,1)))=1,RIGHT(A2,LEN(A2)-1),A2)))

This formula need to be put into B2 (or your chosen column) and copied down.
You will still need to create a List and Named Range of the unwanted ASCII characters.

I hope that solve your problem.

Ak

extracting expesific data from prodoct list

xsessive

New Member

Excel Facts

Akashwani

Well-known Member

Akashwani

Well-known Member

Akashwani

Well-known Member

Similar threads

Forum statistics

Share this page

extracting expesific data from prodoct list

xsessive

New Member

Excel Facts

Akashwani

Well-known Member

Akashwani

Well-known Member

Akashwani

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock