0

I have an excel file with the following data example

1   E   Eastland Care Ctr   [email protected] 2425 Kimberly Pkwy E    Columbus    OH  43232-4271  2072822617  6148689306  805101  Nursing & Convalescent Homes    www.voa.org
4   S   Softworks Inc   [email protected]    8185 Pickerington Rd    Canal Winchester    OH  43110-8895  6148640194  6148371639  573401  Computer Software   www.softworks.org
5   F   First Apostolic Church-Dublin   [email protected]  6477 Eiterman Rd    Dublin  OH  43016-8727  7166310257  6147665964  866107  Churches    www.murak.com

On the 11th field you see 805101 for the first line. I only want to keep data from this file that starts with 80-85 for this field. The number could be 80 820 8036 or 84000 but they must always start with either 80 81 82 83 84 85

Improve this question
3
  • 1
    perl and python can read an excel file, check this post or search google Commented Aug 6, 2015 at 23:28
  • 1
    Which format is the excel file, .csv? What tools do you have to parse it, if not? Excel isn't available for Unix or Linux, is it? Commented Aug 6, 2015 at 23:48
  • that's why i posted a comment about perl and python, because they can parse excel files and are certainly *nix tools Commented Aug 7, 2015 at 0:39

0

Reset to default

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.