I assume this is simple...

[JTSmith]

I have data which has the problem where it's duplicated text in the fields

 

Example:

Bob SmithBob Smith
David JonesDavid Jones
Henry MorrisHenry Morris

 

I just want to delete the duplicate in the field so it just shows Bob Smith, not Bob SmithBob Smith.

Any help would be greatly appreciated!

Edited June 5, 2017 by JTSmith

[siroos12]

if that is a text field, then replace the field content with:

 

Left( FieleName ; length(FieldName) / 2)

[Lee Smith]

or

LeftWords ( text ; 1 )  & " "   & RightWords ( text ; 1 )