http://forums.visokio.com/discussions/tagged/text-processing/feed.rss Mon, 30 Oct 17 12:13:10 -0400 Tagged with text-processing - Visokio Forums en-CA http://forums.visokio.com/discussion/3267/searchregex-formula-not-working Mon, 18 Sep 2017 06:30:00 -0400 JohnMR 3267@/discussions
I'm trying to use Searchregex formula to pull

=searchregex("^.{3}[A-Za-z0-9 ]+\K.",[Campaing],1)

Searchregex usually works but not when I add the "\" in \K I get an error: Error with formula: Invalid text """ - an open bracket, literal number, reference or function was expected.

When I remove the slash the formula works but I need that slash in it. Why is this not working?
Thanks,
John.]]> http://forums.visokio.com/discussion/3022/formulae-replacing-substring-in-a-text-field Tue, 03 Nov 2015 11:42:47 -0500 Phillipa 3022@/discussions
I have a text field with different strings.
I am trying to replace the first 2 characters of each string.

Specifically I want to replace "PT" with "m1"; "m1" with "m2"; "m2" with "m3" etc.

I have seen that there is a REPLACE and REPLACEREGEX function, which I would be interested in using,
but can't seem to get either of them to work correctly. Could someone help?

Thanks
Phillipa]]> http://forums.visokio.com/discussion/2146/idea-formulae-text-fill-downs Wed, 15 May 2013 14:07:15 -0400 hgross 2146@/discussions
I essentially want all of the blank rows to be filled in with the text above until it reaches the next text string.

Thanks!]]> http://forums.visokio.com/discussion/2873/functions-text-string-lengths Tue, 17 Mar 2015 11:48:30 -0400 alexandervolk 2873@/discussions
Many thanks!
Alex]]> http://forums.visokio.com/discussion/2812/poll-improving-text-mining-capabilitiess Wed, 14 Jan 2015 12:48:27 -0500 tjbate 2812@/discussions http://forums.visokio.com/discussion/2740/unstructured-data-transformation-reading-in-transactional-data Tue, 07 Oct 2014 07:41:48 -0400 freddiewalker 2740@/discussions I have some transactional data I would like to read into Omniscope if possible.. If not, any ideas of other programs/software I could potentially use would be appreciated.
I have attached an excel file with a few quick examples of the data (and its breakdown). Ideally I would like to read in each separate transaction into an amount of records that corresponds to how many products there are in that transaction. So for each product I would have date/time/payment method/units/value/multibuy information etc...

Would this be possible on Omniscope?
Many thanks.]]> 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/2600/text-processing-google-analytics-string-aggregationcountss Mon, 16 Jun 2014 11:38:21 -0400 Ben_Owens 2600@/discussions
We currently have some features that pass some details in the URL (below is a very simplified example to illustrate my case)

www.mywebsite.com/fundfactsheets?ISIN=ANUMBER

So I'm getting in my data set

www.mywebsite.com/fundfactsheets?ISIN=0000001; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000002; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000003; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000004; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000005; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000006; page count 2
www.mywebsite.com/fundfactsheets?ISIN=0000007; page count 2

I really want this as aggregated data

www.mywebsite.com/fundfactsheets?ISIN* ; page count 14

I've not been able to find any regrex or way to manipulate the data within Visokio (new tool - it could be staring me in the face!!) to achieve this.

I've had a look on the forum but not seen anything there either.

Any ideas? I'm sure it will do this so any help will be gratefully received.

]]> http://forums.visokio.com/discussion/2580/scaling-text-characterstring-length-limit-per-cells Thu, 05 Jun 2014 05:23:47 -0400 mattyh 2580@/discussions
Thank you, Matt]]> http://forums.visokio.com/discussion/2554/searchreplace-replacing-patterns-of-letters-within-text-stringss Thu, 08 May 2014 18:02:50 -0400 Valentina 2554@/discussions
I have a column with Codes like example below.

SSP
LSP
PPP
SSS
LLP

What I would like to achieve is to replace the P and L letters with M and O respectively.Is thereany formula available in 2.9 that can do this? Eventually I would like to have the following table:

SSM
OSM
MMM
SSS
OOM

Thanks]]> 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/2544/formulae-text-processing-determining-text-or-numbers Thu, 01 May 2014 08:23:16 -0400 aknotts 2544@/discussions
TYPEOF(value(left([my_string], 1)))

This returns the type of the argument passed to it (e.g. text, decimal, integer)
]]> http://forums.visokio.com/discussion/2389/idea-text-processing-eliminatesubstitute-unwanted-characters-within-stringss Tue, 29 Oct 2013 07:06:58 -0400 davedunckley 2389@/discussions
Just wondering if there is a way of replacing everything within brackets in a string of text.

I have a field that has a name, then a former name within parentheses. I would like to be able to remove the ( ) and also everything within.

Example:

Smith (jones)

Should become:
Smith

as should:
(jones) Smith

Thanks in advance
Dave]]>