formating of text file

  • Thread starter Radhakant Panigrahi
  • Start date
R

Radhakant Panigrahi

i have problem while formating a text file into excel containing the below
matter

i want the "Bank reference", "Amount", "Information", "Customer details "
and "bank clearing ID" in first row and the corresponding information below
the corresponding headings.

i have tried the use the custom in the filters and take the details into a
next tab. everything is working, however only one line from the "information"
and "customer details" is picking. Second line and the line after one blank
line is also not picking.

it would be great if some body could find the solution as to how i can take
the full information from "information" and "customer details" .

Bank reference 99912000
Amount 123.54
Information bjasdbvlaksdjbvfsdbvsdfvnbnjnvjksdf 70000151651 bvasdbh
70054685485wfasdf

awehieuavfhwe 7000045454

Customer details bnjksdnvsldjkavn 1545 adbnajkfbvad 1588 asvsdvsdv
bbslvjhbsd 5555

bank clearing ID 4545454545862121

Bank reference 99912000
Amount 123.54
Information bjasdbvlaksdjbvfsdbvsdfvnbnjnvjksdf 70000151651 bvasdbh
70054685485wfasdf

awehieuavfhwe 7000045454

Customer details bnjksdnvsldjkavn 1545 adbnajkfbvad 1588 asvsdvsdv
bbslvjhbsd 5555

bank clearing ID 4545454545862121

rgds,
rkp
 
P

PY & Associates

i have problem while formating a text file into excel containing the below
matter

i want the "Bank reference", "Amount", "Information", "Customer details "
and "bank clearing ID" in first row and the corresponding information below
the corresponding headings.

i have tried the use the custom in the filters and take the details into a
next tab. everything is working, however only one line from the "information"
and "customer details" is picking. Second line and the line after one blank
line is also not picking.

it would be great if some body could find the solution as to how i can take
the full information from "information" and "customer details" .

Bank reference  99912000
Amount   123.54
Information   bjasdbvlaksdjbvfsdbvsdfvnbnjnvjksdf 70000151651 bvasdbh
70054685485wfasdf

awehieuavfhwe 7000045454

Customer details bnjksdnvsldjkavn 1545 adbnajkfbvad 1588 asvsdvsdv
bbslvjhbsd 5555

bank clearing ID             4545454545862121

Bank reference  99912000
Amount   123.54
Information   bjasdbvlaksdjbvfsdbvsdfvnbnjnvjksdf 70000151651 bvasdbh
70054685485wfasdf

awehieuavfhwe 7000045454

Customer details bnjksdnvsldjkavn 1545 adbnajkfbvad 1588 asvsdvsdv
bbslvjhbsd 5555

bank clearing ID             4545454545862121

rgds,
rkp

Not sure what you mean by "picking"

read the file into Excel
data is all in column A
perform texttocolumn, delimited by space
pull data to relevant positions

alternatively, read the file in sequentially
look for keywords for action;
keywords are your column headings.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top