Large date base has some entries with number after the street name

**pick44** · 09-24-2017, 09:32 AM

As example: 1000 Main St 187
or
1100 Jones St 100D

I suspect these are apt numbers. My columns are as follows:
A B
Street Number Street Name
1000 Main St 187
1100 Jones St 100D

What I need to show is:
A B
Street Number Street Name
1000 Main St
1100 Jones St

**AliGW** · 09-24-2017, 09:42 AM

I suspect these are apt numbers.

If you mean that you think that this is a suitable representative sample of data, I doubt it.

**pick44** · 09-24-2017, 09:49 AM

How many rows and columns do you need? The databases have 10 columns of data and 1,000,000 rows. I have been going over manually the Street Column and it appears that about 2-5% have these numbers, which from looking at Google Maps, the addresses fall into areas of Apartments. That is why I thought they are apt numbers. Let me know what you need to look at in size of representative sample. thanks

**AliGW** · 09-24-2017, 09:55 AM

Ah, I see - you mean apartment numbers, not apt numbers.

So are you saying that your entire dataset is of addresses that end in St (before the apartment number)?

**pick44** · 09-24-2017, 10:02 AM

Unfortunately no. The Street Names are various as you find in any city. Some end in St, Ave, Blvd, etc., and some with no extensions.
I could do a Text to Column and find then sort each new column to find the numbers, but I am worried that I might cause a problem in keeping each row of data in the right row. One small misstep and my entire data base would be worthless.

**AliGW** · 09-24-2017, 10:05 AM

OK, so as I suggested at the start, your sample is nowhere near representative. You need to provide at least as many rows as there are patterns in your data.

**pick44** · 09-24-2017, 10:07 AM

Okay I will work on that. It will take time to find all of them

Large date base has some entries with number after the street name

LinkBack

Thread Tools

Rate This Thread

Display

Large date base has some entries with number after the street name

Re: Large date base has some entries with number after the street name

Re: Large date base has some entries with number after the street name

Re: Large date base has some entries with number after the street name

Re: Large date base has some entries with number after the street name

Re: Large date base has some entries with number after the street name

Re: Large date base has some entries with number after the street name

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Very large data base and need to separate address from street name

Large Excel Data Base With Street Names that might End in Dr or Blvd or St

How can I transpose the certain number of entries in Excel sheet for large data set

[SOLVED] Separating street number from street name

[SOLVED] Trying to separate street number and street name into columns

separate street address and street number

[SOLVED] How do I sort a column of street number/street name by the stree.

Bookmarks

Bookmarks

Posting Permissions