Skip to main content

I have this numbers:


9612804582458251440721

9612804512755470468057

9612804512755470468088

9612804512755470468125,9612804512755470468132

9612804582458251441063

9612804512755470468217


I want to grab in a new column all number’s BEFORE the “,”


How can I do it?

Hi there! This formula should do it…


LEFT({Field Name}, FIND(",", {Field Name}) - 1)


Tanks for answering


But now it only shows up IF there is a “,”


The one with a “,” is blank


Please look on this Image


Tanks for answering


But now it only shows up IF there is a “,”


The one with a “,” is blank


Please look on this Image


Try


LEFT(
{Field Name},
FIND(
',',
{Field Name}&','
)-1
)

That concatenates {Field Name} with a trailing ',' so all fields will match the FIND() criteria.


Empty fields will cancel out with FIND(',',{Field Name}&',')-1 equal to 0.


I am still only getting half


Why is this still empty?


Screenshot


I am still only getting half


Why is this still empty?


Screenshot


Because I put the &',' in the wrong place. 😊


Try the edited formula in my now-corrected reply, above.


Thank you very much, now its good


Reply