- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2023 11:55 AM
Hi All,
This is hopefully a basic and quick fix. I've got a concatenate formula that works beautifully to join a suffix to a base number, but part of the suffix is a price, and I need to have the "." removed from the string. Here's what I have so far:
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2023 03:05 PM
Welcome to the Airtable Community!
try this formula:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2023 03:05 PM
Welcome to the Airtable Community!
try this formula:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2023 04:27 PM
Thank you so much! I was trying to add Substitution to the end of the formula, rather than wrapping it around the concatenate. It'll probably be a bit before I truly understand the syntax, but thank you for the help!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 23, 2023 04:49 PM
Related to this formula, I want to craft an IF statement to add a character to the output under specific conditions, but I'm not sure how to write it since the condition is based on character count.
Essentially, if {US Price} is less than 4 digits, I need a 0 to be placed after the 5. I've found the formulas that will pull a number of characters based on positioning, but not ones that produce an output based on the number of characters in the source string.
