SOLVED
Keep the first 6 characters/numbers (Trim / Regex ??)
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
G_SAND
8 - Asteroid
‎09-27-2017
06:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi.
I have a data set that can be numbers or string:
0.385
19.656
33.133
270.268
319.694
650.000
157.500
13499.460
For various reasons I only want the first 7 characters/numbers.
So the only 1 that would change in the list above is the last one, to 13499.46. I can't change the fixed decimal as there are some smaller numbers that need to be at 3 decimal places.
I'm not great when it comes to working out the Trim functions or RegEx so any help would be great.
Thanks
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
3 REPLIES 3
KaneG
Alteryx Alumni (Retired)
‎09-28-2017
12:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
20 - Arcturus
‎09-28-2017
04:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If it can be a string, then you'll only need:
Left([field],6)
:)
Left([field],6)
:)
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.
ACE Emeritus
‎09-28-2017
06:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
