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]]>
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]]>
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]]>
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")]]>
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/]]>
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]]>
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.]]>
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]]>