Google

1K

Solutions

1K

Contributors

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

Share tech news, updates, or what's on your mind.

Sign up to Post

This version of the expression extracts the email address from a string of characters contained within cell E2 and replaces those characters with the result.

I also need versions of the expression that will extract the first name and one to extract the last name.

The email address can possibly be defined as any string of characters that are separated by an @ symbol with no spaces and surrounded entirely by either a (parenthesis) or <chevrons>.

This should work in a google sheet such as this one here https://docs.google.com/spreadsheets/d/1rQ5QC6Ipr5kkBDuNnIMY05Z09Q4q7lqZ52vd0bfCvtY/edit#gid=1895941459

=Regexextract(E2,"[A-z0-9._%+-]+@[A-z0-9.-]+\.[A-z]{2,4}")

Open in new window

0
Ensure you’re charging the right price for your IT
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

What is the solution to resolving the 0xC004F050 Windows activation code? Last week I was trying to upgrade a windows 10 home computer to Pro and it would not take either of the Pro codes that I tried. Even after a google search I was unable to find a solution to resolve it.
0
I have the problem getting the column value in google chart. The data is presented in the array . From the array I need to get the value Z.

The code is below

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>

	 	<script>
		

	function drawChart() {
	 	var data = new google.visualization.DataTable();
	 	//var clicktip='';
	 	
	 	
	 	data.addColumn('number', 'Month');
	 	data.addColumn('number',2017);
                data.addColumn('number',2018);
	 	
	 	
	 	//data.addColumn('number', 'sessionkey');
		//data.addColumn({role: 'tooltip', type: 'string', p: {html:true,trigger:'selection'});
		//data.addColumn({type:'string', role:'tooltip',p: {html:true}});  
		


    data.addRows([
      	
      		[{v: 3, f:'March',z:'242018'},null,8,]	,
      	
      		[{v: 6, f:'June',z:'242019'},null,13,]	,
      	
      		[{v: 7, f:'July',z:'242020'},null,10,]	,
      	
      		[{v: 11, f:'November',z:'272793'},null,5,]	,
      	
      ]);
     
    
     
    
     var options = {
        hAxis: {
            title: 'Month',
            showTextEvery: 1,
            legend: 'none',
            
            ticks: [{
                v: 1,
                f: 'Jan'
            }, {
                v: 2,
                f: 'Feb'
            }, {
                v: 3,
                f: 'Mar'
            }, {
                v: 4,
                f: 'Apr'
            }, {
                v: 5,
                f: 'May'
            }, {
          

Open in new window

0
Say, My Android phone is backing up call log history to google drive. I can view the file under backups in Google Drive. How do I download this file and inspect it? I want to view the raw data.

Does Google keep older backups or each time over right them and if so is there a setting or way to keep a history of backup files?
0
Say, I have an android Black Berry Key one with Google Backups enabled. I'm after restoring a backup of my call logs from 5 months ago.
How do I go about this? tx Shaun
0
Somehow Yahoo has weaseled it's way into becoming my default search engine. I want Google, NOT Yahoo. I'm using Chrome.

How do I fix this, and (if possible) prevent it in the future.

Thanks
0
Hi,

I was told that Google Drive has an option to create Survey/Poll and even send to individuals so they can take it.  Some question for those expert who have worked with this tools:

  • The data that users fill out in a databases?
  • Are there reports for this database?
  • Can I export the survey/pool?
  • When creating a survey/poll, can I insert formulas if needed?
  • Any remarks on the tool?
0
is there of getting a website or app to look at the logistics of going from A to three different places in the best logical or efficient order?

like sightseeing by car but optimising the route without double backing on oneself?  does google map have a way of calculating all that for you showing each route back to back?
0
I am interested in buying a an Android PC suite phone manager. After doing extensive research I was able to limit my choices down to 3 products. All seem to be the best as far as feature rich,compatibility and ease of use. These are Dr.Fone , TunesGO {I believe both products are available from Wondershare.com vendor}and lastly Apowersoft phone manager. I would like to know if the 2 products by wondershare
are the same and if not what is the difference between them? lastly which one would be the best PC suite phone manager to buy from all three. For backup, recovery purposes. Please if possible provide me with a comparison chart of these 3 product. I was unable to find anything on Google and I spent a lot of time doing so.
Thank you,
Basem
0
I am using a prewritten script in Google Sheets.

It reads the column titles and if it encounters a column title named "Timestamp" it posts the current Timestamp. Here is that portion of the script.

    // loop through the header columns
    for (i in headers){
      if (headers[i] == "Timestamp"){ // special case if you include a 'Timestamp' column
        row.push(new Date());
      } else { // else use header name to get data
        row.push((e.parameter[headers[i]] && e.parameter[headers[i]]!='undefined') ? e.parameter[headers[i]] : '');
      }
    }

Open in new window


It places the current Date into the row for that column in the format 9/28/2019 8:42:49.

I would like it to place the format as: 2019-09-28 08:42:49.  

Is that possible?

I tried this and it didn't work.
row.push(new Date("Y-m-d H:i:s"));

Open in new window


Thanks.
0
HTML5 and CSS3 Fundamentals
LVL 13
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

I added google recapcha 2 to this form: https://www.magickitchen.com/contact.html
I thought I had it working, by adding this code below. I thought I could do it all client side. But I just realized that I can complete the form without checking the box. I obviously need a function, the one given in the example was alert("grecaptcha is ready!");

<script src="https://www.google.com/recaptcha/api.js?onload=onloadCallback&render=explicit"
    async defer>
</script>
<script type="text/javascript">
  var onloadCallback = function() {
   
  };
</script>

https://developers.google.com/recaptcha/docs/display  I obviously am missing a big part here. Help!
0
Guys,
I have a client with a Ricoh MP C5503 that I am trying to set up with scan-to-email. Because the Ricoh only provides SSL encryption, I set up a free Juno email account dedicated to the printer.  So we are on the same page, here's where I put what:
Device Management > Configuration
Under 'Device Settings' section
Click: Email
-Administrator E-mail address: (email@juno.com)
-SMTP Server Name: smtp.juno.com
-SMTP Port Number: 465
-SMTP Authentication: On
  -SMTP Email Address: (email)@juno.com
  -SMTP User Name: (email)@juno.com
  -SMTP Password: (password)
  -SMTP Authentication: Auto-select

I also tried:
Under 'Device Settings' section
Click: Email
-Administrator E-mail address: (email@juno.com)
-SMTP Server Name: smtp.juno.com
-SMTP Port Number: 25
-SMTP Authentication: Off
  -SMTP Email Address: (email)@juno.com
  -SMTP User Name: (email)@juno.com
  -SMTP Password: (password)
  -SMTP Authentication: Auto-select

My client is using Google Fibre as their ISP. One of my tech friends who works a Ricoh service says the issue is Google Fibre blocks access to any DNS other than the local IP pointing to the Google Fibre Gateway. I confirmed this as I set up the Ricoh with:
DNS 1: 192.168.1.1 (the Google Fibre Gateway) - Test Successful
DNS 2: 8.8.8.8 - Test Unsuccessful
Or DNS 2: 1.1.1.1 (Cloud Flare) - Test Unsuccessful
Or DNS 2: 1.0.0.1 (Cloud Flare) - Test Unsuccessful
He says that if I can figure out what DNS server Google Fibre is …
0
Hello i keep getting this smart search page as default. i deleted and reinstalled google Chrome but its still there.

is this an infection. I run Malwarebytes but it didn't detect anything. ( see attached pic).

Can someone send me step by step instructions on how to remove it please.

Thank you,smart search default page
0
Hello experts,
I set up the following AutoHotkey to send clipboard on google drive and upload files.
+F9::
FilePath1:=Clipboard
FilePath2:=StrReplace(FilePath1, """")
If (Not FileExist(FilePath2))
{
	Msgbox,0x10,Error, Your clipboard which report the following value %FilePath2% doesn't exist	
	Return
}
Else
Msgbox,0x40,Success, Your clipboard which report the following value %FilePath2% exist	
WinGetActiveTitle,Title
If (InStr(Title,"Google Drive"))
{
	PostMessage,0x112,0xF030,,,%Title%
	Sleep, 100
	Send, mc 	
	Sleep, 100
	Send, {Down 2}
	Sleep, 100
	Send, {Enter}
	Sleep, 1500
	WinGetActiveTitle,Title
	If (InStr(Title,"Open"))
	{	
		Send, %FilePath2%
		Sleep, 100
		Send, {Enter}
		Return
	}
	Else
	MsgBox,0x10,Error,Unable to send path as active window doesn't contains name expected
	Return
}
Else
  MsgBox,0x10,Error,Google Drive is not the active window
Return

Open in new window


I made a test with the following cases and it works:
1-Error when clipboard doesn't contain a file which exist
2-Success when the clipboard contain a file which exist
3-Error when google drive is not the active windows

Prior to adding to my AutoHotkey file I would like to have some advice to see if the AutoHotkey should be revised in term of structure, conditions and loops.
I am aware that Send keys is not the best way however this is how I can work on google drive.

Thank you for your help.
0
Hey,
so on E.E. , I have been able to finish an RTS server in Java, blog w income, I'm ready to commit to a JS phone game..
I'm using ATOM as my Interactive development environment. Will it be suboptimal for my various publication needs?
If I do my game on a web page, it is simply placing the .htm file and the .js file in the folder. What about app compilation? Do the google and Mac stores have their way to package the javascript somehow? What should I be aware of?

I just make the game and worry later? :)

Thanks
0
In GAFE how do I add our domain to the login page so that when a student logs in they don't need to add @domainname.com every single time? Instead it's already auto populated and they can just type in their username?

Thanks in advance!
0
I need to create several hundred email addresses. I would prefer to create Google accounts and use the Gmail addresses. These need to be free accounts and not G Suite for Business accounts.

These are not for spamming or scamming. Rather, we are a non-profit organization configuring several hundred Kindle devices for students in remote areas around the world. To do this, we need to create hundreds of Amazon accounts using hundreds of unique email addresses. While the creation of the Amazon accounts will be laborious, I think I can do it. We will configure one device per Amazon account, and each account will purchase 60 books. I would like to use Gmail addresses/Google accounts for email, as I am not yet sure if we will be using Kindle, Kindle Fire, or the Kindle app on an Android tablet. If we go with the app, then we will need to use Google Play, which will require a Google Account.

Once each device is loaded and configured, the email/Gmail/Google account as well as the Amazon account (and loaded device) will be handed over to the end user who will take ownership of the Amazon and Google account. We will be providing these as gifts; we are not reselling accounts and devices.

What is the best way to create many Google accounts without raising red flags? In the end, we need around 250 accounts. We don't need to create them all at once.
1
Hello all,
In Google Chrome, I am getting an error that states This site can't be reached.
If I try the same site in Internet Explorer it works great.
This is a WIndows 10 Pro computer hooked up to AD, where the DNS is from the main AD server.  No other computers are having this issue.
I did the following:
Restarted the DNS client
Reset TCP/IP
Ran Network Troubleshooter
Reset Google Chrome settings
Reinstalled Chrome
After each thing I tried, I rebooted the computer and tested and get the same error.
There is NO proxy being used.
I have no idea what to do next to fix this error
Thanks in advance for your help,
Kelly W
0
I setup a Google Voice account for my iPhone.
Is it possible to change the display that is sent to the person I am calling from that number?
IE, I call back a client, with Google Voice number, their phone rings and normally displays my number.
Can I change that to display, "Prime Tech"?
TIA
0
Introduction to R
LVL 13
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Hello experts,
I frequently use gmail and google drive.
I was wondering how to set up some ahk which are not part of default shortcuts keyboard proposed.
1)      Be able to download a document on drive
The following combination works but I don't know if there is an smart way to do this: {Shift}+{F10 }+ {Arrow up 2}+{Enter}
2)      Be able to download an attached file from gmail:
The following combination works but I don't know if there is an smart way
3)      Be able to attach a file when composing a new e-mail
The following combination works but I don't know if there is an smart way to do this: {Tab 7}+{Enter}
4)      Be able to open received message in a new windows
Thank you for your help.
0
If I create a presentation in PowerPoint 365, can it be edited in Google Slides (https://gsuite.google.com/products/slides/)?
Can Google Slides edit  a PowerPoint file?
Can you export a PowerPoint file to a format editable in Google Slides?
0
Can you add charts using  Microsoft PowerPoint Online?
For instance, let us say that you use Google Chrome to login to office.com or portal.office.com and you open the Online version of PowerPoint, can you use a Google Chrome extension to add a chart to a PowerPoint file?
Does a Google Chrome extension exist that will allow you to add charts to PowerPoint Online?
0
I am using a Dell tower desktop with an XP operating system. I use it mostly to run several programs to write and print simple things, as well as some pretty elementary stuff. As you may imagine, it works just fine for such things.

I also had in hooked up to the Internet for very limited, infrequent use and again, no problems.

Now I am rearranging some things and have moved the computer to another area in the same room, with everything the same except for the addition of a new monitor. I did have to use an older connection to get the monitor  video into the computer, but no problem.

BUT when I plugged my Internet cable into the  SAME router, I could not get an Internet connection (using Google Fiber). Tried a second cable with the same result.

I can't figure this out. Surely a new monitor is not to blame for this situation?
0
Hi. I am getting the following error when I try and run my ASP.net web app in debug mode

This site can’t be reached localhost refused to connect.
Search Google for localhost 62054 Invoicing
ERR_CONNECTION_REFUSED
0
https://search.google.com/test/mobile-friendly?id=vrughLHv7-LfXilg5Zu_Ng  that test says the page isn't mobile friendly, and the screenshot shows this:


Capture.JPG
But I can't replicate that in Chrome. It looks fine in Chrome. How can I test and fix this issue? Thanks.
0