Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatonating 7 string and 1 numeric field

Status
Not open for further replies.

abutony

Programmer
Jul 23, 2007
3
CA
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.
 
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.

HTH
 
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.

abutony
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top