How to remove decimal in Data Field

[griffin2571]

I Have this in the data load editor for the parts order field. Left([Parts Order],Len([Parts Order])-1)&'.'&Right([Parts Order],1) As "Parts_Dec".

It obtained the result I wanted with data that had suffix "Parts +". However I have some data that do not meet that criteria. What would be the best way to keep the decimals in place for Parts order that start with "Parts +" but remove decimals that have all numbers.

Example - 2022307160.1 converts to  20223071601

PARTS +840.0 stays the same

[BrunPierre]

Perhaps

If(SubStringCount([Parts Order],'PARTS +')=0,Replace(Field,'.',''),[Parts Order])

[MarcoWedel · Accepted solution]

I guess it's better to not insert the unnecessary decimal points in the first place, instead of deleting them afterwards:

If([Parts Order] like 'PARTS +*',Left([Parts Order],Len([Parts Order])-1)&'.'&Right([Parts Order],1),[Parts Order]) as Parts_Dec