Concatonating 7 string and 1 numeric field

abutony · Jul 23, 2007

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 · Jul 24, 2007

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 · Jul 24, 2007

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 · Jul 25, 2007

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.

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!

Concatonating 7 string and 1 numeric field

abutony

Programmer

jimster06

Programmer

abutony

Programmer

jimster06

Programmer

Similar threads

Part and Inventory Search

Sponsor