Trim

allthenames · Post by **allthenames** » Thu Jun 28, 2012 12:40 am

Is there any way to trim or limit a variable to 40 characters? I am imputing data into excel and for my purposes the data can only be 40 characters long.

With the Trim> command?

Thanks for your help

JRL · Post by **JRL** » Thu Jun 28, 2012 5:30 am

MidStr> rather than Trim>

Code: Select all

Let>var=whatever alphanumeric string you want the variable to be 
Midstr>var,1,40,var

mdl>var

allthenames · Post by **allthenames** » Fri Jul 06, 2012 3:10 am

perfect thanks

allthenames · Post by **allthenames** » Sat Aug 25, 2012 4:13 am

Midstr>var,1,40,var

Any way to do this in Java?

Me_again · Post by **Me_again** » Sat Aug 25, 2012 5:17 pm

We don't do Java here, but Google is your friend

allthenames · Post by **allthenames** » Fri Sep 28, 2012 2:51 am

How would I go about adding an exception here? For the times when the variable is less than 40 characters?

Thanks for your help/patience

olllllliii · Post by **olllllliii** » Fri Sep 28, 2012 1:10 pm

Let>var=whatever alphanumeric string you want the variable to be
Length>var,varlength

IF>varlength>40
// if above 40 cut to 40
Midstr>var,1,40,var
ELSE
Midstr>var,1,10,var
// if less 40
ENDIF
mdl>var

Kind regards
Oli

Trim

Trim

Java?

exception

if >40 or <40