New_Here
04-17-2017, 11:18 PM
Hi Good Afternoon from Sri Lanka,
I have lots and lots of addresses as Data, out of that I need to remove/omit the part which states the City and state along with the rest of the contents like Zip No. etc ANYTHING & EVERYTHING which follows afterwords.
Sample given below for your reference & also has been attached. :)18953
Please give me a hand.
Many Thanks.
THE DATA
What I need
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM, Zhongshan, Guangdong, China
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM,
SKDJNCSDCNSC, LSCLCJSDLJCLKCLSCLKSJC, Zhongshan, Guangdong, China Book Special Tour
SKDJNCSDCNSC, LSCLCJSDLJCLKCLSCLKSJC,
SKDJN, LSCLCJSDLJCLKCLSCLKSJC, Zhongshan, Guangdong, China 528414 Book Special Tour
SKDJN, LSCLCJSDLJCLKCLSCLKSJC,
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM, Zhongshan,.China
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM,
SKDJN, LSCLCJSDLJCLKCLSCLKSJC, Guangdong, China Book Special Tour
SKDJN, LSCLCJSDLJCLKCLSCLKSJC,
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM, Zhongshan City,.China
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM,
I have lots and lots of addresses as Data, out of that I need to remove/omit the part which states the City and state along with the rest of the contents like Zip No. etc ANYTHING & EVERYTHING which follows afterwords.
Sample given below for your reference & also has been attached. :)18953
Please give me a hand.
Many Thanks.
THE DATA
What I need
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM, Zhongshan, Guangdong, China
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM,
SKDJNCSDCNSC, LSCLCJSDLJCLKCLSCLKSJC, Zhongshan, Guangdong, China Book Special Tour
SKDJNCSDCNSC, LSCLCJSDLJCLKCLSCLKSJC,
SKDJN, LSCLCJSDLJCLKCLSCLKSJC, Zhongshan, Guangdong, China 528414 Book Special Tour
SKDJN, LSCLCJSDLJCLKCLSCLKSJC,
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM, Zhongshan,.China
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM,
SKDJN, LSCLCJSDLJCLKCLSCLKSJC, Guangdong, China Book Special Tour
SKDJN, LSCLCJSDLJCLKCLSCLKSJC,
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM, Zhongshan City,.China
JLDLFSLDJFLSDJJFLKSJL, SCLKSCLSMDCLK, SMCWCLCSLM,