I'm evaluating a trial version of data generator and have a few scenarios that I'm wondering if the product can handle. One scenario is populating a column of file extensions based on a full filename in another column. I don't have any python knowledge, but I'm guessing that you should at least be able to address this with a python script? For example, the filename could be image.jpg and the file extension would be jpg.
Comments
1 comment
-
Hi @slimshaky!
Yes, I believe that should be possible and the post here may help: https://stackoverflow.com/questions/6169324/partition-string-in-python-and-get-value-of-last-segment-after-colon
You can split the filename using '.' as the delimiter and then return the last element of the split string. It may include something like:
return mystring.split('.')[-1].
Hope that helps!
Add comment
Please sign in to leave a comment.