Example: Standardize different formats
Last updated
Last updated
Imagine your TaskBots saves number of followers to your table. However, the platform of your choice displays the number of followers in a format like "7k" (which stands for 7000). And this can lead to problems if, for example, you want to use that number for numeric comparisons to qualify only those leads that have a certain amount of followers.
To solve this problem, follow the steps below.
Step 1: Use Format Data with action Remove Words to remove "k".
Step 2: Use Number Operations building block with action Multiply to multiply by 1000.
