https://community.jmp.com/t5/Discussions/Truncate-or-Split/m-p/336279#M58365 <P>or</P><P>for a 16 digit number this formula would give you the 7 left digits, where you can also use trunc instead of round ...</P><PRE><CODE class=" language-jsl">Round( :event_time / 1000000000 )</CODE></PRE> Sun, 22 Nov 2020 21:32:11 GMT Georg 2020-11-22T21:32:11Z https://community.jmp.com/t5/Discussions/Truncate-or-Split/m-p/335748#M58320 <P>I have a large dataset and I would like to split with the first 7 characters in a new column. I am trying to use the left function, but I am getting an error.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="riksmith_2-1605829319633.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/28492i1019BCE53C8A7DE7/image-size/medium?v=v2&amp;px=400" role="button" title="riksmith_2-1605829319633.png" alt="riksmith_2-1605829319633.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="riksmith_1-1605829278285.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/28491iDC7ADE43601C80F1/image-size/medium?v=v2&amp;px=400" role="button" title="riksmith_1-1605829278285.png" alt="riksmith_1-1605829278285.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="riksmith_0-1605829221587.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/28490iE901ADF242C057B8/image-size/medium?v=v2&amp;px=400" role="button" title="riksmith_0-1605829221587.png" alt="riksmith_0-1605829221587.png" /></span></P><P>&nbsp;</P> Sat, 10 Jun 2023 23:22:35 GMT https://community.jmp.com/t5/Discussions/Truncate-or-Split/m-p/335748#M58320 riksmith 2023-06-10T23:22:35Z https://community.jmp.com/t5/Discussions/Truncate-or-Split/m-p/335770#M58321 <P>try</P> <PRE><CODE class=" language-jsl">left( char( :event_time ), 7 )</CODE></PRE> <P>I am guessing that your event_time column is numeric</P> Fri, 20 Nov 2020 01:09:40 GMT https://community.jmp.com/t5/Discussions/Truncate-or-Split/m-p/335770#M58321 txnelson 2020-11-20T01:09:40Z https://community.jmp.com/t5/Discussions/Truncate-or-Split/m-p/336279#M58365 <P>or</P><P>for a 16 digit number this formula would give you the 7 left digits, where you can also use trunc instead of round ...</P><PRE><CODE class=" language-jsl">Round( :event_time / 1000000000 )</CODE></PRE> Sun, 22 Nov 2020 21:32:11 GMT https://community.jmp.com/t5/Discussions/Truncate-or-Split/m-p/336279#M58365 Georg 2020-11-22T21:32:11Z