I have new beginner in FileMaker. Can anyone help? I want to split some data ,
Can i make a specify Calculations to do this ? if can , How to do it?
may be fieldA - 6 , FieldB- 2....
If the data has a constant format as shown and you want to move the comma separated values to their own fields you can do this by script. I suppose it could also be done by using a number of calculated fields.
FieldA = GetValue( Substitute(OriginalField; ", "; "¶"); 1)
FieldB = GetValue( Substitute(OriginalField; ", "; "¶"); 2)
Script would do essentially the same thing, but without the use of so many calc fields. You could also better handle the use of the last value in a script.
If the number preceding the "/" needs to be used the same way you will need to substitute the "/" with a "¶" as well.
Thank you your information. It's work and Split what i want !
Very Very Thanks
Retrieving data ...