Hello /*,
I am using the PART TEXT function to extract the names of Pipe Supports. Its a STRING function, is there a way to use it and COUNT to count the number of Pipe Supports with the results returned by the PART function.
Thanks for your TIME!
Hello /*,
I am using the PART TEXT function to extract the names of Pipe Supports. Its a STRING function, is there a way to use it and COUNT to count the number of Pipe Supports with the results returned by the PART function.
Thanks for your TIME!
Hello. Are all of your support names combined in one string, then you split this string to get the individual support names?
Can you illustrate or provide an example of your expected output?
Thanks for your reply Emmanuel.
Yes they are.
Actually we use SUBSTRING and not PART.
Here's an example of one of our Support Names /PS-84-PSS44-01502-SR
With SUBSTRING(NAME,8,5) we chop down it down to the Support Standard Name in this case "PSS45".
We want to count the number of the supports with the same standard on a PIPE.
Any ideas? Do you think REAL() could do the trick?
Hmmm, I have not encountered this requirement before, but I think it is not possible to achieve with REAL() since REAL() only converts a string text to a real number.
I think that you will need to use array variables and PML2 to store the support names and loop to each array element to get a count of support with the same standard. The macro flow will look similar to below:
!uniqueSupportStandard.Unique()
!supportStandardName.Find(!n).size()
stacked method to get the count of support per standard. Link for PML2 Array object methods on AVEVA Documentation website
docs.aveva.com/.../962737.html
Thanks for your replies Emmanuel.