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

Midstr>var,1,40,var


Any way to do this in Java?

perfect thanks

Hi, I'm looking for something similar however without the input box. Something that will simply cut a variable to 40 characters.

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

yep! it worked. I'll have to look into that dde code. Anyone else have any idea what i'm doing wrong here?

it shows 5. No additional spaces. So thats working correctly I believe

Thanks it looks a little better except now i'm getting: 5*1.5 as "price" Let>k=1 Label>start setfocus>Excel* dderequest>Excel,C:\Program Files\screen-scraper basic edition\ItemsforVendio.txt,R%k%C9,cost,10 StringReplace>cell,SPACE,,cell Let>a=1.5 Let>price=%cost%*%a% MessageModal>cost MessageModal>p...

Trying to multiply "cost" by 1.5 and input the result in the next row as "price" Price always shows up as simply "price" rather than the numerical value Let>k=1 Label>start setfocus>Excel* dderequest>Excel,C:\Program Files\screen-scraper basic edition\ItemsforVendio.txt,R%k%C9,cost,10 StringReplace>...

Hi, I just need a simple script that can create a filename and path based on a directory. For example CreateDir>C:\Users\Ben's Asus\Documents\%cell%\%cell%.txt with "cell" being the variable to save to. Here is my full script for reference. Let>k=1 Label>start let>ret=test setfocus>Excel* dderequest...

Sorry that I'm thinking out loud. I believe I've realized my problem. I believe because the %fields_1% variable contains two columns it is creating an invalid file name. Is there any way to limit those results to each fields variable to represent one column? P.S these are "tab delimited" values Thanks

Let>comma=, Separate>line,comma,fields ReadFile>C:\Program Files\screen-scraper basic edition\water.txt,TheFileData Separate>TheFileData,CRLF,Lines Let>comma=, Let>k=1 Repeat>k Let>CurrentLine=Lines_%k% //extract each field Separate>CurrentLine,comma,fields Let>filename=%fields_1%.txt WriteLn>C:\Use...

This is almost exactly what I'm looking for. Except maybe a lot different. I am trying to create web pages from an excel sheet using each line for a page and each cell as a variable. Therefore it would require the program to go through each line one at a time as it creates each page. I don't know if...

I'm looking for a simple script to press the back button if a variable is returned as "null" or is not a number.

This is a "screen scraping script" which gathers variables from copy/paste

so if f=null
then press backspace
else
then carry on

something like that. thanks for your help

that worked beautifully. thanks. now i just have a simple easy question. i'm trying to do the click tag function and its not working. heres my new script // Generated by MacroScript WebRecorder 2.1 // Recorded on Wednesday, January 12, 2011, at 09:50 AM //Move the mouse cursor out of harm's way to a...