removing extra numbers at the end of a date

[h_lentz]

The date in my column looks like this:  20211105 000000

How can I get rid of the 5 extra 0's at the end?

[Felipe_Ribeir0]

Hi @h_lentz 

You could use this formula LEFT([DateField], 8)

[gabrielvilella]

If you want to get rid of extra zeros you can use this expression on a formula tool:

Trim(TrimRight([FieldName],'0'))

[binuacs]

@h_lentz One way of doing this

[KrishnaChithrathil]

@h_lentz 

[Felipe_Ribeir0]

Hi @h_lentz 

It worked?

[ShankerV]

Hi @h_lentz 

One way of doing this!!!!

Input: 

Step 2: Regex

Many thanks

Shanker V

[DenisZ]

Please find attached solution