Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Concatonating 7 string and 1 numeric field

Concatonating 7 string and 1 numeric field

Concatonating 7 string and 1 numeric field

I am very new to focus and I am having problems concatonating 8 fields together. There is one numeric field which I have to convert to an Alpha. I am actually using source code notepad to edit the source but I am having difficulty coming up with the actual code. Any advise or suggestion would be very much appreciated.

Thank You.

RE: Concatonating 7 string and 1 numeric field

Using the GUI would make this fairly straight-forward but...

The concatenation operator comes in two flavors:
1) | weak concatenation
2) || hard concatenation

The difference is that the hard concatenation will move trailing blanks to the end of the concatenated string but weak concatenation will preserve trailing blanks.

The EDIT function is often used to convert numeric to alpha.

Remember that the receiving field must be of sufficient size to accomodate the result of the concatenation or EDIT.


RE: Concatonating 7 string and 1 numeric field

Thank You very much Jim.

I've got the concatenation working for the alpha fields but I still havn't able to figure the EDIT function for the conversion of the numeric field to alpha.  If you or someone can provide me with a sample code, I would very much appreciate this. Thank you once again.


RE: Concatonating 7 string and 1 numeric field

If the numeric is an integer the EDIT(IntField) should work. If number is floating point then FTOA (Float to Alpha) or DTOA (Double to Alpha) should work.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close