Jump to content

separate data from string

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

Recommended Posts

First, if the data is concatenated, from another file, then it originally existed separately. The fact that is a global leads one to think that this is a temporary value. So why can't you use the process which set this global to the separate values to also set them as separate values, in other globals?

In other words, rather than trying to pull the data apart, why not also pass the separate values?

If that is not possible, then you are either going to have to figure out what (if anything) allows you to distinguish the separate values when concatenated; or else you're going to have to compare each part of it back to the original values somewhere, to see where to break them.

Link to comment
Share on other sites

You say that the concatenated field has different types of data. It can't. Once it's in one field, it's only 1 type, Text result probably. What is was before doesn't really matter at that point; though it may matter again after you parse it.

Are you saying that TextToDate produces an incorrect date, from what looks exactly like a regular date (on your system)?

I still don't see why all this struggle, why you can't get the values from the original separate fields.

Why don't you post some sample data, along with your calculations (well-labelled). We can't tell otherwise what's going on.

Link to comment
Share on other sites

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