Excel Functions (Left and Lenght)

Hello,

I am trying to use Function component. I would like to take a value, cut the first symbol and use the rest. In excel I can accomplish it with help of functions Len and Left (or Right). There are similar analogs in Centerprise Length and Left. However, I am not sure how to combine them in one Function block. Do I have to use multiple Function blocks?

Also function Left gives me two entry points "str" and "noOfChars". I know what I need to link to "str", but I am not sure what I can link to "noOfChars". I know that I need to get 3 symbols from the left.

In addition, I wonder if it possible to accomplish the following task in Centerprise. Open every single excel file in some folder, in every file find some string (for example "total"), delete whole row containing this string and save file in different folder? If it is possible what would be the relevant blocks

Mike O'Quinn August 17, 2011 18:49

You can indeed chain multiple functions together.

For the other input for a lot of the functions, it is best to use a constant value. You'll find this component in the toolbox.

As for the total row, you can have a data quality rule that checks for the validity of the record (where a total row would fail). Write a new excel file with only those valid rows. This is the extent as to which Centerprise can do this sort of processing.

To do this or multiple files, take a look at the FileSystemEntries source. You can loop through a directory and supply the file path to an inner workflow that will a) process that file and then b) delete or move the original file.

Excel Functions (Left and Lenght)

1 comment