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
MarkShnier__You
Qrew Legend
Qrew Legendnp
Make two new formula fields.
[First Name]
formula
Left([Name]," ")
[Last Name]
formula Right([Name]," ")
Observe if the data looks correct.
Change each of those two fields to be a text field type.
Observe if the data looks corerct.
Delete the old name field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Make two new formula fields.
[First Name]
formula
Left([Name]," ")
[Last Name]
formula Right([Name]," ")
Observe if the data looks correct.
Change each of those two fields to be a text field type.
Observe if the data looks corerct.
Delete the old name field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
HOLY COW okay trying this now THANK YOU MARK!!!!
------------------------------
Michael Brumfield
------------------------------
------------------------------
Michael Brumfield
------------------------------
