Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ayden Smith   on Feb 20 In MS Office Category.

  
Question Answered By: Este Ferrrari   on Feb 20

The extraction can be made as simple  or as complicated as you wish. That is not
the problem.

The problem appears to be one of defining rules which will RELIABLY find the
account number  in the extracts.

If you can define the rules, they can be coded.

It's unusual for an accounting application to export information in such an
unstructured form. In particular, I would be extremely surprised if the export
can't be redefined so as to put the account numbers into a field of their own.
After all, they will be being held separately inside the accounting application.

I would recommend going back to the people doing the extract, and get them to
structure it more appropriately.

Share: 

 

This Question has 20 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on trouble with IF/OR, Left and a simple loop Or get search suggestion and latest updates.


Tagged: