http://forums.visokio.com/discussions/tagged/search-replace/feed.rss Mon, 30 Oct 17 12:14:43 -0400 Tagged with search-replace - Visokio Forums en-CA http://forums.visokio.com/discussion/3260/search-and-replace-large-amount-of-data Mon, 31 Jul 2017 09:39:04 -0400 CarenaLi 3260@/discussions I am trying to do search and replace in my data,
e.g. in my data it shows "yt", then I need to replace it as "YouTube".

I have an Excel file of all short codes and their full names.
Is there any quicker way to do so?
Many thanks!
Carena]]> 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/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]]> 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/2151/searchreplace-remove-underscores-hyphens-leaving-no-spaces Fri, 17 May 2013 11:29:47 -0400 nicci113 2151@/discussions
I need to do this coz my data for merge from another source require me to concatenate the text, would a space make a difference that would defeat the match/merge?

If so, how to take them out and if not then I can keep going, please suggest. Your video only suggest the simple logic and doesn't mention about removing spaces...]]> http://forums.visokio.com/discussion/2056/datamanager-replacing-data-values Mon, 18 Mar 2013 06:42:01 -0400 grahamb 2056@/discussions http://forums.visokio.com/discussion/1421/idea-standardise-values-blocks Mon, 26 Mar 2012 04:13:06 -0400 daniel 1421@/discussions
I do have one more suggestion though is that the match up would allow for Many to One scenarios as I have encountered examples where an area name match up would be many to one as a number of areas merged into a single area i.e:


Old Name of Areas :Chester-le-Street, Derwentside, Durham, Easington, Sedgefield, Teesdale, Wear Valley

Which are all now grouped up as just County Durham due to UK parliamentary boundary changes. On the whole the UK has been shrinking the number of areas so often you may get an outdated list with "extra" areas names than the current UK parliament boundaries list.


Original comment taken from a different thread:

This is quite a common problem, but not one which the merge/join block should attempt to solve. Fuzzy matching won't help here. For example, some common value mismatches, most of which you can't solve with fuzzy matching:

- US, USA, United States, US of A, America
- Cardiff, Caerdydd, Cardiff/Caerdydd
- Russia, Russian Federation
- London, Londres
- GB, UK, United Kingdom, Britain, Great Britain, British Isles
etc.

Currently you have to use a Search/Replace block to manage these, which is very tedious to configure. You can use merge/join to identify unique mismatches, then auto-generate a Search/Replace configuration based on those mismatches, but you are still going to have to manually locate each right-side value for each missing left-side value.

A possible solution is a new kind of block, "Standardise values". It would have two inputs: (1) the main data (2) the lookup file. You would pick a field from each side, much as you do in merge/join. It would then enumerate all unique values from left that are missing from right, with searchable drop-downs to pick the correct mapping. It would result in the main data from the left, with all values standardised according to the right file. ]]> http://forums.visokio.com/discussion/997/changing-values-add-formulae-fields-or-use-searchreplaces Mon, 19 Sep 2011 12:15:46 -0400 elitem 997@/discussions
For example, I have a table of people's details i.e. names, address etc. Some of them have an email address in the email field, and for some the email field is null. I want to create a new field which will be called "Has Email?" and will be updated with either "yes" or "no" depending on whether or not the email field for that record has something in it or is null.

Can you help? Thanks Elite]]>