http://forums.visokio.com/discussions/tagged/wildcards/feed.rss Mon, 30 Oct 17 14:32:20 -0400 Tagged with wildcards - Visokio Forums en-CA http://forums.visokio.com/discussion/2483/sources-ftp-with-changing-file-namess Fri, 28 Feb 2014 10:01:21 -0500 ChristianGroupM 2483@/discussions
I would like to use the FTP Data Source block to import my reports to Omniscope, but what to do when the target data file name is post-pended every day with a changing date?

For example:
repot_14586_02262014
repot_14586_02272014
repot_14586_02282014

How can I parameterise the source connection block so that I import only the newest version of the report into Omniscope automatically?

Best Regards, Christian]]> http://forums.visokio.com/discussion/2605/text-processing-is-question-mark-character-a-wildcards Thu, 19 Jun 2014 06:13:43 -0400 mattyh 2605@/discussions
I'm currently using the following formula =LEFT([LandingPageURL],SEARCH("?",[LandingPageURL]))

The idea is this just takes all the characters in LandingPageURL up to the question mark, however the result of the search is always 1, so I'm assuming question mark is a wildcard here. If it is, is there a way to not use it as a wildcard? I've tried to 'escape'/'literal' the ? character with backslash within the quotation marks and outside, but it still doesn't work. Any ideas?

Thank you in advance, Matt]]> http://forums.visokio.com/discussion/2545/text-mining-wildcard-operation-list-of-functions Fri, 02 May 2014 07:34:24 -0400 tobasko 2545@/discussions
I was testing the Text Mine Operation and think that the extraction of custom entities is a very nice feature. However, is it possible to extract regular expression (RegEx) or 'wildcard' patterns, like for example: "Host * has failed"? This would extract all matching phrases/tuples like "Host A has failed", "Host B has failed", and so on?

I haven't been able to get this to work yet unfortunately. If it is not possible, is there any other way to achieve something like this?

Many thanks in advance.

Cheers,
Tobi]]> http://forums.visokio.com/discussion/2471/filtering-record-filter-looking-for-word-with-spacess Mon, 17 Feb 2014 05:40:18 -0500 Nemesis 2471@/discussions
I want to filter a list contains a word " CLO " i.e with blank SPACE in front and back but Visokio won't let me do it, it uses "CLO" without spaces as the only input. Is there any wildcard character to do this??

I have been searching this using below Excel forumla:

=IF(OR(ISNUMBER(SEARCH({" word1 "," word2 "," word3 "}," "&A1&" "))),"YES","NO")]]> http://forums.visokio.com/discussion/2457/new-searchreplace-now-supports-regex-and-wildcards-2.9- Mon, 27 Jan 2014 08:02:11 -0500 victor 2457@/discussions


You can now use wildcards (* and ? ) in the "Search for" field for a simple, yet powerful, search/replace...or you can use full-fledged Regular Expressions (RegEx) which can read and even re-write almost any text string to bring out visual and filtering patterns implicit in raw unstructured data.

The regular expression syntax and replacement patterns are the same as the ones used in the formula function REPLACEREGEX. For a complete reference of the RegEx syntax, visit http://www.regular-expressions.info/]]> http://forums.visokio.com/discussion/2181/sources-renaming-folders-of-filess Wed, 05 Jun 2013 08:07:21 -0400 SteveP 2181@/discussions
If we try to open one of these files in a DataManager, there doesn't appear to be a way of doing it, without renaming the file to something like smith001.txt

Is there a way to EITHER open the files with their current names, OR do something to rename all of the files first?

Thanks]]> http://forums.visokio.com/discussion/1969/sources-importing-only-the-most-recent-file-in-a-folders Thu, 03 Jan 2013 10:20:34 -0500 briansj 1969@/discussions
For example, if I have:
DailyFile 2013-01-01
DailyFile 2012-12-30

I would want to have DataManager pick up the most recent file with "DailyFile" in the file name.]]> http://forums.visokio.com/discussion/1836/idea-imports-batch-append-wildcard-search-on-worksheetss Mon, 15 Oct 2012 12:22:50 -0400 kikorw 1836@/discussions http://forums.visokio.com/discussion/268/text-wildcards-in-formulae Fri, 26 Mar 2010 16:39:00 -0400 Dibbhead 268@/discussions
I have used the standard Excel * as a text wildcard in a formula but it does not work. Is there a different wildcard in Omniscope for any number of characters?

I have searched the help topics and can't find an answer to this.

Thanks]]>