Hi,
I'm currently using this formula to pick sheet from my Excel file but sometimes the sheet name is "Deal Report(48)" "Deal Report (EOD)""Deal Report (85)" can anyone please tell me what changes do I need to make to my current formula to pick up sheet with any any letters after Deal Report? Thank you
@srk0609 is your sheet name coming from a different field? Or how are you forming this? What do you want to do with this sheet name and full filepath?
underlined red is .xls file name, underlined in blue is sheet name within xls file. This sheet name can be Deal Report (48), Deal Report (8) basically Deal Report + anything so how do I do pick up the sheet in that case
@srk0609 in the input file there is an option to output file name as full path. The fullpath field will have the sheet name as well. you can use a formula to extract the sheet name. Can you provide a sample input file and expected result to get more clarity?