Saltar al contenido
Te enseño 7 de los trucos que me permitieron trabajar 2 horas menos al día >>>

MACRO PARA IMPORTAR ARCHIVO PLANO

CHEGAR24

Por CHEGAR24
en Macros y programación VBA

Recommended Posts

CHEGAR24 Novato

CHEGAR24

publicado
publicado

Buena Tarde,

 

le agradezco indicarme si es posible hacer una macro en excel donde yo cargo un archivo .txt o .log y la macro me organice esta información, un achico plano.

POR EJEMPLO.

el archivo a importar, el .txt tiene informacion de la siguiente forma.

 

ST (09857) RNC01PAR                         PROCES       2016-09-19 00:02:34.30
*   ALARM   NONE
    3325    INCONSISTENCY IN CONFIGURATION PARAMETERS
    GOU_QX  OMU-1

HST (09858) RNC01PAR                         PROCES       2016-09-19 00:02:34.00
*   ALARM   WBTS-4708 WCEL-47087
            CUN.Maya-2
    7775    INCONSISTENCY IN WCEL CONFIGURATION PARAMETERS
    REZ_QX  OMU-1                          NMS
    INCONSIS 15491d

HST (09859) RNC01PAR                         PROCES       2016-09-19 00:02:34.00
*   ALARM   WBTS-4708 WCEL-47088
            CUN.Maya-2
    7775    INCONSISTENCY IN WCEL CONFIGURATION PARAMETERS
    REZ_QX  OMU-1                          NMS
    INCONSIS 15491d

HST (09858) RNC01PAR                         PROCES       2016-09-19 00:02:39.00
.   CANCEL  WBTS-4708 WCEL-47087
            CUN.Maya-2
    7775    INCONSISTENCY IN WCEL CONFIGURATION PARAMETERS
    REZ_QX  OMU-1                          NMS
    INCONSIS 15491d

HST (09808) RNC01PAR         1A003-00-17     COMM         2016-09-19 00:02:32.57
.   CANCEL  NPS1P-4
    3974    VP/VC LEVEL AIS RECEIVED
    06DAH   NPS1P-4
    000B 0001 0000 02

HST (09857) RNC01PAR                         PROCES       2016-09-19 00:02:44.42
.   CANCEL  NONE
    3325    INCONSISTENCY IN CONFIGURATION PARAMETERS
    GOU_QX  OMU-1

HST (09859) RNC01PAR                         PROCES       2016-09-19 00:02:44.00
.   CANCEL  WBTS-4708 WCEL-47088
            CUN.Maya-2
    7775    INCONSISTENCY IN WCEL CONFIGURATION PARAMETERS
    REZ_QX  OMU-1                          NMS
    INCONSIS 15491d

 

 

quiero hacer la MACRO, que al cargar este archivo con este tipo de información me la organice y quede de la siguiente manera.

 

S

everity  

Alarm number  Alarm ID  Object  RNW object name              Started               Canceled              Alarm text                                                              Supplementary text                                           Alarm issuer unit  Event type          Probable cause  Canceling info  Info 1.                                                                Info 2.  Alarm issuer    Unit coordinates  Trial side  Recovery info  Indication prevention 
Minor      3821 6915 RNC-1351/NONE                                                               17.09.2016  14:40:02  17.09.2016  14:41:51  PLAN BASED CONFIGURATION OPERATION ONGOING                                                                                           OMU-1              Processing Error    Indeterminate   NOT USED        RNW UPL 0d                                                                      0523H (0x0000)                                               NMS                   
Minor      3821 7029 RNC-1351/NONE                                                               17.09.2016  15:27:55  17.09.2016  15:29:44  PLAN BASED CONFIGURATION OPERATION ONGOING                                                                                           OMU-1              Processing Error    Indeterminate   NOT USED        RNW UPL 0d                                                                      0523H (0x0000)                                               NMS                   
Major      3485 7218 RNC-1351/NONE                                                               17.09.2016  16:54:46  17.09.2016  18:09:49  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-29            Quality of service  Indeterminate   NOT USED        11d 00 732d 1101d 1661d 5642d                                                   0507H (0x0000)                                               NMS                   
Major      3485 7219 RNC-1351/NONE                                                               17.09.2016  16:54:46  17.09.2016  18:09:49  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-29            Quality of service  Indeterminate   NOT USED        11d 00 732d 1101d 1661d 14947d                                                  0507H (0x0000)                                               NMS                   
Major      3485 7220 RNC-1351/NONE                                                               17.09.2016  16:54:46  17.09.2016  18:09:49  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-29            Quality of service  Indeterminate   NOT USED        12d 00 732d 1101d 1661d 5645d                                                   0507H (0x0000)                                               NMS                   
Major      3485 7221 RNC-1351/NONE                                                               17.09.2016  16:54:46  17.09.2016  18:09:49  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-29            Quality of service  Indeterminate   NOT USED        12d 00 732d 1101d 1661d 14948d                                                  0507H (0x0000)                                               NMS                   
Major      3485 7895 RNC-1351/NONE                                                               17.09.2016  23:04:49  18.09.2016  00:09:49  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-4             Quality of service  Indeterminate   NOT USED        11d 00 732d 1101d 1661d 5642d                                                   0507H (0x0000)                                               NMS                   
Major      3485 7896 RNC-1351/NONE                                                               17.09.2016  23:04:49  18.09.2016  00:09:49  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-4             Quality of service  Indeterminate   NOT USED        11d 00 732d 1101d 1661d 14947d                                                  0507H (0x0000)                                               NMS                   
Minor      3821 8068 RNC-1351/NONE                                                               18.09.2016  06:07:11  18.09.2016  06:09:02  PLAN BASED CONFIGURATION OPERATION ONGOING                                                                                           OMU-1              Processing Error    Indeterminate   NOT USED        RNW UPL 0d                                                                      0523H (0x0000)                                               NMS                   
Major      3485 8069 RNC-1351/NONE                                                               18.09.2016  06:09:49  18.09.2016  07:14:49  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-36            Quality of service  Indeterminate   NOT USED        11d 00 732d 1101d 1661d 44774d                                                  0507H (0x0000)                                               NMS                   
Major      3485 8070 RNC-1351/NONE                                                               18.09.2016  06:09:49  18.09.2016  07:14:49  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-36            Quality of service  Indeterminate   NOT USED        11d 00 732d 1101d 1661d 40930d                                                  0507H (0x0000)                                               NMS                   
Minor      3821 8101 RNC-1351/NONE                                                               18.09.2016  07:27:13  18.09.2016  07:29:02  PLAN BASED CONFIGURATION OPERATION ONGOING                                                                                           OMU-1              Processing Error    Indeterminate   NOT USED        RNW UPL 0d                                                                      0523H (0x0000)                                               NMS                   
Minor      3821 8121 RNC-1351/NONE                                                               18.09.2016  08:32:49  18.09.2016  08:33:00  PLAN BASED CONFIGURATION OPERATION ONGOING                                                                                           OMU-1              Processing Error    Indeterminate   NOT USED        RNW DL 79178d                                                                   0523H (0x0000)                                               NMS                   
Minor      3821 8124 RNC-1351/NONE                                                               18.09.2016  08:33:05  18.09.2016  08:33:07  PLAN BASED CONFIGURATION OPERATION ONGOING                                                                                           OMU-1              Processing Error    Indeterminate   NOT USED        RNW ACT 79178d                                                                  0523H (0x0000)                                               NMS                   
Minor      3821 8132 RNC-1351/NONE                                                               18.09.2016  08:40:23  18.09.2016  08:40:33  PLAN BASED CONFIGURATION OPERATION ONGOING                                                                                           OMU-1              Processing Error    Indeterminate   NOT USED        RNW DL 79179d                                                                   0523H (0x0000)                                               NMS                   
Minor      3821 8135 RNC-1351/NONE                                                               18.09.2016  08:40:34  18.09.2016  08:40:42  PLAN BASED CONFIGURATION OPERATION ONGOING                                                                                           OMU-1              Processing Error    Indeterminate   NOT USED        RNW ACT 79179d                                                                  0523H (0x0000)                                               NMS                   
Minor      3821 8147 RNC-1351/NONE                                                               18.09.2016  09:00:22  18.09.2016  09:02:14  PLAN BASED CONFIGURATION OPERATION ONGOING                                                                                           OMU-1              Processing Error    Indeterminate   NOT USED        RNW UPL 0d                                                                      0523H (0x0000)                                               NMS                   
Major      3485 8160 RNC-1351/NONE                                                               18.09.2016  09:19:57  18.09.2016  10:24:57  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-11            Quality of service  Indeterminate   NOT USED        471d 00 732d 1101d 1661d 48482d                                                 0507H (0x0000)                                               NMS                   
Major      3485 8161 RNC-1351/NONE                                                               18.09.2016  09:19:57  18.09.2016  10:24:57  SCRAMBLING CODE CONFLICT                                                                                                             ICSU-11            Quality of service  Indeterminate   NOT USED        471d 00 732d 1101d 1661d 19065d                                                 0507H (0x0000)                                               NMS                   

 

 

le agradezco de ser posible me colaboren.

 

quedo atento a comentarios.

 

gracias

 

javrio Novato

javrio

publicado
publicado

ESTIMADO 

Para ayudar a solucionar a tu problema deberia adjuntar un archivo txt de ejempo y uno de excel como queres salga los resultado.

Saludos muy atte,.

 

  • Silvia bloqueó este tema

Archivado

Este tema está ahora archivado y está cerrado a más respuestas.

Ir al listado de temas
×
×
  • Crear nuevo...

Información importante

Echa un vistazo a nuestra política de cookies para ayudarte a tener una mejor experiencia de navegación. Puedes ajustar aquí la configuración. Pulsa el botón Aceptar, si estás de acuerdo.