Search results for query: *

Can you tell me where is the dictionary objects as an array. I dont want to open file and read the file since biztalk is doing that for me. any ideas

PHV, After mapping source field to destination field in biztalk, we pick flat file fir testing the data which is being provided by the customer. I could also do this by connecting to the database. In the mapping filed there is a provision called functoid where i can write a vbscript to do get...

Tsuji,richard Thanks for your reply. Bascially Biztalk does provide functoid where we can create scripts(function only). What we are doing is mapping in source field to a destination field,when we do that we have to make sure that accession numbers (which is unique for each patient)does not...

Tsuji, Thanks again for quick response,but i dont want to open the file and read the file since the biztalk mapper does that for me. All i wanted to do is that before mapping the fields i want to write a function in the accession field which will give me only those records for which there are...

Tsuji, Thanks for your reply. But i would like to create the same logic in a function with array. Because I am working on biztalk mapper and the mapper reads the file for me and i have to look for only those records for which there are no duplicates and then map. The data will look like 1234-8...

It should return the accesion number which are not duplicates. Actually when we map and run the file we should get all the accession numbers which do not repeat(duplicate). Actually how do we do it to get all the accession numbers which do not repeat. Thanks for your precious time on this...

Can we write the same script in a function. Like i said the biztalk mapper reads the file for us but we can format the output based on the script whatb we write. Do you know how to write the same in a function. Thanks a lot!

I have another question. How can we hard code a value like this. If teststr="Accession numbers 1324-9, patient name roger smith, DOB 14/06/1992, procedure code 124567." then the following code: Because we will not know the values what we have. The function has to read and pull out only the non...

Actually biztalk mapper reads the file and there is something called functoid where we can format the output to what i had in my example. so can we do what you have done in your script in a function.so that we can just format the output to what we need. thanks again for your time on this.

Thanks a lot for your help. Biztalk mapper accepts only functions, so is it anyway i can write this in a function. Also what if i have to do samething what you have done for accession number to other patient details like dob, sex, name etc. Thanks again for your help and support. Please respond

I did and pulled this file from that bunch and this is what i found. But i dont know how to look for the duplicate value from the file. any help please Const ForReading = 1 Dim fso, MyFile, Text, Fail Set fso = CreateObject("Scripting.FileSystemObject") Set MyFile =...

I dont have any other script. like i said i am new to this and i am not sure how to go about it. can you tell me how to write the script that reads and parses the example. Thanks for your answer.

Here are my answers Where is the code reading and parsing the input file ? The for loop with lbound and ubound is doing that right? Where is the code calling your Check_Val function with an array parameter you destroy within the function ? Where is the code writing the result ? At the end i am...

This is what i ahve so far. I am not sure about the dictionary object? Can you send me the code for this. That will be great help. Please respond Function Check_Val(ByRef arrArray) arrArray=array(33999-9,1090668-7,1108756-0,1117483-4)...

Input examples: There are about fields in the file. This file has details about accession numbers and patient details like name ,sex, dob,procedure code etc. This accession numbers are unique for each patient. But they are repeating for every procedure code the patient has...

This is bascially Biztalk mapper field. we have a text file which has series of columns having data and this data is bascially patient details like patname,acession number,dob etc.. These acession numbers repeat sometimes if the patient details are multiple. so what i would like to do is to look...

hello, desperately need help on this

Tsuji, Thanks for your reply but i dont know the data in the array. I am looking at a field which has numbers and if there are duplicates in the field. I want the function to return only those numbers which does not have duplicates. Thanks for your effort.

Is declaring an array like this correct? Function Check_Val(ByRef arrArray) Dim row As Integer, j As Integer For row = LBound(arrArray) To UBound(arrArray) - 1 For j = row + 1 To UBound(arrArray) If arrArrray(j) = arrArray(row) Then Check_Val =...

when i try to run this script i get an error like 'type mismatch' for lbound. any one knows why? Function Check_Val(ByRef arrArray) Dim row , j For row = LBound(arrArray) To UBound(arrArray) - 1 For j = row + 1 To UBound(arrArray) If arrArrray(j) <> arrArray(row) Then Check_Val = arrArray(row)...