Jump to content
We've recently updated our Privacy Statement, available here. ×

convert excel function to spotfire


Ryan K.

Recommended Posts

I have this function in excel:

=IFERROR(RIGHT(A2,LEN(A2)-FIND("$",SUBSTITUTE(A2,"-","$",LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))))),A2)

It is looking into a column whose sample value is "First Name, Last Name C UYXS-MND/U/MN" and the result looks like this "MND/U/MN"

It basically extracts everything after the dash "-".

Can you please help me with what funtion should I use in a calculated column

Link to comment
Share on other sites

Hi Ryan,

If your column values really only ever have one '-' then this function will work. There are other more complicated solutions available if your values are less consistent (I.e. more than one '-' or other characters).

Split([ColumnA], '-', 2)This will return just the right-hand side after the split character '-'. If you still want to copy the Excel formula and return the entire value if no '-' is found then use this:

If(Split([ColumnA],"-",2) is null,[ColumnA],Split([ColumnA],"-",2))Regards,

Jason

Link to comment
Share on other sites

  • 10 months later...

Hi Team,

I have been trying to get this expression working.I have been struggling with the conversion syntax in Spotfire, trying to compare a string with an integer.

Please help

Case

When Len([ComsumerID] = 5 ) then "Individual"

ELSE "Other"

End

 

Excel function and it worked

=IF(LEN(I2)=5,"Individual","Other")

Link to comment
Share on other sites

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...