Cut a String field

[Massi1]

Hey 

I Have a field where Identifiers are like B.520003 and sometimes I have this format K.05858. 

now I must cut the point. 

Everywhere who a point is, that must be cut it. 

Any solutions? 

[bhrmitra]

Hi Massi1,

Did you mean to remove the "dot". If so please find the attached solution.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

[Massi1]

HEy, 

Thanks at first. 

Yes I mean the "dot" but only the "dot" at the End.  I have maybe 8k records. And sometimes I have 8 chars and sometimes 7. And by the 7chars there is a dot like in the sample "K.05858."

I only need to remove the dot and the end. 

[Ben_H · Accepted solution]

Hi @Massi1,

In that case you can use the TRIM function.

By default the TRIM function removes leading and trailing whitespace i.e. TRIM([your field])

You can get it to remove specific characters from the start and end of a field also like so - TRIM([your field],".")

Regards,

Ben

[bhrmitra · Accepted solution]

Hi  Massi1

This should remove only the last "dot".

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra