S
Shawna
Is there an easy way to split one field into 2?
I have delimited file to import into my db. It imports
fine with a macro I've set up. What I'd like to know
though is once the data is in can I take Field1 and split
into Field1 and Field2 or Field2 and Field3 (leaving
Field1 the original data)
Field1 looks like this
01000-H
I'd like to have 01000 in one field and the H in a
separte field.
Or Can I do this easily upon import?
Just looking for a quick solution....Thanks to all
Note, this import will happen on an ongoing basis.
thanx in advance....Shawna
I have delimited file to import into my db. It imports
fine with a macro I've set up. What I'd like to know
though is once the data is in can I take Field1 and split
into Field1 and Field2 or Field2 and Field3 (leaving
Field1 the original data)
Field1 looks like this
01000-H
I'd like to have 01000 in one field and the H in a
separte field.
Or Can I do this easily upon import?
Just looking for a quick solution....Thanks to all
Note, this import will happen on an ongoing basis.
thanx in advance....Shawna