I have a table like below
select red highlighted data and replace at once without case sensitive
I need to change as like below table
Thanks in Advance.. _/\\_..
Page 1 / 1
I would consider using the DateTimeConverter (formally DateFormatter). You may need to use conditionals and/or split your input data as you have multiple input formats.
See https://www.safe.com/blog/2017/08/yet-another-awesome-datetime-update-evangelist165/ for a blog post about it.
I would consider using the DateTimeConverter (formally DateFormatter). You may need to use conditionals and/or split your input data as you have multiple input formats.
See https://www.safe.com/blog/2017/08/yet-another-awesome-datetime-update-evangelist165/ for a blog post about it.
that data is not time formatting data it just mistake
some times we are getting other universal words like SUN MOON.....
that data is not time formatting data it just mistake
some times we are getting other universal words like SUN MOON.....
If you want to turn FEB into 2, that's date formatting.
I would consider using the DateTimeConverter (formally DateFormatter). You may need to use conditionals and/or split your input data as you have multiple input formats.
See https://www.safe.com/blog/2017/08/yet-another-awesome-datetime-update-evangelist165/ for a blog post about it.
SOME OTHER DATA LIKE
SOME OTHER DATA LIKE
Do you have a lookup table to say RPR is 2 or hit is 3?
I would consider using the DateTimeConverter (formally DateFormatter). You may need to use conditionals and/or split your input data as you have multiple input formats.
See https://www.safe.com/blog/2017/08/yet-another-awesome-datetime-update-evangelist165/ for a blog post about it.
there is no specific table just we use replace
there is no specific table just we use replace
In that case have a look at the StringPairReplacer (Case Sensitive: No)
Hi,
There is no generic solution for this kind. Kindly find the workspace along with data used were attached to this thread. I have prepared based on the data you have presented.
For more data, you have to make sure the mapping because you are using JAN/jan/Raj=1
@rakeshreddy0996
@jdh
@pratap
Yes you can...as always ;)
You need to complete the dates first to get a valid date.
Then just read and write. In tcl we would say scan and format.
Here is a workspace.
You could replace the tcl by the fme datefunctions to achieve the same.
I mostly use this for info.
https://www.tcl.tk/man/tcl8.6/TclCmd/clock.htm#M26
addendum
@rakeshreddy0996
@jdh is correct. It boils down to date formatting