topic Re: Decipher IDP remove instance of a space/empty character in Product Forum

Decipher IDP remove instance of a space/empty character

ncstephe — Tue, 06 Aug 2024 20:23:41 GMT

Hello -

I am capturing various fields from a document and depending on the quality/font formatting we receive, Decipher might pick up empty characters that I don't want to export.

example: firstna melastnam e @ domain. com

Is there a way to filter out these space characters?

Thank you!

Re: Decipher IDP remove instance of a space/empty character

Nandhakumar — Thu, 08 Aug 2024 05:40:07 GMT

Hi,

You wanted to remove the spaces in above mentioned example? like below

Acutal extracted value from decipher: firstna melastnam e @ domain. com

Expected output: firstnamelastname@domain.com

Re: Decipher IDP remove instance of a space/empty character

ncstephe — Fri, 27 Sep 2024 18:35:50 GMT

Thanks for the reply! Apologies for the delayed response. Yes, your example is exactly correct.

Re: Decipher IDP remove instance of a space/empty character

Nandhakumar — Tue, 01 Oct 2024 03:46:46 GMT

Hi @ncstephe ,

You can try with replace function under formula section of you DFD like below,

STRREPLACE(Field Name," ","")

Thanks,

Nandha