What are the challenges you face when working across database platforms? Take the survey

Can you calculate a substring based on another column?

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.


Sign In or Register to comment.