Replace character for decimal point
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello
I'm trying to run a workflow and currently part of is to change dots to commas and commas to dots as some bank statements use commas instead of dots as their decimal point and use dots as their comma separator. An issue I had recently with my current workflow is when a balance went under 1,000.00 and therefore was formatted as 100.00.
Is there a way I can fix the dot to be two decimal places and remove any other special characters before the decimal point? I don't necessarily need the thousand separators.
Thanks in advance!
Solved! Go to Solution.
- Labels:
- Output
- Tips and Tricks
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So this might have extra steps, but here's how I would do it (assuming this is a string field)
replace(replace(replace([field_name],'.','|'),',','.'),'|',',')
Basically, we replace the dot with some other arbitrary symbol that we know won't be used, then change the comma to a dot, then change that arbitrary symbol to a comma.
Or just remove the dot and replace the comma:
replace(replace(field_name],'.',''),',','.')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have you looked in the User Settings and tried changing the Thousands Separator to None?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
