Jump to content

Calculation to extract field data


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

Recommended Posts

I am trying to make a calculation to extract specific data from a field to which I copy and paste a list of data items from another source.

For example the copied data would be something like this all pasted into one field

Name: Joe

Age: 45

Sex: M

From this field I would like a calculation "Name" field to extract the appropriate data from the pasted data field and then a separate calculation field to extract "Age" etc.

Hopefully this makes sense.

Let me know if I should clarify.

Thanks

Link to comment
Share on other sites

There are various ways to parse text. For the example you provided I might do something like:

Name =

Substitute( GetValue( yourList ; 1 ) ; "Name: " ; "" )

IOW, take the first line of your list using GetValue, and then replace the label with blank.

Link to comment
Share on other sites

This topic is 6118 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.