Sign Up


Have an account? Sign In Now

Sign In


Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask question.


Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

Rocketbot Forum

Rocketbot Forum Logo Rocketbot Forum Logo

Rocketbot Forum Navigation

  • Academy Rocketbot
  • Tutorials
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Popular
  • Categories
  • Tags
  • Questions
    • New Questions
    • Most voted
    • Most visited
    • Most Responded
  • Academy Rocketbot
  • Tutorials
Home/ Questions/Q 3668
Next
Answered
EdgardBringas
EdgardBringas

EdgardBringas

  • 1 Question
  • 3 Answers
  • 0 Best Answers
  • 20 Points
View Profile
  • 0
EdgardBringas
Asked: July 14, 20212021-07-14T00:17:21+00:00 2021-07-14T00:17:21+00:00In: Academy

Leer una tabla de un correo electronico

  • 0
Leer una tabla de un correo electronico

Hola

Estoy utilizando el comando leer mail, y lo que necesito es leer una tabla, pero como lo puedo pasar a un excel:

 

{‘message’: ‘Estimados Clientes:\r\n\r\n\r\n\r\nBuen d=C3=ADa, para vuestra informaci=C3=B3n y referencia adjunto itinerari=\r\no HYUNDAI\r\nGLOVIS.\r\n\r\n*PURE CAR CARRIER SCHEDULE*\r\n\r\n*(FAR EAST, USA, MEXICO, ECSA, WCSA)*\r\n\r\n05-jul-21\r\n\r\n*VESSEL / VOYAGE*\r\n\r\nGLOVIS SUNLIGHT\r\n\r\nGRAND DAHLIA\r\n\r\nGLOVIS SKY\r\n\r\nK ASIAN BEAUTY\r\n\r\nGLOVIS CHAMPION\r\n\r\n*COUNTRY*\r\n\r\n*PORT OF CALL*\r\n\r\n20\r\n\r\n19\r\n\r\n26\r\n\r\n39\r\n\r\n56\r\n\r\nPA\r\n\r\nPANAMA CANAL\r\n\r\n31-Mar-21\r\n\r\n3-May-21\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nEC\r\n\r\nMANTA\r\n\r\n\r\n\r\n\r\n\r\n31-May-21\r\n\r\n\r\n\r\n\r\n\r\nPA\r\n\r\nCRISTOBAL\r\n\r\n2-Apr-21\r\n\r\n4-May-21\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nJM\r\n\r\nKINGSTON\r\n\r\n\r\n\r\n6-May-21\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nUS\r\n\r\nFREEPORT\r\n\r\n\r\n\r\n10-May-21\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nMX\r\n\r\nALTAMIRA\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n30-May-21\r\n\r\n26-Jun-21\r\n\r\nMX\r\n\r\nVERACRUZ\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n30-Jun-21\r\n\r\nUS\r\n\r\nGALVESTON\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n3-Jul-21\r\n\r\nUS\r\n\r\nPORT EVERGLADES\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n7-Jul-21\r\n\r\nUS\r\n\r\nJACKSONVILLE\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nPR\r\n\r\nSAN JUAN\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nBS\r\n\r\nNASSAU\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nUS\r\n\r\nBRUNSWICK – 1\r\n\r\n6-Apr-21\r\n\r\n14-May-21\r\n\r\n\r\n\r\n11-Jun-21\r\n\r\n8-Jul-21\r\n\r\nUS\r\n\r\nNEWARK\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n13-Jul-21\r\n\r\nUS\r\n\r\nPHILADELPHIA\r\n\r\n11-Apr-21\r\n\r\n17-May-21\r\n\r\n\r\n\r\n7-Jun-21\r\n\r\n\r\n\r\nUS\r\n\r\nBALTIMORE\r\n\r\n12-Apr-21\r\n\r\n18-May-21\r\n\r\n\r\n\r\n9-Jun-21\r\n\r\n15-Jul-21\r\n\r\nUS\r\n\r\nBRUNSWICK – 2\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nDO\r\n\r\nSANTO DOMINGO\r\n\r\n18-Apr-21\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nTT\r\n\r\nPORT OF SPAIN\r\n\r\n21-Apr-21\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nBR\r\n\r\nSUAPE\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nBR\r\n\r\nRIO DE JANEIRO\r\n\r\n29-Apr-21\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nBR\r\n\r\nVITORIA\r\n\r\n\r\n\r\n30-May-21\r\n\r\n23-Jun-21\r\n\r\n26-Jun-21\r\n\r\n29-Jul-21\r\n\r\nBR\r\n\r\nSANTOS – 1\r\n\r\n30-Apr-21\r\n\r\n1-Jun-21\r\n\r\n20-Jun-21\r\n\r\n28-Jun-21\r\n\r\n31-Jul-21\r\n\r\nBR\r\n\r\nPARANAGUA\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n2-Aug-21\r\n\r\nBR\r\n\r\nRIO GRANDE\r\n\r\n2-May-21\r\n\r\n3-Jun-21\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nUY\r\n\r\nMONTEVIDEO\r\n\r\n4-May-21\r\n\r\n4-Jun-21\r\n\r\n16-Jun-21\r\n\r\n\r\n\r\n\r\n\r\nBR\r\n\r\nSANTOS – 2\r\n\r\n6-May-21\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nCL\r\n\r\nMAGELLAN STRAIT\r\n\r\n12-May-21\r\n\r\n8-Jun-21\r\n\r\n13-Jun-21\r\n\r\n6-Jul-21\r\n\r\n8-Aug-21\r\n\r\nCL\r\n\r\nSAN ANTONIO\r\n\r\n15-May-21\r\n\r\n13-Jun-21\r\n\r\n\r\n\r\n11-Jul-21\r\n\r\n12-Aug-21\r\n\r\nCL\r\n\r\nIQUIQUE\r\n\r\n\r\n\r\n\r\n\r\n4-Jun-21\r\n\r\n\r\n\r\n\r\n\r\nPE\r\n\r\nCALLAO\r\n\r\n23-May-21\r\n\r\n18-Jun-21\r\n\r\n\r\n\r\n31-Jul-21\r\n\r\n24-Aug-21\r\n\r\nEC\r\n\r\nMANTA\r\n\r\n26-May-21\r\n\r\n22-Jun-21\r\n\r\n\r\n\r\n\r\n\r\n28-Aug-21\r\n\r\nMX\r\n\r\nLAZARO CARDENAS\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nUS\r\n\r\nSAN FRANCISCO\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nZA\r\n\r\nDURBAN\r\n\r\n\r\n\r\n\r\n\r\n6-Jul-21\r\n\r\n\r\n\r\n\r\n\r\nKR\r\n\r\nULSAN\r\n\r\n\r\n…\r\n\r\n[Mensaje recortado] Ver todo el mensaje\r\n<https://mail.google.com/mail/u/0?ui=3D2&ik=3D6d68d27fec&view=3Dlg&permmsgi=\r\nd=3Dmsg-a%3Ar4178538003034754013&ser=3D1>\r\n2 archivos adjuntos\r\n’, ‘subject’: ‘HYUNDAI GLOVIS – Far East, USA, México, ECSA & WCSA Vessel Schedule ‘, ‘from’: ‘Edgar Bringas <ebringas@euromotors.com.pe>’, ‘files’: ‘No attachment found.’}

mail
  • 6 6 Answers
  • 974 Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook

    6 Answers

    • Voted
    • Oldest
    • Recent
    1. Bender

      Bender

      • 0 Questions
      • 222 Answers
      • 28 Best Answers
      • 666 Points
      View Profile
      Bender
      2021-07-14T14:53:08+00:00Added an answer on July 14, 2021 at 2:53 pm

      Hola EdgardBringas,

      El comando «Leer Email» de qué módulo estás utilizando? eso es todo lo que te devuelve o falta algo?

      • 0
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp
      • EdgardBringas

        EdgardBringas

        • 1 Question
        • 3 Answers
        • 0 Best Answers
        • 20 Points
        View Profile
        EdgardBringas
        2021-07-14T16:21:04+00:00Replied to answer on July 14, 2021 at 4:21 pm

        Hola

        Si es todo lo que devuelve

        • 0
        • Reply
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
          • Share on LinkedIn
          • Share on WhatsApp
        • A16

          A16

          • 1 Question
          • 335 Answers
          • 31 Best Answers
          • 901 Points
          View Profile
          Stephen Byerley
          2021-07-14T17:27:13+00:00Replied to answer on July 14, 2021 at 5:27 pm

          Según la respuesta de tu correo, puedes obtener los datos de la tabla así:
          En un asignar variable escribes esto

          table = {correo}["message"].split("\r\n\r\n")[12:-2]

          Te devolverá esto

          ['*COUNTRY*', '*PORT OF CALL*', '20', '19', '26', '39', '56', 'PA', 'PANAMA CANAL', '31-Mar-21', '3-May-21', '', '', '', 'EC', 'MANTA', '', '', '31-May-21', '', '', 'PA', 'CRISTOBAL', '2-Apr-21', '4-May-21', '', '', '', 'JM', 'KINGSTON', '', '6-May-21', '', '', '', 'US', 'FREEPORT', '', '10-May-21', '', '', '', 'MX', 'ALTAMIRA', '', '', '', '30-May-21', '26-Jun-21', 'MX', 'VERACRUZ', '', '', '', '', '30-Jun-21', 'US', 'GALVESTON', '', '', '', '', '3-Jul-21', 'US', 'PORT EVERGLADES', '', '', '', '', '7-Jul-21', 'US', 'JACKSONVILLE', '', '', '', '', '', 'PR', 'SAN JUAN', '', '', '', '', '', 'BS', 'NASSAU', '', '', '', '', '', 'US', 'BRUNSWICK - 1', '6-Apr-21', '14-May-21', '', '11-Jun-21', '8-Jul-21', 'US', 'NEWARK', '', '', '', '', '13-Jul-21', 'US', 'PHILADELPHIA', '11-Apr-21', '17-May-21', '', '7-Jun-21', '', 'US', 'BALTIMORE', '12-Apr-21', '18-May-21', '', '9-Jun-21', '15-Jul-21', 'US', 'BRUNSWICK - 2', '', '', '', '', '', 'DO', 'SANTO DOMINGO', '18-Apr-21', '', '', '', '', 'TT', 'PORT OF SPAIN', '21-Apr-21', '', '', '', '', 'BR', 'SUAPE', '', '', '', '', '', 'BR', 'RIO DE JANEIRO', '29-Apr-21', '', '', '', '', 'BR', 'VITORIA', '', '30-May-21', '23-Jun-21', '26-Jun-21', '29-Jul-21', 'BR', 'SANTOS - 1', '30-Apr-21', '1-Jun-21', '20-Jun-21', '28-Jun-21', '31-Jul-21', 'BR', 'PARANAGUA', '', '', '', '', '2-Aug-21', 'BR', 'RIO GRANDE', '2-May-21', '3-Jun-21', '', '', '', 'UY', 'MONTEVIDEO', '4-May-21', '4-Jun-21', '16-Jun-21', '', '', 'BR', 'SANTOS - 2', '6-May-21', '', '', '', '', 'CL', 'MAGELLAN STRAIT', '12-May-21', '8-Jun-21', '13-Jun-21', '6-Jul-21', '8-Aug-21', 'CL', 'SAN ANTONIO', '15-May-21', '13-Jun-21', '', '11-Jul-21', '12-Aug-21', 'CL', 'IQUIQUE', '', '', '4-Jun-21', '', '', 'PE', 'CALLAO', '23-May-21', '18-Jun-21', '', '31-Jul-21', '24-Aug-21', 'EC', 'MANTA', '26-May-21', '22-Jun-21', '', '', '28-Aug-21', 'MX', 'LAZARO CARDENAS', '', '', '', '', '', 'US', 'SAN FRANCISCO', '', '', '', '', '', 'ZA', 'DURBAN', '', '', '6-Jul-21', '', '', 'KR', 'ULSAN']

          Para transformarlo a una tabla (lista 2D) debes colocar esto en un asignar variable

          [{table}[i: i + 7] for i in range(0, len({table}), 7)]

          y tendrás esto que puedes enviar directo a excel

          [['*COUNTRY*', '*PORT OF CALL*', '20', '19', '26', '39', '56'], ['PA', 'PANAMA CANAL', '31-Mar-21', '3-May-21', '', '', ''], ['EC', 'MANTA', '', '', '31-May-21', '', ''], ['PA', 'CRISTOBAL', '2-Apr-21', '4-May-21', '', '', ''], ['JM', 'KINGSTON', '', '6-May-21', '', '', ''], ['US', 'FREEPORT', '', '10-May-21', '', '', ''], ['MX', 'ALTAMIRA', '', '', '', '30-May-21', '26-Jun-21'], ['MX', 'VERACRUZ', '', '', '', '', '30-Jun-21'], ['US', 'GALVESTON', '', '', '', '', '3-Jul-21'], ['US', 'PORT EVERGLADES', '', '', '', '', '7-Jul-21'], ['US', 'JACKSONVILLE', '', '', '', '', ''], ['PR', 'SAN JUAN', '', '', '', '', ''], ['BS', 'NASSAU', '', '', '', '', ''], ['US', 'BRUNSWICK - 1', '6-Apr-21', '14-May-21', '', '11-Jun-21', '8-Jul-21'], ['US', 'NEWARK', '', '', '', '', '13-Jul-21'], ['US', 'PHILADELPHIA', '11-Apr-21', '17-May-21', '', '7-Jun-21', ''], ['US', 'BALTIMORE', '12-Apr-21', '18-May-21', '', '9-Jun-21', '15-Jul-21'], ['US', 'BRUNSWICK - 2', '', '', '', '', ''], ['DO', 'SANTO DOMINGO', '18-Apr-21', '', '', '', ''], ['TT', 'PORT OF SPAIN', '21-Apr-21', '', '', '', ''], ['BR', 'SUAPE', '', '', '', '', ''], ['BR', 'RIO DE JANEIRO', '29-Apr-21', '', '', '', ''], ['BR', 'VITORIA', '', '30-May-21', '23-Jun-21', '26-Jun-21', '29-Jul-21'], ['BR', 'SANTOS - 1', '30-Apr-21', '1-Jun-21', '20-Jun-21', '28-Jun-21', '31-Jul-21'], ['BR', 'PARANAGUA', '', '', '', '', '2-Aug-21'], ['BR', 'RIO GRANDE', '2-May-21', '3-Jun-21', '', '', ''], ['UY', 'MONTEVIDEO', '4-May-21', '4-Jun-21', '16-Jun-21', '', ''], ['BR', 'SANTOS - 2', '6-May-21', '', '', '', ''], ['CL', 'MAGELLAN STRAIT', '12-May-21', '8-Jun-21', '13-Jun-21', '6-Jul-21', '8-Aug-21'], ['CL', 'SAN ANTONIO', '15-May-21', '13-Jun-21', '', '11-Jul-21', '12-Aug-21'], ['CL', 'IQUIQUE', '', '', '4-Jun-21', '', ''], ['PE', 'CALLAO', '23-May-21', '18-Jun-21', '', '31-Jul-21', '24-Aug-21'], ['EC', 'MANTA', '26-May-21', '22-Jun-21', '', '', '28-Aug-21'], ['MX', 'LAZARO CARDENAS', '', '', '', '', ''], ['US', 'SAN FRANCISCO', '', '', '', '', ''], ['ZA', 'DURBAN', '', '', '6-Jul-21', '', ''], ['KR', 'ULSAN']]

          • 1
          • Reply
          • Share
            Share
            • Share on Facebook
            • Share on Twitter
            • Share on LinkedIn
            • Share on WhatsApp
          • EdgardBringas

            EdgardBringas

            • 1 Question
            • 3 Answers
            • 0 Best Answers
            • 20 Points
            View Profile
            EdgardBringas
            2021-07-14T17:53:13+00:00Replied to answer on July 14, 2021 at 5:53 pm

            Como lo enviaría directo a excel, copiar y pegar?

            • 0
            • Reply
            • Share
              Share
              • Share on Facebook
              • Share on Twitter
              • Share on LinkedIn
              • Share on WhatsApp
            • A16

              A16

              • 1 Question
              • 335 Answers
              • 31 Best Answers
              • 901 Points
              View Profile
              Best Answer
              Stephen Byerley
              2021-07-14T18:02:26+00:00Replied to answer on July 14, 2021 at 6:02 pm

              Con el comando para escribir de excel «escribir celda»

              • 1
              • Share
                Share
                • Share on Facebook
                • Share on Twitter
                • Share on LinkedIn
                • Share on WhatsApp
    2. EdgardBringas

      EdgardBringas

      • 1 Question
      • 3 Answers
      • 0 Best Answers
      • 20 Points
      View Profile
      EdgardBringas
      2021-07-14T00:18:33+00:00Added an answer on July 14, 2021 at 12:18 am

      Como puedo leer la tabla que esta en el cuerpo del correo?

      • 0
      • Reply
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
        • Share on WhatsApp

    Leave an answer
    Cancel reply

    You must login to add an answer.


    Forgot Password?

    Sidebar

    Ask A Question

    Stats

    • Questions : 609
    • Answers : 1k
    • Posts : 0
    • Comments : 0
    • Best Answers : 94
    • Users : 1k
    • Popular
    • Comments
    • Tags

    Related Questions

      • On: June 24, 2022
      • Answer: 1

      EXTRAER TABLA DE UN CORREO DE GMAIL

      Quiero extraer la tabla de un correo en gmail, para así guardarlo en un excel cómo puedo realizarlo

    • importar dato desde un excel a sql
      • On: June 15, 2022
      • Answer: 1

      importar dato desde un excel a sql

      Alguien sabe como solucionar este problema?

      • On: June 15, 2022
      • Answer: 1

      Invocar Bot desde un sistema externo

      ¿Es posible una vez implementado un bot, ser llamado desde una aplicación externa, como por ejemplo un Web Api?

      • On: June 15, 2022
      • Answer: 1

      Guardar un archivo

      al querer descargar un documento pdf, este no se realiza ni se guarda de manera automática.  se abre como en los links adjuntos https://prnt.sc/cVBVe9uCcRMF al seleccionar descarga me habilita esto https://prnt.sc/qvignL1vFt18 Cómo podría hacer que esa descarga se haga automática, podré utilizar el screen

      • On: June 10, 2022
      • Answer: 1

      Conectar excel a SQL

      Me podrían ayudar con poder cargar datos hacía un sql desde un archivo excel, ya tengo la tabla creada con el formato del archivo. Luego necesito que se vayan haciendo actualizaciones.

    Users

    DanielOpeRt

    DanielOpeRt

    • 0 Questions
    • 0 Answers
    anastasiant3

    anastasiant3

    • 0 Questions
    • 0 Answers
    Raymond2404Adaxy

    Raymond2404Adaxy

    • 0 Questions
    • 0 Answers

    Explore

    • Home
    • Popular
    • Categories
    • Tags
    • Questions
      • New Questions
      • Most voted
      • Most visited
      • Most Responded

    Footer

    Chile


    Máximo Humbser 577 RM

    +569 9335 8641 jjherrera@rocketbot.cl

    Perú


    Avenida Jose Larco 743 Of. 704, Miraflores Lima

    +51 (01) 447-5333 contacto@rocketbot.pe

    México


    Víctor Hugo 12 Anzures CDMX

    +52 55 5946 3690 antonio.nieto@rocketbot.co

    Colombia


    Diagonal 34 bis #18-44, Teusaquillo - ParkWay Bogotá

    +57 313 8975701 leonardo.garcia@rocketbot.co

    Centro América y el Caribe


    Av. Eugenia 626. Col. Del Valle Centro, Ciudad de México, México

    +1-857-285-0594 www.evaconconsulting.com info.costarica@evaconconsulting.com
    rocketbot white

    Rocketbot SpA | Todos los derechos reservados 2018 - 2020

    © 2020 Discy. All Rights Reserved
    With Love by 2code.

    en_US
    es_ES en_US

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.