Extract and paste different data from a single field

[comment]

There is no such function. You would need to go over the text, word by word, and test if =

IsEmpty ( Filter ( Left ( word ; 1 ) ; "0123456789" ) )

to find out if it starts with a digit or not. That's why you need either a looping script or a recursive custom function.

As for finding "street", it's very easy to find it as a string using PatternCount() or Position(). It's not so easy to find it as a word.

[adriroxx]

Hi, I'm back again.

Thanks to precious Comment hints, I'm "quite successfully" going on.

Here is the new problem in my way.

At the moment, I have a file named ADDRESSFROMPEOPLE wich I'm trying to correct using official data from another file named ADDRESSFROMMAILSYS.

In order to fix the not perfect values in the STREETNAME field of file ADDRESSFROMPEOPLE, I think to copy (and/or store in a variable or somewhere else temporarily) STREETNAME + CITYNAME and then make a FIND with those two values in the other file ADDRESSFROMMAILSYS.

In this way I should find the rekord of that specific street in the ADDRESSFROMMAILSYS file with all its official values.

At this point, I think to copy and paste all the data I need from fields of ADDRESSFROMMAILSYS back to corresponding fields in ADDRESSFROMPEOPLE, and the job is supposed to be done. (in a horrific way, but it is a minor issue)

Well, i simply do not know how to make a FIND in file B with find criteria picked up from file A.

Variables can be used to store and retrieve values only if in the same file, isnt'it?

By the way, a "portal strategy" to show data from file B in a portal placed in file A and then move data inside the same file, does not seem to work in this situation because the value people wrote in STREETNAME is too far from what it should be (they write G. WASHINGTON or G WASHINGTON or WASHINGTON but they never write GEORGE WASHINGTON), and I can not trigger the relation.

Any idea or trick? Thanks

(30 minutes later: I found another post from Comment in "Find record in another table based on calculation and selections made on primary table - Started by Garreth2010, Sep 03 2011 01:25 PM" wich seems to be suitable, but I dont know if I can handle it all by myself...)