Python Forum
I need to get only string datatype and report in excel file.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
I need to get only string datatype and report in excel file.
#1
Hello,
I have a python script which uses a source text file as an input.

The text file contains the data of string, numeric, boolean and action data types format.

I need to strip of the numeric, boolean and action data and parse only string data type and log in the csv.

My text file contains the following script:

<S t='a' s='3'/>SetRTEConfig,Done,,<S t='a' s='3'/>LogTestertName,Passed,,<S t='n' c='GT' s='7'/>{PowerUpBed}VerifyBedCurrentDraw,0.271440,Passed,0.080000,,Amps RMS,,<S t='s' c='IgnoreCase' s='5'/>{LogTestertName}LogTesterName,"TS-0418A",Passed,"TS-0418A",,

where t=a is the action data type which i want to strip off and parse only <S t='s' the last one which is string.
and log to csv

How can i do it

Any help is appreciated,

Thank you
Reply


Messages In This Thread
I need to get only string datatype and report in excel file. - by akshay3210 - Dec-12-2019, 05:51 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Need help with Allure report Nik1811 0 247 Apr-22-2024, 09:59 AM
Last Post: Nik1811
  Python openyxl not updating Excel file MrBean12 1 451 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  Unable to download TLS Report attachment blason16 6 673 Feb-26-2024, 07:36 AM
Last Post: Pedroski55
  Copy Paste excel files based on the first letters of the file name Viento 2 559 Feb-07-2024, 12:24 PM
Last Post: Viento
  Search Excel File with a list of values huzzug 4 1,375 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 975 Nov-03-2023, 05:13 PM
Last Post: noisefloor
  trouble reading string/module from excel as a list popular_dog 0 482 Oct-04-2023, 01:07 PM
Last Post: popular_dog
  Need to replace a string with a file (HTML file) tester_V 1 853 Aug-30-2023, 03:42 AM
Last Post: Larz60+
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,215 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Save and Close Excel File avd88 0 3,346 Feb-20-2023, 07:19 PM
Last Post: avd88

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020