Forum Discussion

kimmatsumoto's avatar
kimmatsumoto
Contributor
7 years ago

How do I remove a datetime stamp from a text file?

How do I remove the datetime stamp from the following text file?   "SYSDBA","05/17/2017 1:09:40 PM","Update","","BRANCH","1","0"     Thanks, Kim
tristaanogre's avatar
tristaanogre
Esteemed Contributor
kimmatsumoto wrote:

Yes, ListViewItemToCSVFile4 is writing output (in text format) to the file tempFileName4 which gets compared to the baseline file (FileName4).
The file tempFileName4 will have the timestamp which I want to remove and save and then compare it against FileName4 (baseline) which will not have a timestamp.
FYI...to get the baseline file I copied tempFileName4 and renamed to FileName4 and then manually deleted the timestamp.

Exactly... so... edit ListViewItemToCSVFile4 to filter out the datetime stamp in it's writing to your temp filename.  Again, detection can be used with aqString.StrMatches and then just write out the line to your file without the date time stamp.

joseph_michaud's avatar
joseph_michaud
Moderator
7 years ago

If you know that the timestamp is always the second element in the comma separated string, you can use JScript/JavaScript code directly.  The following example creates a new array with second element removed.

 

function tryme()
{
	var str = "aaa,bbb,ccc,ddd";
	var arr = str.split(",");
	Log.Message(arr);
	
	var arr2 = Array().concat(arr.slice(0, 1), arr.slice(2, arr.length));
	Log.Message(arr2);
}