DSXchange

I have dates coming from the source Flat file as Varchar 11022006 (MMDDYYYY) I have to load this into oracle as MM/DD/YYYY . I acheived this by using FMT(src_out_AMA_LICENSE.Raw_St_Lic_expr_dt,'R##/##/####') .It loads as MM/DD/YYYY in varchar field in oracle. how do i convert MMDDYYYY into MM/DD/YYY...

us1aslam1us ,

Ray addressed me as Son in one of his posts .So i just corrected. that's it.

what do you mean by "Are you kidding".

I am a female not Male .

Ray

I am your daughter not SON

I see that Disable BBCode in this post option is checked for me by default.
i unchecked it
:D

i fixed the problem . i changed the order of my stage variables. i had vcount -Dcount(sv1,' ') sv1-Trim(src_hcrs.City_State_Zip) now it is sv1 first and vcount next . i am extremely sorry for my act of ignorance. the logic is working and the results are as i expected. Thank you everyone paddu

code tags did not help . when i previewed the data , it is trimming the spaces .

may be i am using it incorrectly.

i did something like this

[code]a b[/code]

results in single space between a and b

kumar ,

i need to tell one more thing

In the actual data there is one space between city and state and two spaces between state and zipcode . After Trim function there is one space between the city,state and zip.

so i used only single space as delimiter

i do not know when i posted the actual value with the spaces after the zipcode in the first field ,the previous post removed the spaces.

how can i post the data with spaces. what option should i use?

Actual Value,Trim(field),vcount,city,state,zip 'S PASADENA FL 33707 ','S PASADENA FL 33707',1,'S','PASADENA','FL' the true zipcode is missing but for some records it is fine. to understand easily ,i used quotes to differentiate the acutal length of the data and comma to separate the fields .

i did exactly the same way .

Field ,Trim(Field),vcount(count of delimiter),city,state,zip

(If( Write_Reversal.END_USER_NAME<> Read_SpaChannelHistory.END_USER_NAME Then 'AOO |') Else '') : '|' : ( If (Write_Reversal.CHANNEL_FLAG<> Read_SpaChannelHistory.CHANNEL_FLAG Then 'CF' )Else '' )

try using this

i don't mean that there are some records with single delimiter. i do not know why for one record the Dcount is 4 and for the other 3. they are exactly same data . Am i missing something. before triming the field there were two spaces between the state and zip . after the trim there is one space betw...

as suggested i did used two stage variables 1. sv1-Trim(input.field) 2.vcount-Dcount(sv1,' ') transformer logic for City-if vcount>3 Then Field(sv1,' ',1):' ':Field(sv1,' ',2) Else Field(sv1,' ',1) state-if vcount>3 Then Field(sv1,' ',3) Else Field(sv1,' ',2) zip- if vcount>3 Then Field(sv1,' ',4) E...

I have a fixed width file. One of the column is City_state_Zip length 30 i need to split the column into three separate columns city,state& zip. how do i achieve this? i tried with field function with space as a delimiter but did not help me because my data looks like this .The city has two valu...

Craig-Well... there ya go. Your time transformation is failing for some reason. Now just need to puzzle out the why of it... yes that's why i asked ,was something wrong with my right function (time transformation)???in my earlier post. I used the stage variable you suggested and finally the results ...