Jung Choi Posted August 12, 2021 Share Posted August 12, 2021 Hi all! Just started learning Spotfire and I'm so glad I was able to find this community. I have a column where the values are usually in the following format (3 letters, whitespace, then 3 numbers): ZZZ 123 ZZZ 142 etc However, there are some cases where the value is formatted (3 letters, whitespace, 3 letters + 3 numbers) ZZZ ZZZ123 ZZZ ZZZ142 etc What would be the best way or expression to change the format toZZZ 123 whenever the value is ZZZ ZZZ123 Hope that makes sense. Thank you so much in advance! Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted August 13, 2021 Share Posted August 13, 2021 You could use an expression like: Concatenate(left([value],3)," ",right([value],3)) which should work for both value types Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now