Software

Ask something
Discussion Locked

Combining text fields in database or ACT

0 helpful
5 replies

by frazowatz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We are converting from Q&A 4.0 to ACT 4.0. We wish to combine FIRST and LAST name fields into a single new field called NAME before converting. We have exported to Excel but data was truncated due to its 255 character cell limit, so when we exportedback to Q&A, we lost a lot of notes. We also tried to do the combining in Q&A and ACT, but we still can't figure it out.

Help!!!

5 replies

by sandymac

Why not import as first and last then you can run an update query to combine with an & operator?
Let me know if you want help with If statements that deal with missing first names!

This discussion is closed to new replies.