Forum Discussion
Solved
Removing a decimal from a string when it occurs
I am working with version numbers that are represented by a string of numbers, separated by a few decimals - this can vary from version to version. I only need the first 3 numbers of each version. Fo...
Hi krfaughnan,
Text.BeforeDelimiter([Data before trimming], ".", 2)
On the query editor add a new column with the following formula.
As you can see in the documentation the first parameter is the text you want to trim, second parameter the character that you want to trim from, and the last parameter is the position of that character in this case is your second.
Regards,
MFelix
Hi krfaughnan,
Text.BeforeDelimiter([Data before trimming], ".", 2)
On the query editor add a new column with the following formula.
As you can see in the documentation the first parameter is the text you want to trim, second parameter the character that you want to trim from, and the last parameter is the position of that character in this case is your second.
Regards,
MFelix
Perfect! Thank you - that worked!!