You are here

Normalizing Fields

Forums: 

Yesterday I was discussing a problem one of my co-workers was having:
One data file had
00201001 Length of 8
The other had
002-01-001 Length of 10

An easy way to normalize this is to create a computed field

SUBSTR( EXCLUDE( AcctNumb , "-" ) , 1 , 8)

I use Substring very often because it is extremely useful

If you have a field that you need to extract data from and it always starts in the same place and is the same length
Data 1: 16882123
Data 2: 2014AP16882P123
| | | |
SUBSTR( AcctNumb) , 7 , 5) + SUBSTR( AcctNumb) , 13 , 3)
This will return
16882123

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer