How to remove blank characters at the beginning of a string

[Former Member]

Hello,

If there are blank characters (one or more) start at the beginning of a string how we can remove them.

Thanks for any help.

-Jean

[abhilash_kumar · Accepted solution]

Hi Jean,

Try:

Ltrim({database field})

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

Works great. Thanks for you help.

-Jean

[DellSC]

Create and use a formula that looks like this:

LTrim({MyTable.MyField}

If you're just joining tables in your report, not using a command, universe, or stored proc for the data, you could use a SQL Expression instead.  This would be in the syntax of your database. So, for example, if you're connecting to SQL Server it would be this:

LTRIM("MyTable"."MyField")

If you're using Oracle, it would be this:

TRIM(LEADING ' ' FROM "MyTable.MyField")

-Dell

[Former Member]

Thanks Dell for your help.