INCLUDE Function
Forums
Hi there,
I have a background in ACL and in ACL, there is a function called the INCLUDE function that will include all occurrences of a specified character or characters from an existing character string. As an example, INCLUDE(Address_Field_Name, "0123456789"), will give me all of the numeric characters from the address field, regardless of where they are located in the field or how many times they occur.
There does not appear to be an equivalent function for this in IDEA. @spanincluding comes close but still does not work the same as the ACL INCLUDE function. Is there a custom function for this, or I am just not finding the right function in IDEA?
Thanks in advance!
Mike
Hi Brian,
Hi Brian,
Would it be possible for you to create a custom INCLUDE and EXCLUDE function where I could include and exclude all occurrences of a specific character and also to where I can do it with more than one character? That would be great! Here is the link to the ACL webpage for how their INCLUDE function works. I would love to have something like this in IDEA.
Here is the link -
https://help.highbond.com/helpdocs/analytics/141/scripting-guide/en-us/…
Thanks so much!
No, it doesn't work like that
No, it doesn't work like that, here is the help:
Returns a string that includes the specified characters.
Syntax:
#cwi_Include(String1, String2, Number)
Parameters:
String1 - Grouping of characters that will be used to remove the excluded characters.
String2 - List of characters to exclude from Parameter 1.
Number - Use 0 for non-case sensitive removal and any other name for case sensitive removal.
Return Type: String
Example:
#cwi_Include("I want to remove all the vowels", "aeiou", 0)
Returns: aoeoeaeoe
The @FindOneOf should do what you are looking for as it will return the number of times a letter appears in a string.
If you are just looking to
If you are just looking to extract numbers only you can use @justnumbers function. There is the @remove function but it only allows you to do one character at a time, so you can nest multiple @remove together. There is also the option to use the @RegExp function that can do something like this. Finally I could create a custom function, let me know.