Pattern Data Help

[dsn076]

I am trying to extract pattern data from the following web page:


I can grab most of the data I want except the date/time variables. Is there a way I can tell the pattern data extraction to use the "Before" and "After" options? Or is there a way to tell the script to look at a specific html tag?

The data grabs like this:

Sale Completed: 2012-02-06 10:43 EST

I just want to grab the date/time :2012-02-06 10:43

How can I do this with pattern based data? Could I extract the data then use a "Read from csv" command to loop through the date/time field and do a "Before and After" statement to delete the parts of data I don't need? Any thoughts or ideas?

[forumstaff]

Hello,

Yes you are correct you can use Read from CSV file command to read data and change the values.

You may also try opening the CSV file using Excel command, which could be easy to navigate in excel and keep on changing values with the help of functions like “Get Value”, string operation “Before After” and “Set Value”.

If you can provide us sample CSV file with some data in it. We can help you provide Sample Task which can carry our the activities you are looking for.

[dsn076]

Originally Posted by forumstaff

Hello,

Yes you are correct you can use Read from CSV file command to read data and change the values.

You may also try opening the CSV file using Excel command, which could be easy to navigate in excel and keep on changing values with the help of functions like “Get Value”, string operation “Before After” and “Set Value”.

If you can provide us sample CSV file with some data in it. We can help you provide Sample Task which can carry our the activities you are looking for.

The read from CSV and updating the data works just great for what I am doing.

Thank you!

[forumstaff]

Hey,

Thanks for the note.