Okay bro i need to extract the column inside the some string we can use for string split right if you don't mine can you show any demo oml for this 

Thanks 

I find it confusing "extract the column inside the some string..", it is the other way round i.e. a string is contained in cell of a column. Please share your OML so that I better understand your scenario and be able to help you further.

Thanks,

Junaid

Please find attached the working OML for one column.

Tq so much for you reply any idea about to extract the date from that excel file 

You can read it the same way

1. Read cell value

2. If date is clubbed with some other text, then extract the date part using appropriate actions in Text extension.

3. Further if you want to store it in variable or entity attribute of type Date, then perform the necessary conversion from text to date.

Hope it helps!

Junaid

thanks for your reply

i have tried this way please check if i am right or not? i am getting this kind of output how to remove this empty records

thanks 

The text "Jun 2023, 4 To 10 (W-23)" does not even look like a valid date format, instead it is a range of dates June 4th to June 10th 2023 associated to a week which is the 23rd week in your excel.

sorry i didn't get that can you show any demo for this please 

thanks

Not sure what kind of demo you are expecting, I was just trying to explain the data in your excel which you are referring to as Date.

what i am trying to do means i need exact date from the excel file. what i tried means i can extract the year and month then extract the day so that i am planned but  i am think it is very difficult way to do that. can you suggest any easy way to achieve this 

thanks and regards

karthick

Once you have the day, month and year information, you just need to format it as date. Please refer this post

https://www.outsystems.com/forums/discussion/68021/date-format/#:~:text=Basically%2C%20it%20creates%20a%20new,MM%2Ddd%20format%20you%20want.

before that i need to extract those data right. now i am extracting the first row values second row values will have the day of the month if you dont mine can you help me to fix this one issue please i am new for outsystems.

i am not able to edit the input file how i can achieve this any suggestions

thanks