LiveCode Forums.

Thank you very much jacque and Thierry. You have both given me much to work with and made me realise how much I have to learn (again) about Livecode.

Much appreciated.

Darryl

So I have finished my little project.

To recap, I wanted to be able to read in a text file that I receive every day from a bank of transactions paid into our account and extract the relevant information, then copy it to the clipboard so it could be pasted into a spreadsheet.

The text file isn't ...

Hi dazza101,
Sorry, was thinking you were just looking for the line with the relevant info. Try pasting and using code formatting (button at the top).
other;
on mouseUp
put fld 1 into temp
put lineoffset("ACCOUNT AMOUNT CUSTOMER NAME TRACE TXN-DATE",temp) into tLine
put line (tLine + 1) of fld ...

Hi dazza101,
Welcome to the forum!

What about using lineoffset +1?

Simon

Thanks Simon, but I'm not following your suggestion. lineoffset returns the line number on which the specified search text is found. Correct? Are you suggesting using lineoffset with a regex for spaces, numeric chars ...

I have dabbled with LiveCode many years ago, but have only just started to work with it again. I am trying to write a simple program to parse some text from a text file.

The file isn't delimited and looks like this:


GENERAL 1 BANK PAGE 1
TRACING REPORT BY VENDOR RUN DATE 07/03/15
RUN TIME 00 ...