Jump to content

Parsing text - how ?


This topic is 6465 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I’m able to go (not even) half way and need some help with this one.

I need to parse out text out of 1 text field and put the data in several fields.

The basic text looks like this:

‘Variable length of text' - Definition 1

Meaning: Variable length of text

Example:

Variable length of text.

Notes:

- Variable length of text

- Variable length of text

'Variable length of text' - Definition 2

Meaning: Variable length of text

Example:

Variable length of text.

Notes:

- Variable length of text

- Variable length of text

Where there will be always at least 1 definition, sometimes 2, sometimes 3.....

Final goal is to have definition 1,2,3, meaning, example, notes 1, notes 2 in separate fields.

If possible with a script or if separate calculations are easier…..

TIA

Link to comment
Share on other sites

and:

Notes:

- Variable length of text <-- this is notes 1 ?

- Variable length of text <-- this is notes 2 ?

If so you can use the GetValue( ) function into a recursive custom function.

For example, for notes 1:

GetValue ( TextToParse ; 6 )

for notes 2:

GetValue ( TextToParse ; 7 )

Then repeat the work ( into the custom function ) with NextTextToParse = RightValues ( TextToParse ; ValueCount ( TextToParse ) - 7 )

Link to comment
Share on other sites

A live sample:

'Answer for' - Definition 1

Meaning: Be held responsible for a problem

Example:

The administration should be made to ANSWER FOR their failure to sort out the problem.

Notes:

- Inseparable

- International

'Answer for' - Definition 2

Meaning: Speak on behalf of someone or from knowing them

Example:

I can ANSWER FOR my partner because I know his idea on this issue.

Notes:

- Inseparable

- International

And I'm afraid Custom Functions are currently a little bit to high for me yet.

I just start with FileMaker and still have to find my way into the regular functions.

So, 'Answer for' needs to come in field Definition 1,

Be held responsible for a problem, in field Meaning

The administration should be made to ANSWER FOR their failure to sort out the problem. in field Example

- Inseparable , in field Note 1

- International, in field Type

Edited by Guest
Link to comment
Share on other sites

Well, yes.

I didn't come up with aonther design.

Or I have to make a sort of duplicate records if is are more than one definition.

After all, that possibilty is real....

For now I have 1600 entries in the database (import from ols Lotus 123 file), and I have no idea how to tackle a +3 definition.

My first concern was/is to populate my fields first, to be able to make search and reports.

Maybe later, in a new and better design, I will be able to just import the 'separated' data.

Like it is now it is not workable.

Link to comment
Share on other sites

This topic is 6465 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.