
Contributor III
2019-01-24
09:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
KeepChar and length
Hey Guys,
I need a little help with the keepChar and length functions. I have an if function with 2 conditions using these functions.
if( KeepChar("Number",0123456789) and len("Number")=12 ,KeepChar("Number",0123456789) ) AS Number(this should be a KEY_VALUE)
The Problem is that the extracted number-data contains of numbers with spaces e.g. 123 456 789 123. So in total I have 12 digits but with spaces I have a length of 15 not 12. Any suggestions how to transform this data into something which should be seen under "Number" with a 12 digit number without spaces?
561 Views
2 Replies

MVP
2019-01-24
09:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if( KeepChar(Replace("Number",' ',''),0123456789) and len("Number")=12 ,KeepChar(Replace("Number",' ',''),0123456789) )
554 Views

MVP
2019-01-24
09:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are you looking for this may be?
If( Len(KeepChar("Number",0123456789)) = 12, KeepChar("Number", 0123456789) ) as Number
