Attachment formula - len

Hi @Scott_Gardner1,
I wasn’t able to get your formula to not work.

I slapped together this script to allow you to review all of the URLs in an attachment field, maybe this can help you find your issue

let table = await input.tableAsync('Pick a table');
let field = await input.fieldAsync("Pick a field", table);
let queryResult = await table.selectRecordsAsync({fields: [field]});
let record = queryResult.getRecord(queryResult.recordIds[0]);
output.inspect(record.getCellValue(field));

Hi,
On a brief look formula removes closing bracket at the end and searching for ‘http:’ from the position 133 chars back from the end, supposing a single link together with filename can easily fit into this interval, but not two links. Is it dejavu or I wrote something like this some time ago, as a quick fix?
of course, such approximation may sometimes fail when attachment has too long file name.
i have seen a way to find exact position. find number of attachments (by substitute commas or http and then compare length). then use this number in substitute http, fourth parameter (means instead of replace all, replace only given occurence.

but that’s too long, and i was lazy enough to try understanding some regex formulas here. And when i got it (at least part of them),I can change it according to my goal. In your case, it’s

REGEX_EXTRACT({Attachments}, “[^,]*$”)

Thank you! I changed the Char to -300 and it worked.