Text Parsing Question

[JTSmith]

Laretta was kind enought to show me how to pull data from one field "pastestring" into different fields. My question is, I have to different fields and will only use one of the fields per record.

My calculation for the name field is:

Trim ( GetValue ( Substitute ( GetValue ( pasteString ; 1 ) ; ":" ; ¶ ) ; 2 ) )

I want to say something like: Pull the name from line 1: on pasteString OR Pull the name from line 1: on pasteStringTwo.

I basically have 2 different contact forms, and I just need to figure out how to put an OR statement in there...

Any help would be appreciated!

[Aussie John]

You need to have a test to determine which string you would like to pull from and then use a case function.

case(yourtest,string1,string2)

ie if test is true use string1 if not use string 2

that is if I understand you correctly

[JTSmith]

Thanks, sometimes the simple ones slip by :-)