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
- The maximum value for float64 and complex128 type in Go
- How to split a column into two columns to separate two values in a cell when some cells don't contain two values to split using dplyr in R
- Remove last two path components of a path in a shell variable
- Recursion - Not Returning Values as Expected
- How do you know a variable type in java?
- How can I have a variable sample time for logging data in simulink?
- why indirect variable reference not work in bash dictionary
- IntelliJ IDEA underlines variables when using += in Java
- Putting a variable value into a input's string
- Simple Find and Replace Text in Sublime Text Using REGEX
- What is the difference between var and val in Kotlin?
- C# Message Box, variable usage
- when declaring an object how do you specify the no name if it's ambiguous
- How to pass a Bash variable to Python?
- Avoid evaluation of variables in a Makefile
- Using a variable to set a userform object name
- How to pass parameters or arguments into a Gradle task?
- in gnucobol, sub programs of one parent can't invoke each other
- How to keep track of where you are in an Ansible loop?
- Excel VBA - Having issues while Using Range Function with multiple variables in Embedded Charts
- How do I 'declare' an empty bytes variable?
- How to create module-wide variables in Python?
- How can you print a variable name in python?
- How to insert string into a string as a variable?
- I'm trying to set up a header, included inside the layout file, that imports the online status of a user. But it is only refreshing when I navigate
- Using Template Stages in Azure DevOps Pipeline
- Passing Variables between Stages in Azure DevOps Pipeline
- subtracting variables within two different netcdf files
- Ansible variable undefined syntax error using set_fact
- Local variable being stored over different function calls. weird