string split

string s = "tubo1|tubo2|tubo3";
string[] splited = s.split ('|') // it yields you array of three elements
"tubo1", ""tubo2", "tubo3"
// count is used if you want to reduce the number of elements returned

BizTalk Send Port Save File Micro

1. %SourceFileName%
2. %datetime.tz%
Local date time plus time zone from GMT in the format YYYY-MM-DDThhmmssTZD, (for example, 1997-07-12T103508+800).

Scripting Functoid Padding Integer

public string MyConcatsCount(int count){
             
              string  param1 = "0000000000"+ count.ToString();
               param1 = param1.Substring(param1.Length-10);
return param1;
}
=========
count=4
output: 0000000004

MAP- Records Appearing Multiple TImes

If Records are appearing Multiple Times don't forget to Joining Multiple Occurring element from Input and Output Schema

Get String after and before special character

namevaluestrg = "HHmm-ss";
 int di = namevaluestrg.IndexOf("-");
 string output = namevaluestrg.Substring(di+1);
 string output1 = namevaluestrg.Substring(0, di);


output: s
Output1: HHmm