this shouldn't take long .... :)

[lcouri]

Hi I'm new to FM and I'm coming from the excel side ... FM12 is quicker for me to do relational stuff (sorts etc.) but I've run into a simple problem:  I have a field with a string of alphanumeric text (6) that requires a space to be inserted in the middle.  I cannot find out how I would start this in FM12.  I know how to do it in excel ... is it similar?  ie. create a new column, generate the result ... etc... ?  I've also never had to put a calculation into FM12 .... any thoughts would be helpful.

Thanks!

Lance

[bcooney]

Is the string ALWAYS 6 characters? Assuming the original string is in myOrigString, then create a calc field, result text

 

 

myStringwSpace = Left (myOrigString, 3 ) & " " & Right (myOrigString, 3)

[lcouri]

Thanks!  Not disimilar to excel  This one small thing has saved me time in my exports!!

Thanks again!

[LaRetta]

Barbara's question is good one. Another calc would be:

Replace ( myOrigString ; 4 ; 0 ; " " )