Search Results

and this is the file i am working on...
check the attachment

the data looks good but when i tried using the awk command you posted, it gave me only po box numbers, fax numbers and phone numbers

something like this!
and i need a separator so that i can...

i had the same problem buddy...
i tried the regular expressions.. i've been doing that since yesterday.. but in vain!
and thats the reason why i posted it here!

hi
i am trying to extract some specific data out of a text file using regular expressions with shell script

that is using a multiline grep .. and the tool i am using is pcregrep so that i can get...

thanks a lot buddy! but that didn't do the trick:)
thanks for the effort you put in..
i'l fiddle with it :)

---------- Post updated 06-15-12 at 01:48 AM ---------- Previous update was 06-14-12...

nope! that command is deleting a lot of data! :(

cool thanks a lot buddy!
but can i ask for another favour?
the problem is the address length is varying and the order in the csv isnt proper..
like one record shows two cells of address while...

thats good buddy..
but how do i generate an excel sheet?
that was the issue i was facing!:confused:

hi,
i have a text file that looks like this!
i want to generate an excel sheet out of it, removing all the junk data except the addresses
that look like

. [32]Arrow Electrical Services
...