SOLVED
Field Character Count
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jodester77
5 - Atom
‎01-05-2018
11:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm trying to build a character count into a formula. Basically, if field 1 is 9 characters long, I want it to give me a certain value in a new column. I can't seem to figure out how to do this. I'm not matching a certain character, just need a count of the characters in field 1. Any suggestions?
Solved! Go to Solution.
Labels:
- Labels:
- Expression
- Transformation
2 REPLIES 2
MarqueeCrew
20 - Arcturus
‎01-05-2018
12:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
IF Length([Field 1] = 9 THEN "NINE" ELSE Null() ENDIF
Null() could be anything that you wanted. "NINE" could be "9" or 9 depending upon the data type. You could even just make the column a byte and use:
Length([Field 1])
Then decide what to do later....
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
‎01-05-2018
01:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That did exactly what I needed. Thank you!