philipcaplan Posted August 7, 2020 Share Posted August 7, 2020 I have the following Calculation field called "extract_card_type" in a FMPro16 database: Let ( [ lineStart = Position ( PASTED_INPUT_to_use ; "¶Card Type: " ; 1 ; 1 ) ; lineEnd = Position ( PASTED_INPUT_to_use ; ¶ ; lineStart + 1 ; 1 ) ; start = lineEnd + 1 ; end = Position ( PASTED_INPUT_to_use ; "¶Organisation name: " ; start ; 1 ) ] ; Middle ( PASTED_INPUT_to_use ; start ; end - start ) ) and the text field 'PASTED_INPUT_to_use' is the following: incoming order Card Type: ORG WITH BORDER Organisation name: org-name Organisation type: org-type I expected the field "extract_card_type" to contain the value "ORG WITH BORDER" but it is empty!! Could somebody please tell me how to fix it so it does. Thanks in anticipation. Link to comment Share on other sites More sharing options...
This topic is 1024 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
Already have an account? Sign in here.Sign In Now