Skip to main content
R
RCNewton1-Visitor
1-Visitor
February 21, 2019
Solved

Redacting Text in a parameter

  • February 21, 2019
  • 2 replies
  • 1355 views

Hello everyone, I have a simple question. I am sure it can be done but I have little experience with restricted parameters other than setting up drop-down boxs. 

 

I have a parameter that has a value -  ****** (xxxx-xxxxxxxxxxxxxxxx)

 

Is there a way I can filter this out to just get ****** as a parameter. (Please note that the ******* are different lengths.) 

I would love to just stop before the "("

 

Any help is appreciated. 

 

Cheers

RCN

 

 

 

Best answer by KenFarley

I think you can do this simply, as long as the ***** stuff doesn't contain a "(". Let's say you have two parameters:

stringIN = "******* (XXXXXXXX.XXXXXXX)"
stringOUT

You want to use EXTRACT to set stringOUT to just the stuff before the "(". If the case is as simple as I've stated, that is done like this:

indexEnd = SEARCH ( stringIN, "(" )
IF indexEnd > 1
 stringOUT = EXTRACT ( stringIN, 1, ( indexEnd - 1 ) )
ENDIF

Note: If there's no "(" in stringIN, or there's no text prior to the "(", stringOUT remains unchanged. If there is a space between the beginning of stringIN and the "(" and you don't want it, use ( indexEnd - 2 ) instead of ( indexEnd - 1 ).

2 replies

KenFarley
KenFarley21-Topaz IIAnswer
21-Topaz II
February 21, 2019

I think you can do this simply, as long as the ***** stuff doesn't contain a "(". Let's say you have two parameters:

stringIN = "******* (XXXXXXXX.XXXXXXX)"
stringOUT

You want to use EXTRACT to set stringOUT to just the stuff before the "(". If the case is as simple as I've stated, that is done like this:

indexEnd = SEARCH ( stringIN, "(" )
IF indexEnd > 1
 stringOUT = EXTRACT ( stringIN, 1, ( indexEnd - 1 ) )
ENDIF

Note: If there's no "(" in stringIN, or there's no text prior to the "(", stringOUT remains unchanged. If there is a space between the beginning of stringIN and the "(" and you don't want it, use ( indexEnd - 2 ) instead of ( indexEnd - 1 ).

    Patriot_1776
    Patriot_177622-Sapphire II
    22-Sapphire II
    February 21, 2019

    Ken (and others here) is way better than I am at programming, but, you could make your parameter that reads "xxxx-xxxxxxxxxxxxxxxx" a sum of 2 other parameters.  For instance, we would have a part that is comprised of the cage code (5-digits), separated by a dash, from the vendor part number.  So, you could make parameters that were named "COMBINED_PART_NUMBER", "CAGE_CODE", and "VENDOR_PART_NUMBER".  The relation COMBINED_PART_NUMBER = CAGE_CODE + "-" + VENDOR_PART_NUMBER.  I believe that's the syntax, my license server is down.....again.....so I can't check my example parts.

     

    EDIT:  Up and running again...finally.  Yup, the syntax is correct.  The quotes are needed for text strings (whatever you want to say, a space, a dash etc.), the plus sign "adds" them, and the parameters (for their value) don't need quotes.  I use this a lot for my library fasteners.

     

    Best of luck!

      Terms & ConditionsAccessibility statement