Copy Text from web page and paste into excel

Help StudioX
,
1

Hello everyone!
I want to copy some text from Internet to an excel, but it is saved as the following:

“{
“”@context”“: ““https://schema.org””,
“”@type”": ““PostalAddress””,
““addressCountry””: ““España””,
““addressLocality””: ““MADRID””,
““addressRegion””: ““MADRID””,
““name””: ““REPSOL SA””,
““postalCode””: "“28045"”,
““streetAddress””: "“MENDEZ ALVARO 44"”
}

{
“”@context"“: ““https://schema.org””,
“”@type”“: ““LocalBusiness””,
““address””: {
“”@type”": ““PostalAddress””,
““addressLocality””: ““MADRID””,
““addressRegion””: ““MADRID””,
““streetAddress””: "“28045 MENDEZ ALVARO 44"”
},
““description””: ““PETRÓLEO Y GAS””,

““name””: ““REPSOL SA””
,““telephone””: “”+34913318093""
}

{
    ""@context"": ""https://schema.org"",
    ""@type"": ""Corporation"",
    ""name"":  ""REPSOL SA"",
    ""alternateName"": ""REPSOL SA"",
    ""logo"": ""https://www.infocif.es/images/logo-empresas/nif-78374725.gif?v=1.01"",
    ""image"": ""https://www.infocif.es/images/logo-empresas/nif-78374725.gif?v=1.01"",
    ""foundingDate"": ""01/11/1986"",
    ""foundingLocation"": ""MADRID"",
    ""isicV4"": ""PETRÓLEO Y GAS"",
    ""numberOfEmployees"": ""0"",
    ""taxID"": ""A78374725"",
    ""telephone"": ""+34913318093"",
    ""identifier"":
            {
            ""@type"": ""PropertyValue"",
            ""propertyID"": ""Company Number"",
            ""value"":  ""A78374725""
            },
    ""founder"":
          {
          ""@type"": ""Person"",
          ""name"": ""BRUFAU NIUBO ANTONIO"",
          ""jobTitle"": ""Presidente:"",
          ""worksFor"": {
                      ""@type"": ""Organization"",
                      ""name"": ""REPSOL SA""
                      }
           },
    ""contactPoint"":
          {
          ""@type"": ""ContactPoint"",
          ""telephone"": ""+34913318093"",
          ""contactType"": ""customer service"",
          ""areaServed"": ""ES"",
          ""availableLanguage"": ""es""
           },          
    ""url"": ""http://www.repsol.com"",
    ""address"":
          {
          ""@type"": ""PostalAddress"",
          ""addressLocality"": ""MADRID"",
          ""addressRegion"": ""MADRID"",
          ""postalCode"": ""28045"",
          ""streetAddress"": ""MENDEZ ALVARO 44""
          }

    }                    

    
    Mendez Alvaro 44
             28045 
            -
            Madrid"

image
image260×820 9.57 KB

Can anyone help me?

Thanks!

2

Hey,
it’s looks like JSON. Try deserialize extracted text from webpage and get values which you need from json :slight_smile:

1 Like
3

Is there any way that I can read this text without saving it like JSON?

Thank you in advance!

4

It’s depends what you are looking for there.
You can also use regex but in my opinion JSON is more friendly :wink:

5

My goal is to copy literally the result of a search, since it is an address that I want to write in an excel. I would like to copy thie:

image
image1713×555 131 KB

6

Ok. So which activity are you using ? It’s looks like you extracting all webpage.
Use get text and show me how selector looks like.

7

I do not manage to print my screen and send you how it gets text.

It says it is the default method, with a “fuzzy selector” (selector difuso in Spanish)

8

It looks like your “get text” activity is using an invalid selector. Can you open UI Explorer for the selector, click “highlight element” and send us a screenshot of it?

9

Try change the selector … however if you can’t provide the screenshot and you have to use this extracted text please take a look to this project. It is simple example how to use json and getting values :slight_smile:
comm1.zip (2.7 KB)

@Rafael_Abad to be sure - Is it StudioX ?