on 10-28-2015 3:50 PM
Below is the formula I am trying to create. It works just fine up to the last elseif statement. What I am trying to do is convert the "Preservation and Access" to JP2 and JPG. Not certain what I am doing wrong. Any suggestions would be greatly appreciated.
=If([Output Type]="Access")Then[Output Type]="JPG"ElseIf([Output Type]="Preservation")Then[Output Type]="JP2"ElseIf([Output Type]="Preservation and Access")Then[Output Type]="JP2"to"JPG"
Thanks,
Roger
Hi, it seems to me that, in your last statement are too many " , instead of using "JP2"to"JPG", try using
"JP2 to JPG"
Regards,
Rogerio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Not very sure what are you trying to achieve.but this is wrong.
Then[Output Type]="JP2"to"JPG"
if you want to change the values from JP2 to JPG then you can use replace function based on certain condition.
Then replace([Output Type];"JP2";"JPG")
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.