parsing complex text file

anna · Apr-10-2019, 07:35 AM

Hi All,

I have huge text file(sample is given below), I have not tried yet as not able find the way, suggestion required. How to proceed and which library will help.

Logic:

This is TX path between two nodes

1) Path name
2) Route Type (Main or Spare)
3) Node and port (KLM is blank) this is starting node
Node A->RJ62_MSC2-VKI_10/r01s1b13p01 A-END-KLM-> (blanck) ->Node Z-> RJ62_MSC2-VKI_10/r01s1b13p01 Z-END-KLM->01/3/2.2
Node A->RJ60_MSC2-VKI_05/r01s1b32p001 A-END-KLM-> 01/3/2.2 ->Node Z-> RJ60_MSC2-VKI_05/r01s1b26p001 05/3/4.1

================================================================================
PATH INT/BTS-C/TTL/233/2MB/BWD/JAI/RJ/G.703/G.703/20-NOV-08=233 BTS Phoolbag-BhiwadiIndusArea 1st E1--T
================================================================================

***** MAIN ROUTE *******

RJ62_MSC2-VKI_10/r01s1b03p14c01
RJ62_MSC2-VKI_10/r01s1b13p01 01/3/2.2
RJ60_MSC2-VKI_05/r01s1b32p001 01/3/2.2
RJ60_MSC2-VKI_05/r01s1b26p001 05/3/4.1
RJ60_ALWAR-BAS-02/r01s1b24p001 05/3/4.1
RJ60_ALWAR-BAS-02/r01s1b27p001 04/2/7.2
RJ60_KSN-BAS_02/r01s1b30p001 04/2/7.2
RJ60_KSN-BAS_02/r01s1b39p001 02/3/6.1
RJ60_REWARI_01/r01s1b39p001 02/3/6.1
RJ60_REWARI_01/r01s1b27p001 03/1/5.3
RJ60_BHIWADI_01/r01s1b35p001 03/1/5.3
RJ60_BHIWADI_01/r01s1b01p005c1

***** SPARE ROUTE *******

RJ60_MSC2-VKI_05/r01s1b32p001 01/3/2.2
RJ60_MSC2-VKI_05/r01s1b37p001 08/2/6.2
RJ60_MSC2-VKI_11/r01s1b28p001 08/2/6.2
RJ60_MSC2-VKI_11/r01s1b37p001 41/1/4.1 NEEMRANA--VKI-RAFFEL
RJ60_NEEMRANA_02/r01s1b28p001 45/1/4.1 NEEMRANA--VKI-RAFFEL
RJ60_NEEMRANA_02/r01s1b25p001 06/2/6.2
RJ60_SHAHJANPUR_02/r01s1b28p001 06/2/6.2
RJ60_SHAHJANPUR_02/r01s1b27p001 02/1/1.1
RJ60_DHARUHERA_01/r01s1b36p001 02/1/1.1
RJ60_DHARUHERA_01/r01s1b24p001 14/3/2.2
RJ60_BHIWADI_01/r01s1b26p001 14/3/2.2
RJ60_BHIWADI_01/r01s1b01p005c1

================================================================================
TRAIL NEEMRANA--VKI-RAFFEL
================================================================================

***** MAIN ROUTE *******

RJ60_NEEMRANA_02/r01s1b28p001 45
RJ60_KOTPUTLI_02/r01s1b25p001 45
RJ60_KOTPUTLI_02/r01s1b34p001 55
RJ60_CHANDWAJI_01/r01s1b34p001 55
RJ60_CHANDWAJI_01/r01s1b25p001 62
RJ60_VSN-JAI_09/r01s1b37p001 62
RJ60_VSN-JAI_09/r01s1b34p001 41
RJ60_MSC2-VKI_11/r01s1b37p001 41

Quote:XXXXXXXXXXXXXXXXXXXXXXXXXXXX expected Output XXXXXXXXXXXXXXXXXXXXXXXx

Path route A-END KLM Z-END KLM
INT/BTS-C/TTL/233/2MB MAIN ROUTE RJ62_MSC2-VKI_10/r01s1b03p14c01
INT/BTS-C/TTL/233/2MB MAIN ROUTE RJ62_MSC2-VKI_10/r01s1b13p01 01/3/2.2 RJ60_MSC2-VKI_05/r01s1b32p001 01/3/2.2
INT/BTS-C/TTL/233/2MB MAIN ROUTE RJ60_ALWAR-BAS-02/r01s1b24p001 05/3/4.1 RJ60_ALWAR-BAS-02/r01s1b27p001 04/2/7.2
INT/BTS-C/TTL/233/2MB MAIN ROUTE RJ60_KSN-BAS_02/r01s1b30p001 04/2/7.2 RJ60_KSN-BAS_02/r01s1b39p001 02/3/6.1
INT/BTS-C/TTL/233/2MB MAIN ROUTE RJ60_REWARI_01/r01s1b39p001 02/3/6.1 RJ60_REWARI_01/r01s1b27p001 03/1/5.3
INT/BTS-C/TTL/233/2MB MAIN ROUTE RJ60_BHIWADI_01/r01s1b35p001 03/1/5.3
INT/BTS-C/TTL/233/2MB MAIN ROUTE RJ60_BHIWADI_01/r01s1b01p005c1
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_MSC2-VKI_05/r01s1b32p001 01/3/2.2
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_MSC2-VKI_05/r01s1b37p001 08/2/6.2 RJ60_MSC2-VKI_11/r01s1b28p001 08/2/6.2
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_MSC2-VKI_11/r01s1b37p001 41/1/4.1 NEEMRANA--VKI-RAFFEL
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_VSN-JAI_09/r01s1b34p001 41 RJ60_VSN-JAI_09/r01s1b37p001 62
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_CHANDWAJI_01/r01s1b25p001 62 RJ60_CHANDWAJI_01/r01s1b34p001 55
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_KOTPUTLI_02/r01s1b34p001 55 RJ60_KOTPUTLI_02/r01s1b25p001 45
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_NEEMRANA_02/r01s1b28p001 45/1/4.1 NEEMRANA--VKI-RAFFEL
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_NEEMRANA_02/r01s1b25p001 06/2/6.2 RJ60_SHAHJANPUR_02/r01s1b28p001 06/2/6.2
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_SHAHJANPUR_02/r01s1b27p001 02/1/1.1 RJ60_DHARUHERA_01/r01s1b36p001 02/1/1.1
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_DHARUHERA_01/r01s1b24p001 14/3/2.2 RJ60_BHIWADI_01/r01s1b26p001 14/3/2.2
INT/BTS-C/TTL/233/2MB SPARE ROUTE RJ60_BHIWADI_01/r01s1b01p005c1

**Larz60+** · Apr-10-2019, 09:54 PM

How to proceed and which library will help.
proceed where? you haven't stated what your goal is.

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Text parsing	Arik	5	407	Mar-11-2024, 03:30 PM Last Post: Gribouillis
	doing data treatment on a file import-parsing a variable	EmBeck87	15	2,894	Apr-17-2023, 06:54 PM Last Post: EmBeck87
	Need to compare the Excel file name with a directory text file.	veeran1991	1	1,128	Dec-15-2022, 04:32 PM Last Post: Larz60+
	Modify values in XML file by data from text file (without parsing)	Paqqno	2	1,680	Apr-13-2022, 06:02 AM Last Post: Paqqno
	Parsing xml file deletes whitespaces. How to avoid it?	Paqqno	0	1,043	Apr-01-2022, 10:20 PM Last Post: Paqqno
	Converted Pipe Delimited text file to CSV file	atomxkai	4	6,999	Feb-11-2022, 12:38 AM Last Post: atomxkai
	Parsing a syslog file	ebolisa	11	4,147	Oct-10-2021, 05:15 PM Last Post: snippsat
	Parsing a YAML file without changing the string content..?, Flask - solved.	SpongeB0B	2	2,280	Aug-05-2021, 08:02 AM Last Post: SpongeB0B
	[split] How to convert the CSV text file into a txt file	Pinto94	5	3,362	Dec-23-2020, 08:04 AM Last Post: ndc85430
	Saving text file with a click: valueerror i/o operation on closed file	vizier87	5	4,408	Nov-16-2020, 07:56 AM Last Post: Gribouillis

parsing complex text file

User Panel Messages

Announcements