Hi, there are two separate issues I'm currently having when trying to complete my journal entry.
1. When I use the find and replace tool, I can't seem to bring along all of the necessary data. For instance, I need to pull all Values/Sum_Values along with the CTL4/CTL5. For some reason, it's only pulling some but not all. The "set 2" data set is the format I'm looking to have. The Combreg input/name should match the G/L Categories.
2. The" test output" file is an example of where the values are supposed to be placed. I was trying to create a formula where - if there is [^a-zA-Z0-9], replace the language in the cell with the corresponding value. But apparently [^a-zA-Z0-9] doesn't mean characters in the cell? I'm not entirely sure.
The "Total Invoice (CDN)" in set2 can not be found in set 1.
Can you double check the data?
For this case, A joint tool should be applied.
Hey @jalizmaldonado
The Find-Replace is useful only if you want to do a replacement or perhaps add 1 field. If you need to add multiple fields, use a join tool, then you get full control over the number of fields.
In terms of matching to something like [^a-zA-Z0-9] - this would generally be done with either a regex tool, or a formula that uses Regex.
If you need to get some practice on Regex - I can't recommend http://regex101.com enough!