Hi Mate, thanks again for all the help, wondering if you could help me with developing my solution here, finding many difficulties getting this to work.
Above I want to get all ID’s but separated by BF, or PP.
If let’s say, there is Linked Accounts - BF_123456, BF_7890, PP_123456 |
If the IDs are BF starting, I want to get the BF ID’s in a ‘123456, 7890’ format, so I can input into a data script to run. But the script will be specific for BF IDs only.
Then I would like to store the PP ID in the else part of an IF statement, so be able to have them separated in 12345, 12345 format (potentially there would be more than one, but maybe none at all). These will then be run in a different script, these PP IDs will then have to be run in one of two scripts, which is determined by the date of the account (before 2016) but I can run all PP IDs in both scripts regardless to see if any output and append to sheets accordingly, so not too worried about that.
Does this make sense? Any way you could help?