Python Forum

Full Version: How do i read particular text from text file and update those values in MS SQL table
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2 3 4
Line that is processed is specified in this row
line = my_file.split('\n')[6]
That is line 7 from the text file (index is 0-based).
That said you should really start doing your work and not asking us to do/explain every single step of it. the code I provided is more or less self explanatory.
I merged your other thread into this one and it's original post disappeared. I hope there was no important info that is missing now?
Thanks for your information.

The code is perfectly working except specific text in different line.
if i get that specific portion code, my problem solved and i will close the issue.
like that, i have many requirements which i will do it myself further.

Note : merging other thread is entirely different.
OK, I show you how to read specific line, do the same (with some changes) with the other line you want
I split again the other thread - https://python-forum.io/Thread-split-How...-documents
not clear..
(Nov-16-2018, 07:26 AM)ganeshsai2912 Wrote: [ -> ]not clear..
what is not clear? I showed how to access line by index. I showed how to parse a line (of course other approaches are possible too). I just have to do it for another line.
If it's not up to you skills, then maybe you should not take work for clients that you cannot deliver
can you give me clue..?..how to access line by index
(Nov-16-2018, 05:34 AM)buran Wrote: [ -> ]Line that is processed is specified in this row
line = my_file.split('\n')[6]
That is line 7 from the text file (index is 0-based).
That said you should really start doing your work and not asking us to do/explain every single step of it. the code I provided is more or less self explanatory.
I writing python program which read specific text from text file.

The program is working fine if it is static line index.

if it is dynamic search in the whole document, i am unable to read..

particularly, i want to get "Join Date","Relieve Date",etc. along with 3 main parameter(EmpNo,Name,Salary).

How to change the below code..?

import glob


def parse_line(line):
    for item in ['Emp No', 'Name', 'SAL', 'Join Date']:
        line = line.replace(item, '')
    return [item.strip() for item in line.split(':') if item.strip()]
 
def process_file(file_name):
    with open(file_name) as f: 
        line = f.readlines()[6]
    print(line)
    return parse_line(line)

pattern = 'C:/Test/Python/Project/*.txt'   
files = glob.glob(pattern)
all_data = [process_file(file_name) for file_name in files]
sample text file attached in the below link.

final out put would be

EmpNo: 101 Name: RASUL L SAL: 30000 JoinDate :XXXXX

Sample file attached.

Sample file attached
Please, don't start new threads. Keep the discussion in this thread.
It's really frustrating when people don't want to put any effort and expect others to do their work.
I showed several times how to access line by index. The EmpNo, Name, and SAL are on line 7 (i.e. index = 6).
Join date is on line 9, i.e. index=8.
I also showed you how to parse the line and get separate elements.
Just amend the code to do the same for line 9
I tried some code's. but, no luck and i am struggling.

I have no idea how to proceed further..?

Note : Mention index which we need to hard code or loop it...?
Pages: 1 2 3 4