Editing Imported Data
I imported 2000 clients who have first and last names in a single field. But I have my name fields as 2 separate fields, first & last. Is there ANY WAY to do a mass edit where I can automatically sp...
Forum Discussion
Okay, WELL, I was going to try to implement this strategy with the addresses too because that's the other issue -- names and addresses -- the addresses were imported as "127 Washington Street, Naperville, IL, USA" -- do you know of way to get the address to transfer as well?? I had to pick either 1st street, 2nd street, city, state or zip to import it to, so I created it's own "import address" field, but now I'm not sure what to do with it.
------------------------------
Michael Brumfield
------------------------------
------------------------------
Michael Brumfield
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendParse out the separate field using formulas and then set up a saved table to table copy to do a "one time" merge" of the the table into itself on record ID and map the formula fields into the real address fields.
I assume that you have an empty address field and then some field that has the imported data. If you threw the whole string into Street one for example then the field list when you are building a formula will include that sub field.
You can user the part formula to extract out the parts.
Part([Import address: Street1],1,",")
the 1 means get the first part from the left, as defined by the comm as a separator. So that would be the Street.
Part 2 would be the next part so that would be the city.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I assume that you have an empty address field and then some field that has the imported data. If you threw the whole string into Street one for example then the field list when you are building a formula will include that sub field.
You can user the part formula to extract out the parts.
Part([Import address: Street1],1,",")
the 1 means get the first part from the left, as defined by the comm as a separator. So that would be the Street.
Part 2 would be the next part so that would be the city.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Good heavens, okay -- thanks so much, Mark. This may be over my head, but I'll see if I can tackle it.
------------------------------
Michael Brumfield
------------------------------
