Altova Mapforce - How to use results from Tokenize at the same time in a database call?
At the moment I have this string format: "2134-123". Basically I need to split that string into both values, but I also need to use those at the same time to get information from a database table.
I have used tokenize with - as a delimiter, but that gives me a sequence. I've tried to use item-at two times with position 1 and 2, but the second value is always NULL. I know the sequence is correct, because when I use output to test, it says for example: "One or several additional values were skipped. The value "90105" was mapped. First skipped value(s): "4010"."
I need to map those two values to a database to get some output, how should I do this? Thanks.
Found help on the Mapforce forum, only difference with their explanation is that mine only worked after putting the input of the tokenize through a .txt file as passthrough. No idea why, otherwise it would be null.
https://www.altova.com/Forum/framehelper.aspx?g=posts&t=1100005107&find=unread
- Resource of Cost of Declaring Variables and Scope
- How to check 'late' variable is initialized in Dart
- Why is the asterisk before the variable name, rather than after the type?
- Is it possible to pass variable to WIX localization file?
- Is declaring multiple variables in the same var statement equivalent to chained assignment?
- Use of final keyword in Java method performance?
- How to calculate the amount of memory occupied by the variable in Pascal?
- How can I store MySQL results in different individual variables with one connection to the database?
- jquery variable in function
- Performance enhancements through use of public variables?
- Difference between declaring variables before or in loop?
- How to swap two variables in JavaScript
- In C#, why assign member variables to local variables and then use local variables instead of using member variables directly
- Check is [wildcard] Folder exist and set is as variable
- How to access Javascript variable values outside of the function
- How do I make a variable accessable from the TimerTask() run function in Kotlin (Android)?
- Names.Add in VBA using variables
- Can I pass a string variable to jq rather than passing a file?
- If $alt variable empty then fall back to $title in Wordpress custom function
- How do I print some text in bash and pad it with spaces to a certain width?
- How to powershell to give warning or error when using an undefined variable?
- PS: Add-Content Get-Date & concatenate variable
- NameError: name '___' is not defined
- Forced fixed variable length, can I do it easier than this?
- Variable for 1865345.934 in c++?
- shared global variables in C
- How to instantiate variable with name from a string?
- How to preserve state in a function?
- JavaScript OR (||) variable assignment explanation
- check if variable has a certain value from external js file in Laravel Blade