Data Cleansing

[Former Member]

Hi Guys

We have a situation where we have a large volume of data that now requires some cleansing. For example we need to trim the leading blanks from one field and also we need to do some simple string manipulation on another.

Can we do this kind activity on import?

Rgs

Con

[Former Member · Accepted solution]

Hi Con,

You can manipulate the field values by

Map the respective fields and then right click on source field select "<b>SetValue Conversion Filter</b>" from context menu.

<u>

To trim leading blanks:</u>

Select<b> Replace</b> from context menu and place a space in "Find What" and keep "Replace with "as empty.

<u>

For simple string manipulations:</u>

You can specify <b>various operations</b> like: Normalize, Change Case, Accept Truncated value and specify operator .

Hope this helps you.

Let me know the result

Thanks and Regards,

<b>Sagar Sonje.</b>

<b>Mark Helpful Answers</b>