Reply to "Data Table Practice!"

puppyraiserMember

quote:
Currently I search the string for a '(' and then back up one.

I mis-stated that. I search for ')' and include it!

quote:
If-then-else?
If string length>15, truncate at 15

I'm using Lotus, really REALLY different than Excel.

@LEFT(+B60,@FIND("(",+B60,0))&@REPEAT(" ",15-@LENGTH(@LEFT(+B60,@FIND("(",+B60,0))))

that takes the name out of the string and pads short names with spaces to make all short names 15 characters long. B60 is the original string.

Clear as mud ?

[This message was edited by Puppy Raiser on January 15, 2004 at 08:08 AM.]

1/15/048:00 AM

<ul id="{%=id%}ButtonGroup" class="button-group h-popup-buttons even-button-group even-1">
    <li id="{%=id%}Okay_buttonContainer"><a id="{%=id%}Okay" href="javascript:void(0);" class="button success no-margin-bottom h-alert-modal-ok-button" role="button">OK</a><script type="text/javascript">
        (function() {
            function {%=id%}Okay_click(event, data) {
            {%=id%}Popup.hide();
        }
        
                $('#{%=id%}Okay').on('click', {%=id%}Okay_click);
        })();
    </script></li></ul><a href="javascript:void(0);" class="close-reveal-modal" aria-label="Close Modal">&#215;</a><div class="last-modal-focus focus-utility-element" tabindex="0"></div>
</div>
<script type="text/javascript">
        (function() {
            {%=id%}Popup = new SS.Popup.ModalPopup('{%=id%}');
        })();
    </script>

Skip to main content

Membership Required

Remove From Your Block List

Manage Follow Preferences

Block

Please wait...