I didn't really know what to call what I want, so I named it SUBSTRING LIKE :)
basically I've these data on the pipe:
KEdfgAV,GAYdRI R$50 NEWARK AVE$BELLEVILLE NJ 07109
KOdfgALI,PAdgMAJA R$7 ORANGE AVE$S.ORANGE NY 05679
PdfgEL, SAdfgABH C.MD$17 EDISON PLACE$NEWARK, MA 045605
GITgfNS-WIerAMS, LISA N.$97 BERGEN ST.$NEWARK, NJ 045603
OfTIZ,THgdfMAS R$465 MT. PROSPECT AVE$NEWARK, IL 05614
PECK, RICHARD E.$76 ND AVE$W. ORANGE NY 04552
ALreNSO, CeOS R$94 BLELD AVE$GLEN RIDGE, NW 045628
DerABNEH,NArR$969 ERT ST$RED BANK, IL 65461
and I need to keep only anything before the "$" sign.
how can that be done in SSIS derived column or through a script ?
any help is appreciated..