detach a txt file from a note & copy text into spreadsheet

Posted on 2006-04-26
Last Modified: 2013-12-18
Please can you help!
Also, Please don't provide a big chunk of lotusscript code as i dont understand it.
If possible I would like to do this using @commands/functions.

I am wishing to create an agent to transfer data in a txt file and
automatically place it into a spreadsheet (excel or lotus 123 it doesnt

I have an excel file already with just the column headers and
formatting so excel would be better.

I have mail sent to me on a regular basis during the day. Each note
contains a text file such as below: -

NAME=John Smith
JOB REF=frtf78
REASON=Under Instruction
COMMENTS=Customer problem

I want the agent to do the following: -

1. When 'new mail' arrives in folder "FOLDER_A" run agent
2. Open the attached txt file and copy each line after the '=' sign
into the spreadsheet.

I would like to do this using simple actions or commands as my
Lotusscript is not very good !!

Any help anyone could pass on would be really useful to me.


Question by:gray180
    LVL 46

    Expert Comment

    by:Sjef Bosman
    Is this the same question as your previous one? Madheeswar is right, it can't be done using Formula language. I understand that you want something simple, but what you're asking is far from simple.

    Author Comment

    Yes Sjef it is the same question.

    It looks like I will be printing the file off and going through it on the way home tonight.

    I will need to understand the code to be able to manipulate it a bit so any advice on that thread to point out the main parts of the code would be really useful.

    If I can understand the code and how it works then I can use it

    Thanks for your help.

    LVL 46

    Expert Comment

    by:Sjef Bosman
    You might ask Madheeswar some clarification here and there, he sometimes just whacks code in, without "documentation".

    If you don't need this here question, you might ask for it to be deleted. To do that, put a question in Community Support with a link to this one.
    LVL 46

    Expert Comment

    by:Sjef Bosman
    Anyway, I suggested NOT to produce the text-file, but to put the information in a simple mail. In that way, you don't have the form to send, you can use then standard Memo-form and put the info you want to send in the Body field.

    Author Comment

    Cheers Sjef,
    I have taken the form from the mail being sent, and assigned the the field that holds the data to the body field of the note.

    This works excellently - thankyou.
    LVL 46

    Assisted Solution

    by:Sjef Bosman
    Great! Now for the receiving end: how to get the data out. Will that be handled in your other question?

    My suggestion here:
    - get the body field
    - get the text (may have to be done differently for Text and RichText fields)
    - use Split(text, newline) to chop up the text into an array of lines
    - handle line by line

    Author Comment

    Good stuff Sjef,

    Madheeswar has showed me the way on this and it works excellently.

    I just need to select the documents in the view now and hit the button and its all there.

    Thanks very very much for all of your help and guidance.
    Actually learnt a lot from the comments and the code so thanks.

    LVL 19

    Accepted Solution

    So... I would be getting my share of points here also right?

    Should not be a problem for you ????


    Author Comment

    Just for the cheek of it Madheeswar I will be glad to give you some more points here too!!!!    :)

    Since you got most of them for your very descriptive answer previously I have given you an extra 150 here.

    My project first started with Sjef answering many many questions for me hence 350 extra for him too.

    I have just seen that I have given the accepted answer less points than the assist !!!!


    But thankyou both very much for your patience and informative replies.

    It really is appreciated - Cheers !!!
    LVL 46

    Expert Comment

    by:Sjef Bosman
    Story of my life... :(


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
    IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now