Error in Text-Formatter -> Truncate ?

[Ulf]

When I select "End: True" in Text-Formatter-Truncate it still works from the beginning of the string. Is this correct? I am trying to isolate the file extension at the end of a URL, but it is still returning the first 4 characters...

See attached image

Thank you
Ulf

 

[Neeraj]

When I select "End: True" in Text-Formatter-Truncate it still works from the beginning of the string. Is this correct? I am trying to isolate the file extension at the end of a URL, but it is still returning the first 4 characters...

See attached image

Thank you
Ulf

Just an alternative that you can use to fetch 4 characters from the right using Spreadsheet Formulas.

 

[PabblyMember3]

When I select "End: True" in Text-Formatter-Truncate it still works from the beginning of the string. Is this correct? I am trying to isolate the file extension at the end of a URL, but it is still returning the first 4 characters...

See attached image

Thank you
Ulf

Hello Ulf,

Just to inform you that, truncate string always reads your string from left to right and truncates the given string from the left to the given number of characters, you can pass the number of characters to skip along with the ending ellipsis text. eg: ... (3 dots)

We have updated the help text of the same. Please check the attached image

 

[Ulf]

Hello Ulf,

Just to inform you that, truncate string always reads your string from left to right and truncates the given string from the left to the given number of characters, you can pass the number of characters to skip along with the ending ellipsis text. eg: ... (3 dots)

We have updated the help text of the same. Please check the attached image

Ok, thanks for the clarification! To be picky, there's a typo in the new help text: "ture" should be "true"

 

[Ulf]

Just an alternative that you can use to fetch 4 characters from the right using Spreadsheet Formulas.

View attachment 127

Great, thank you for the rescue!

 

[PabblyMember3]

Ok, thanks for the clarification! To be picky, there's a typo in the new help text: "ture" should be "true"

Thanks, Just corrected the same.