Hello,
How can I extract the 2 left-most or 2 right-most characters in a string in TS? I am looking for the equivalent of LEFT() or RIGHT() in Excel. Or is there an equivalent of SUBSTRING? For instance, if the reference is "2023" (in a string format) and I just want to use "23" in a subsequent concatenation, how can I write the equivalent of RIGHT(2023,2)?
similar to CAST (123 as varchar) in SQL or TEXT() in Excel, what is the equivalent function in TS? I am trying to convert 2023 to "2023" for instance.
Thanks!
How can I extract the 2 left-most or 2 right-most characters in a string in TS? I am looking for the equivalent of LEFT() or RIGHT() in Excel. Or is there an equivalent of SUBSTRING? For instance, if the reference is "2023" (in a string format) and I just want to use "23" in a subsequent concatenation, how can I write the equivalent of RIGHT(2023,2)?
similar to CAST (123 as varchar) in SQL or TEXT() in Excel, what is the equivalent function in TS? I am trying to convert 2023 to "2023" for instance.
Thanks!
Last edited by a moderator: