TRIM Spaces from Text as a Command or Express...

[Colin1]

TRIM Spaces from Text as a Command or Expression?

Is there some sort of command or expression that can trim text from either end of a text string, please?

I assumed there was one, but upon searching, oddly I cannot find one or it does not exist.

OPAT

[Aleksi_Alkio]

Would you please give us a sample what you are looking for, thanks.

[Colin1]

@Aleksi_Alkio For example:

"

The quick brown fox jumps over the lazy dog.

"

becomes

“The quick brown fox jumps over the lazy dog.”

[Aleksi_Alkio]

Is the start and end “string” always the same like four spaces?

[Colin1]

@Aleksi_Alkio No, it could be many or a few.

[Aleksi_Alkio]

Are these values coming from a different service?

[Colin1]

I am something that behaves like these functions ideally:

docs.microsoft.com - LTrim, RTrim, and Trim functions | Microsoft Docs

and this:

https://www.tutorialspoint.com/java/java_string_trim.htm LTrim, RTrim, and Trim functions | Microsoft Docs docs.microsoft.com

[pravse]

We should have a Trim function! Will get it in next week.

[pravse]

Actually, it will be on Monday! :]

[Colin1]

@praveen Wow! A new Function in just 7 minutes! It must be an Appsheet record! Thanks!

Hopefully, it might address a minor cosmetic anomaly I encountered yesterday.

[Aleksi_Alkio]

Okay… I gave up. You can of course create that filter with existing expressions, but it would be quite complex. Praveen’s solution is much quicker

[LohithS]

You can trim spaces from a text using trim() method of String class.

public class StringTrimJava
{
   public static void main(String[] args)
   {
      String str = "     welcome to helloworld java!        ";
      System.out.println(str);
      System.out.println(str.trim());
   }
}

Output:
welcome to helloworld java!