Trim Function

[jonick1205]

Anyone can help to solved this problem i need only the first 4 digit to show on my report. for example 202012354866 i need to show 2020 only

[KarolinaRoza · Accepted solution]

hi,

Please try with Formula tool with formula:

left(tostring([Field1]),4)

Regards,

Karolina

[Maskell_Rascal · Accepted solution]

Hi @jonick1205 

So there are numerous ways to get to this data, but they all require you to first convert the field in question to a string. Below are three different examples. 

If you have data in the field prior to your numbers, then we'd need to modify the regex solution to make it work. 

If this solves the problem please mark answer as correct, if not let me know!

Cheers!

Phil

[KarolinaRoza · Accepted solution]

Hi,

I was to fast with reply 🙂 in case you will have other characters in your input then Regex will be useful:

Karolina

[MichaelSu · Accepted solution]

See attached. All of the solutions posted should work as well. It's mostly a matter of preference.

Thanks,

Mike