Concatonating 7 string and 1 numeric field

[abutony]

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.

 

[jimster06]

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

 

[abutony]

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

 

[jimster06]

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.