Recent content by tiwa5780

I am trying to spy a web page using HTML mode (https://www.xe.com/currencyconverter) but when I hover the cursor over the fields that I want to spy, they are not getting highlighted. Please see the attached screenshot. The green box is not coming over the Amount field.

Thanks..it works

Hi, How can we copy the values from one column to other within a same collection.

But doing that will convert the date to text format, if date is displayed as 12/10/2018, then formatting it will show 10 Dec 2018

Yes, I formatted it using the Convert function but still the value in the new column is showing up as Date Time

Hi VJR, Thanks for reply. But in the code stage, when I am trying to change the data type, it is getting changed to datetime not just date. Please see in the image also. In the Inputs, I have changed the data type to Date, but in code it says System.Date Time in the Parameters section. Due to...

How can I convert the data type of a collection field from Text to Date? We can convert the Date field values from text to Date type. For this we will have to use a loop so that it access all the rows of collection one by one and then use a calc stage to convert the Date field values from text...

I am importing an excel sheet as a collection which contains some columns among which one column is Date. Then I am trying to sort the collection by the Date column but as you know all the columns in excel are treated as Text so in the collection also the Date column is of Text data type due to...

Thanks a lot VJR! You are the best.

Hi, Suppose there is an application in which a table is present which contains a field named Employee ID which is a hyperlink field. And when we click on the Employee ID value, then the employee details are displayed like Name, Phone number, etc. Now suppose there are N number of Employee IDs...

Hi, Will the 'Get Worksheet Names' action return the output as a collection?